How can i search a keyword from a database(all the tables) using a single query

[shoaib kahn]

i am developing a web site in Asp.Net using Visual Studio 2008.
i want to know that how can i search a keyword that will be entered by the user, i want the key word should be searched in complete database(all the tables)using a single query.
I am using sql database.
Can some one tell me how can the keyword be searched using like parameter...

[Frinavale]

I think it would be best to use a Stored Procedure to do this. You would create your Stored Procedure in your database and then call it using your C# or VB.NET code to search the database. That way, when you change your database (add a table or something), all you have to do is update the stored procedure and your ASP.NET application will work as if nothing was changed.

-Frinny