SQL Server 2005

Stored Procedure in Depth

Stored Procedures can be defined as compiled SQL statements stored in the database. Using stored procedures has many advantages over simply calling a query from the front-end, especially in web applications and large size applications. Advantages of Stored Procedures: 1. Since the queries are executed as a batch, the network traffic is significantly reduced. 2. Execution time Stored Procedure in Depth

Sql Server: Insert comma separated values in different rows

This is a code snippet for a Stored Procedure which accepts a comma separated values in parameter @Retailers which needs to be stored in a table with different rows. One fine day i had such type of requirement and i fount this post in a forum. I felt like it to share with you. Declare Sql Server: Insert comma separated values in different rows

Views in Sql Server

A view, or virtual table, can be defined as an alternate way of collecting data from one or more tables in a database. Thus, the view consists of rows and columns just like a normal table that is generated dynamically when a query is executed. It, however, does not actually exist as a stored set Views in Sql Server

Row_Number function in SQL Server 2005

This article explains about the Row_Number function in SQL Server 2005. It explains whether SQL Server 2005 Row_Number function will support SubQueries or not. Introduction SQL Server 2005 have introduced new function  ROW_NUMBER to find the Row number of a particular column if its specified in orderby Clause The syntax for RowNumber is, SELECT ROW_NUMBER Row_Number function in SQL Server 2005