We can implement CASE statement in Update Queries. Instead of multiple update queries, you can implement multile condition by CASE statement to update a table or get the customized result. Ex : We...

Change the Background Row Color of the GridView control using MouseEvents without postback Change BackGround Color of a Row in Gridview when user moves mouse on a particular selecting Row, without...

Access ViewState Across Pages We can access the viewstate variables across pages. This is possible when we use Cross Page Posting or Server.transfer to redirect the other pages Ex : Here I have...

Good Tips to write stored procedure, to improve the performance. Below are the general rules to write good stored procedure. The sp_ prefix : Don't use the "sp_" prefix in a User created stored...

To save the result of your SELECT query to XML or a text file. Well use xp_cmdshell. xp_cmdshell is an extended stored procedure kept in the master database. It issues OS commands directly to the...

Inorder to find the difference of two tables in schema and data betweeen Source and distination tables. we can use Tablediff in SQL Server 2005 You can run this utility from the command line or a...

Inorder to encrypt the text of stored procedures containing sensitive information, Sql Server provides WITH ENCRYPTION to encrypt the Stored Procedure. CREATE procedure...

We need to check the number of active connections for a Database on our server. We can get that details by using the following SQL script. This SQL script displays the DatabaseName, the number of...

To get a list of the Stored Procedure that were last modified, use this query SELECT TOP 10 modify_date,name FROM sys.procedures ORDER BY modify_date DESC --