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...