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.
| Author |
Topic |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-04-29 : 02:13:50
|
| Hello,My senario is like :My temp table is having 3 million record in table...we are fetching recrod from ETL application at the same time the other application applied the truncate statement on the temp table..while select statement .. it's applied the Share lock while fetching.. what happend when Truncate is fire?other senario is like :1. We applied the Truncate on temp table at the same time select statment is fired what happend in that senario?Thanks,Amey |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-29 : 02:29:11
|
Is this an interview question?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
ay2k_99
Starting Member
22 Posts |
Posted - 2009-04-29 : 02:34:40
|
| No... We this is from our development team.. |
|
|
|
|
|
|
Locking issue....