adspace
How to write stored procedure to update the data in 10
tables
Answer Posted / mohit johri
Kindly ignore the last statement in my posted answer which
says 'Exec(@sql)' it was wrongly copied
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
What is clustered index
How to provide default values to function parameters?
What are different types of constraints?
Where can you add custom error messages to sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How do I start sql server 2017?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can sql servers link to other servers like oracle?
Can we do dml on views?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is subquery? Explain the properties of a subquery?
Does view occupy space?
How to remove duplicate rows from table except one?
What kind of problems occurs if we do not implement proper locking strategy?