September 15, 2008 at 12:18 am
Hi Everybody,
I need to search Data in the different Tables in one stored procedure.
For Example if pass the 'One' to the stored procedure.It should search all the Tables and Retrieve the Data.
Suppose Tables like Department,Employee,EmployeeDetails,Designation.
it should search the 'One' in the all tables and should be shown in the one query.
But the their is no realation ship b/w the tables.
September 15, 2008 at 12:41 am
Would a whole bunch of unions not do, or inserting results into a temp table. I think you need to give a bit more information on this.
September 15, 2008 at 3:37 am
hi
please make ur require more descriptive bcoz
it's not difficult to search a WORD in table or databasee.....but just think a database having trillions of records
ANd above of this you are running ur this cuilprit QUERY...:hehe::hehe:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 15, 2008 at 7:33 am
Why do you need to do this exactly?
Do you need to find a given value in any columns in any tables?
Is that something that you have to do as a one time stuff, or does that need to be implemented in production for anyone to do?
... as someone said earlier, if you're not careful in coding this, you can bring any server to its knees while running that thing!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply