Pagination in SQL Server

Many times we have to build reports which list customers/employees/orders etc in the system. At times when the systems are very large, the listing runs into several pages. Hence we…

Parsing XML data in SQL Server

To support multi-value params, many times we use XML data type as input param. There are multiple ways to parse XML data in SQL Server. Lets have a look at…

SQL CREATE TABLE

Tables are the basic structure where data is stored in the database. Given that in most cases, there is no way for the database vendor to know ahead of time…

SQL CREATE VIEW

Views can be considered as virtual tables. Generally speaking, a table has a set of definition that sets the structure of the table, and physically stores the data. A view…