Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 This is interview question...

Author  Topic 

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-06-03 : 03:11:21
Hello

Can any one help me for below question....

" write a query using FOR UPDATE syntax "

Thanks
Ganesh


Solutions are easy. Understanding the problem, now, that's the hard part

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-06-03 : 03:31:14
for update is a trigger. this means you'll have to create a trigger on the table.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-06-03 : 03:33:19
Thank you very much and can i know where else we use FOR UPDATE statement other that TRIGGER...
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-06-03 : 03:44:26
nowhere else.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-03 : 03:52:21
I think CURSOR has this syntax too.
http://msdn.microsoft.com/en-us/library/ms180169.aspx


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -