HttpModule and HttpHandler

Important point to be kept in mind before using update and delete

Some points to be kept in mind while using NOT, AND & OR conditional operator in the sql query

Have You ever worked with cursor in SQL server? here is a simple example you can start with.

Exception Handling in SQL server is very similar to that used in different programming languages

In this blog, i am trying to explain the use of SQL SELF join with a real time example.

Have you come across some situation where you need to change datatype of some particular column of table. Here, I will explain how to change the datatypes of columns of a table.

One of the most important routes to high performance in a SQL Server database is the index. Indexes speed up the querying process by providing swift access to rows in the data tables, similarly to ...

Composite primary key in SQL Server

Grant vs With Grant option in SQL Server

Specifying the schema Name in the Table designer

Date formatting in SQL query

Replication and autonumber generation issue

LinkedServer is useful to fetch data from database located in another windows server.

Number of weeks between two dates in sql

Get current date In sql server ,oracle and MYSQL

Get the information of database in sql

Convert expression into LOWER / UPPER case in sql:

Get number of days between two dates in sql

Rounf function in sql