Help: How to lock a table using SQL?

Thank you!You can use hints:
--if you want exclusive lock
SELECT * FROM dbo.Orders (TABLOCKX) WHERE OrderID = 10248
--if you want shared lock
SELECT * FROM dbo.Orders (TABLOCK) WHERE OrderID = 10248
--
Regards,
Tomislav Kralj
tomislav.kralj1@.zg.tel.hr
"tosh" <tosh111@.163.net> wrote in message
news:000901c34688$7d71ea60$a001280a@.phx.gbl...
> Thank you!