|
|
-
Dinesh Sodani Liked 2 Years ago through Just Learned | 1 Point
One more enhancement i found with Query Editor of SQL Server 2011, we can trace the query with specific current session in SQL Server Profiler. For that just need to right click in Query Editor and you can find the option Trace Query in SQL Server Profi...
|
-
Dinesh Sodani Learned 2 Years ago through Just Learned | 1 Point
One more enhancement i found with Query Editor of SQL Server 2011, we can trace the query with specific current session in SQL Server Profiler. For that just need to right click in Query Editor and you can find the option Trace Query in SQL Server Profi...
|
-
Dinesh Sodani Learned 2 Years ago through Just Learned | 1 Point
GO command is not only a batch seperator but also acts as while loop starting from version 2005.Run this code and see the output
[code]
select 1
Go 5
[/code]......
|
-
Dinesh Sodani Liked 2 Years ago through Just Learned | 1 Point
GO command is not only a batch seperator but also acts as while loop starting from version 2005.Run this code and see the output
[code]
select 1
Go 5
[/code]......
|
-
Dinesh Sodani Liked 2 Years ago through Just Learned | 1 Point
GO command is not only a batch seperator but also acts as while loop starting from version 2005.Run this code and see the output
[code]
select 1
Go 5
[/code]......
|
-
Dinesh Sodani Learned 2 Years ago through Just Learned | 1 Point
GO command is not only a batch seperator but also acts as while loop starting from version 2005.Run this code and see the output
[code]
select 1
Go 5
[/code]......
|
-
Dinesh Sodani Learned 2 Years ago through Just Learned | 1 Point
The datatype of datetime value returned by sysdatetime() function is datetime2 and it is not possible to do arithmetic calculation on this datatype. Run this see the error message
[code]SELECT SYSDATETIME()+1[/code]......
|
-
Dinesh Sodani Liked 2 Years ago through Just Learned | 1 Point
The datatype of datetime value returned by sysdatetime() function is datetime2 and it is not possible to do arithmetic calculation on this datatype. Run this see the error message
[code]SELECT SYSDATETIME()+1[/code]......
|
-
Dinesh Sodani Liked 2 Years ago through Just Learned | 1 Point
When you create a folder in Windows say test... trailing dots are automatically removed. However you can create a file with trailing dots......
|
-
Dinesh Sodani Learned 2 Years ago through Just Learned | 1 Point
When you create a folder in Windows say test... trailing dots are automatically removed. However you can create a file with trailing dots......
|