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: 1924
Get Number of connections active per each DataBase
Posted by Ranjeet_8 on 3/1/2013 under Sql Server category | Views: 1830
Get names of Tables which are not there in different Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 1947
Get names of all the tables in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2067
Count the number of Stored Procedure in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 1959
Count the number of Views in a Database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2211
Count number of Tables in a database
Posted by Akiii on 7/30/2012 under Sql Server category | Views: 2046
  • Return value from a Stored Procedure
    Posted by Akiii on 7/27/2012 under Sql Server category | Views: 2724
    How to use Transation in Stored procedure ?
    Posted by Ranjeet_8 on 1/31/2013 under Sql Server category | Views: 1817
    Reset identity column value in SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 2337
    How to get the last inserted record id from SQL Server
    Posted by Akiii on 7/10/2012 under Sql Server category | Views: 15485
    Overcome DATEADD Error Functionality
    Posted by Manicse on 7/10/2012 under Sql Server category | Views: 2097
    Convert characters to upper-case and lower-case in SQL server
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2567
    When to use ROWCOUNT_BIG ( )
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 4157
    Use @@ROWCOUNT wisely
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2007
    Number Of Rows Affected - @@ROWCOUNT
    Posted by Akiii on 7/9/2012 under Sql Server category | Views: 2406
    Using CASE Statements In A SQL UPDATE Query
    Posted by Muralidosscm on 7/6/2012 under Sql Server category | Views: 1937
    Delete Duplicate rows in table using Common Table Expression
    Posted by Anu.Malik on 7/6/2012 under Sql Server category | Views: 3395
    To select time format in hh:mm (AM/PM) format
    Posted by Denny on 6/20/2012 under Sql Server category | Views: 2159