Blogspot - learnsqltips.blogspot.in - SQL SERVER Tips and Tricks
General Information:
Latest News:
What is the short cut for opening sql server from command prompt? 5 Feb 2013 | 06:36 pm
Command for opening Sql server management studio from run is: Go to Start --> Run --> Type " SQLWB " --> Click "OK"
What is the short cut for opening sql server from command prompt? 5 Feb 2013 | 06:36 pm
Command for opening Sql server management studio from run is: Go to Start --> Run --> Type " SQLWB " --> Click "OK"
How to delete duplicate records from a table in sql server? 4 Dec 2012 | 03:44 pm
There are lot of ways to delete duplicate records from table in sql server. Here in this article , I will tell you 2 methods through which you can delete duplicate records from the table. Example: ...
How to delete duplicate records from a table in sql server? 4 Dec 2012 | 03:44 pm
There are lot of ways to delete duplicate records from table in sql server. Here in this article , I will tell you 2 methods through which you can delete duplicate records from the table. Example: ...
White papers on sql server 27 Nov 2012 | 05:39 pm
Here is the link to my white papers on sql server: white paper on query plan in sql server
White papers on sql server 27 Nov 2012 | 05:39 pm
Here is the link to my white papers on sql server: white paper on query plan in sql server
NOCOUNT Command in sql server 6 Sep 2012 | 06:58 pm
NOCOUNT command returns number of rows affected by T-SQL statements after the command execution. Syntax for NOCOUNT is : SET NOCOUNT {ON/OFF} SET NOCOUNT OFF : By default NOCOUNT option will be se...
NOCOUNT Command in sql server 6 Sep 2012 | 06:58 pm
NOCOUNT command returns number of rows affected by T-SQL statements after the command execution. Syntax for NOCOUNT is : SET NOCOUNT {ON/OFF} SET NOCOUNT OFF : By default NOCOUNT option will be se...
What are the uses of SET NOCOUNT ON in sql server? 6 Sep 2012 | 06:13 pm
By deafault NOCOUNT will be set to OFF in sql server. This will return number of rows affected at the end of each T-SQL statement exceution. In a stored procedure which comprises of many T-SQL statem...
What are the uses of SET NOCOUNT ON in sql server? 6 Sep 2012 | 06:13 pm
By deafault NOCOUNT will be set to OFF in sql server. This will return number of rows affected at the end of each T-SQL statement exceution. In a stored procedure which comprises of many T-SQL statem...