ASP.NET - How To Display Animated .GIF On Postback

When designing an interactive web page, it is important for you to let the user know that  an action initiated by him/her is in progress.One...

SQL - How To Backup All Databases In MS SQL Server Instance

If you would like to backup all the databases in an instance of  MS SQL server , you can run the following script in the query window of...

ASP.NET - How To Add Serial Number Column To A GridView

To add a serial number column to a gridview , you would add the following markup  to the source code of the gridview <asp:TemplateField...

SQL-Search For A Column Name In All Tables In a Database

If you would like to search all tables in  a database for a particular column name, here's a sample query for that: SELECT TABLE_NAME,COLUMN_NAME...

SQL-Search Stored Procedures For A Text

To search the all the stored procedures in a database for a given text : Say you want to find all the stored procedures that have the text-'EmployeeNo'...

SQL-How to get value of updated column

There are times you would like to update a column in a table and return the value of the updated column . Here's how to do it : UPDATE Employee...

SQL-How to list out all tables in SQL server database

To list out all tables in SQL server database using SQL query SELECT TABLE_NAME FROM <databasename>.INFORMATION_SCHEMA.Tables WHERE...