Categories
Similar Boards
Suggest a Link

SQL Server

You must be logged in to view the contents of this board.

Functions

Pin
  1. Using Table-Valued Functions in SQL Server
  2. How to pass parameter type table in sql function
  3. TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask - Simple Talk

Table-valued Parameters

Pin
  1. tsql returning a table from a function or store procedure
  2. How can I get user defined types definition in SQL Server 2008 R2 using SQL query?
  3. How to ALTER the Table Value Parameter

Stored Procedures

Pin
  1. ExecuteNonQuery() returns -1 when execute the stored procedure
  2. Everything You Ever Wanted to Know About SET NOCOUNT
  3. Accurately measure performance of stored procedure
  4. How do you measure the performance of a stored procedure?
  5. Insert results of a stored procedure into a temporary table
  6. How to share data between stored procedures

Error handling

Pin
  1. Handling Sql Custom Exception
  2. How to get sql error in stored procedure
  3. Differences Between RAISERROR and THROW in Sql Server
  4. What is the syntax meaning of RAISERROR()
  5. SQL Server TRY, CATCH i RAISERROR
  6. A Closer Look Inside RAISERROR - SQLServer 2005
  7. 3 more

Pagination

Pin
  1. A More Efficient Method for Paging Through Large Result Sets
  2. Pagination with OFFSET / FETCH : A better way

3rd party SQL scripts

Pin
  1. First Aid - Free Scripts, Downloads, Videos

Different topics

Pin
  1. Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions
  2. SQL Server : output inserted.Id join with inserted temporary user defined table
  3. INSERT-OUTPUT including column from other table
  4. Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE
  5. The MERGE Statement in SQL Server 2008 - Simple Talk
0 Comment
Comments or thoughts?
Submit
Cancel
or
Email a link to this board
Share this board on Facebook
Share this board on Twitter
Notice label will go here