Viewing 9 posts - 1 through 9 (of 9 total)
Will there be a problem with the toolkit for 64-bit machines? Or is there a separete toolkit for 64-bit machines?
September 30, 2011 at 6:49 am
Jay,
Thanks for the reply. Now how do you do this if you were to do it in sql server.
February 5, 2008 at 3:46 am
Ok here is a scenario. What if based on some condition your procedure displayed two or more different kinds of result sets? Is there a way to programmatically determine the...
January 18, 2008 at 2:12 pm
GilaMonster (1/10/2008)
Arun T Jayapal (1/10/2008)
After that if condition I tried to drop the table. It said some syntax before drop. I believe you can truncate/drop temporary tables?
Could you post the...
January 15, 2008 at 6:38 pm
I hope all temporary tables are session specific. Actually I prefer them to be connection specific...are they?
So will the following statement reveal the connection specific information? If multiple people are...
January 15, 2008 at 5:55 pm
GilaMonster (1/7/2008)
Arun T Jayapal (1/7/2008)
if (object_id('tempdb..#tblTemp','u') > 0)print 'exists'
else
print 'not exists'
...its not compiling...:ermm:
Looks fine, and runs fine for me. What's the error that you're getting?
After that if condition I tried...
January 10, 2008 at 4:53 am
In the documentation object_id should return an integer if it finds the table object. But if I do something like
if (object_id('tempdb..#tblTemp','u') > 0)
print 'exists'
else
print 'not exists'
...its not compiling...:ermm:
January 7, 2008 at 5:21 am
"Create a job which deletes itself..."???!
Explain.
November 14, 2007 at 11:20 am
This was indeed a good refresher on joins...
What if you had to extract data from table_1 which does not exist in table_2 but there are two or more conditions...(By conditions...
May 14, 2007 at 7:58 am
Viewing 9 posts - 1 through 9 (of 9 total)