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: 1964
Get Number of connections active per each DataBase
Posted by Ranjeet_8 on 3/1/2013 under Sql Server category | Views: 1871
Get names of Tables which are not there in different Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2003
Get names of all the tables in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2122
Count the number of Stored Procedure in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2012
Count the number of Views in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2262
Count number of Tables in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2099
  • Return value from a Stored Procedure
    Posted by Akiii on 7/27/2012 under Sql Server category | Views: 2770
    How to use Transation in Stored procedure ?
    Posted by Ranjeet_8 on 1/31/2013 under Sql Server category | Views: 1867
    Reset identity column value in SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 2394
    How to get the last inserted record id from SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 15598
    Overcome DATEADD Error Functionality
    Posted by Manicse on 7/10/2012 under Sql Server category | Views: 2141
    Convert characters to upper-case and lower-case in SQL server
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2617
    When to use ROWCOUNT_BIG ( )
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 4202
    Use @@ROWCOUNT wisely
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2042
    Number Of Rows Affected - @@ROWCOUNT
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2464
    Using CASE Statements In A SQL UPDATE Query
    Posted by Muralidosscm on 7/6/2012 under Sql Server category | Views: 1985
    Delete Duplicate rows in table using Common Table Expression
    Posted by Anu.Malik on 7/6/2012 under Sql Server category | Views: 3434
    To select time format in hh:mm (AM/PM) format
    Posted by Denny on 6/20/2012 under Sql Server category | Views: 2205