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: 1907
Get Number of connections active per each DataBase
Posted by Ranjeet_8 on 3/1/2013 under Sql Server category | Views: 1813
Get names of Tables which are not there in different Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 1925
Get names of all the tables in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2044
Count the number of Stored Procedure in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 1930
Count the number of Views in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2197
Count number of Tables in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2021
  • Return value from a Stored Procedure
    Posted by Akiii on 7/27/2012 under Sql Server category | Views: 2668
    How to use Transation in Stored procedure ?
    Posted by Ranjeet_8 on 1/31/2013 under Sql Server category | Views: 1806
    Reset identity column value in SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 2295
    How to get the last inserted record id from SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 15435
    Overcome DATEADD Error Functionality
    Posted by Manicse on 7/10/2012 under Sql Server category | Views: 2079
    Convert characters to upper-case and lower-case in SQL server
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2542
    When to use ROWCOUNT_BIG ( )
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 4136
    Use @@ROWCOUNT wisely
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 1959
    Number Of Rows Affected - @@ROWCOUNT
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2382
    Using CASE Statements In A SQL UPDATE Query
    Posted by Muralidosscm on 7/6/2012 under Sql Server category | Views: 1914
    Delete Duplicate rows in table using Common Table Expression
    Posted by Anu.Malik on 7/6/2012 under Sql Server category | Views: 3355
    To select time format in hh:mm (AM/PM) format
    Posted by Denny on 6/20/2012 under Sql Server category | Views: 2143