1. How I find a particular column name within all tables of SQL server database?
For example, I have a database named
Organisation. I have more than one table where
tax_id column is present.
Most of the time, we have to find such a column from the whole database. The solution is provided below:
select table_name,column_name from information_schema.columns
where column_name like '%tax%'
Here, I am searching for
column_name which contains
tax within its name. It will return all the tables and respective columns containing
|Table_Name ||Column_name |
2. How to search stored procedures containing a particular text?
Below is the solution. Suppose I need to find
tax_id from all
stored procedures. The below query will return all
stored procedures containing text
select routine_name, routine_definition
where routine_definition like '%tax_id%'
Sandesh has a 11 years of total professional experience in a software development. He first handled the computer in his school days when he was in 7th std working on Lotus. In summer vacation, the school authorities allowed him and other students to use the computers for practicing Lotus and playing different games
He has done computer engineering. Currently he is working in Net 4.0 framework. Even though he is using .Net 4.0 framework for development but still he has not got a chance to work with newer technologies like MVC, WCF etc. However he always try to learn these technologies from his end and eagerly waiting for a chance to work with the newer technologies like MVC, WCF and Silverlight etc.