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


Please Help Members By Posting Answers For Below Questions

How efficient you are in oracle and SQL server?

1269


What is clustered index

1094


How to provide default values to function parameters?

1273


What are different types of constraints?

1007


Where can you add custom error messages to sql server?

1220


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?

1223


How do I start sql server 2017?

1024


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1209


Can sql servers link to other servers like oracle?

928


Can we do dml on views?

1042


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8239


What is subquery? Explain the properties of a subquery?

1070


Does view occupy space?

1033


How to remove duplicate rows from table except one?

1096


What kind of problems occurs if we do not implement proper locking strategy?

1508