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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2008-07-15 : 02:50:06
|
| Can any one tell any function is there for waiting some time,before resulting the result setbegin tranwait for 10 secondselect * from report(nolock)commit tran |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-15 : 03:05:32
|
| waitfor delay '00:00:10'select * from report(nolock)commit tranMadhivananFailing to plan is Planning to fail |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-15 : 03:28:21
|
Wow ! Excellent idea.Put in a huge delay in the SP and reduce it later to impress Boss / Users.Great way to get a raise 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-15 : 03:30:34
|
quote:
Originally posted by khtan
Wow ! Excellent idea.Put in a huge delay in the SP and reduce it later to impress Boss / Users.Great way to get a raise
KH[spoiler]Time is always against us[/spoiler]
MadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-15 : 03:46:35
|
waitfor time '20080901 15:13:12'
E 12°55'05.25"N 56°04'39.16" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-15 : 04:09:32
|
quote:
Originally posted by Peso
waitfor time '20080901 15:13:12'
E 12°55'05.25"N 56°04'39.16"
What's so special about that date ? Maybe should be 2008-08-08 and after that nobody will care about the report but busy watching the Olympic
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Function