Sql Server Codes (1211) - Page 43

Code snippets submitted by registered members. You can also post a code snippet or tips and win monthly prizes as well as gain community credit points.

1211 records found.
 
Get Last SQL Statement executed in sessions
Posted by Ranjeet_8 on 3/1/2013 under Sql Server category | Views: 2011
Get Number of connections active per each DataBase
Posted by Ranjeet_8 on 3/1/2013 under Sql Server category | Views: 1919
Get names of Tables which are not there in different Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2046
Get names of all the tables in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2170
Count the number of Stored Procedure in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2066
Count the number of Views in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2327
Count number of Tables in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2147
  • Return value from a Stored Procedure
    Posted by Akiii on 7/27/2012 under Sql Server category | Views: 2821
    How to use Transation in Stored procedure ?
    Posted by Ranjeet_8 on 1/31/2013 under Sql Server category | Views: 1919
    Reset identity column value in SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 2463
    How to get the last inserted record id from SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 15673
    Overcome DATEADD Error Functionality
    Posted by Manicse on 7/10/2012 under Sql Server category | Views: 2198
    Convert characters to upper-case and lower-case in SQL server
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2662
    When to use ROWCOUNT_BIG ( )
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 4254
    Use @@ROWCOUNT wisely
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2090
    Number Of Rows Affected - @@ROWCOUNT
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2507
    Using CASE Statements In A SQL UPDATE Query
    Posted by Muralidosscm on 7/6/2012 under Sql Server category | Views: 2033
    Delete Duplicate rows in table using Common Table Expression
    Posted by Anu.Malik on 7/6/2012 under Sql Server category | Views: 3480
    To select time format in hh:mm (AM/PM) format
    Posted by Denny on 6/20/2012 under Sql Server category | Views: 2265