|
|
-
adamgorge Liked 11 Months ago through Just Learned | 1 Point
Recently read an article, which explains the surprising trick to reveal the folder which has all system management shortcuts.
1. Create a new folder in any of drives.
2. Rename the folder with the text "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}...
|
-
adamgorge Learned 11 Months ago through Just Learned | 1 Point
Recently read an article, which explains the surprising trick to reveal the folder which has all system management shortcuts.
1. Create a new folder in any of drives.
2. Rename the folder with the text "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}...
|
-
adamgorge Liked 11 Months ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
adamgorge Learned 11 Months ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
adamgorge Liked 11 Months ago through Just Learned | 1 Point
Recently read an article, which explains the surprising trick to reveal the folder which has all system management shortcuts.
1. Create a new folder in any of drives.
2. Rename the folder with the text "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}...
|
-
adamgorge Learned 11 Months ago through Just Learned | 1 Point
Recently read an article, which explains the surprising trick to reveal the folder which has all system management shortcuts.
1. Create a new folder in any of drives.
2. Rename the folder with the text "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}...
|
-
adamgorge Liked 11 Months ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
adamgorge Learned 11 Months ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
adamgorge Liked 11 Months ago through Just Learned | 1 Point
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a...
|
-
adamgorge Learned 11 Months ago through Just Learned | 1 Point
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a...
|