Dynamically controlling the number of rows affected by a SQL Server query

One thing you may need to do is dynamically return a set amount of rows based on user input. This could be for a search function, reports, dropdown lists or whatever. Instead of hard coding a set value you would like to pass in a variable that will then determine the number of rows to return. How can this be done with T-SQL?

Views created per table

Collect the views and schema for a table!

sp_getreferences

This script gets the f_key and p_key references from and to another tables

sp_desc

This script gets the object description, and works quicker than sp_help

Format Date

This scripts help to format date in different languages

Building Parent-Child Table Tree information

How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.

Understanding INNER join in detail

This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.

Identity Columns

Error Handling in Nested Procedures and Logging Custom Errors

Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.

The Many Uses of Coalesce in SQL Server

Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.