Viewing 15 posts - 31 through 45 (of 57 total)
Patrick2525 (11/24/2010)
November 24, 2010 at 11:19 am
jts_2003 (8/17/2010)
August 17, 2010 at 11:50 am
Jeff Moden (8/11/2010)
August 11, 2010 at 11:22 am
The definitive answer for passing a list as a parameter is:
August 10, 2010 at 11:01 am
randerson-622728 (7/16/2010)
July 16, 2010 at 1:07 pm
randerson-622728 (7/16/2010)
July 16, 2010 at 11:40 am
Jeff Moden (5/11/2010)
john.moreno (5/10/2010)
How does the idea that you can always replace a cursor with something else, fit in with your Connect suggestion, https://connect.microsoft.com/SQLServer/feedback/details/440375?
Maybe it's just me but it seems...
May 11, 2010 at 10:47 am
How does the idea that you can always replace a cursor with something else, fit in with your Connect suggestion, https://connect.microsoft.com/SQLServer/feedback/details/440375?
May 10, 2010 at 6:21 pm
I'd say the right answer is: it depends.
"INSTEAD OF triggers are not allowed on updatable views that use WITH CHECK OPTION."
So, we don't really have enough information to say whether...
February 24, 2010 at 11:16 am
Now, in a previous post of mine discussing comparing tables using EXCEPT <reference>, I noted that it is best practice to explicitly name your columns in any query using EXCEPT.
I...
January 26, 2010 at 11:50 am
I'd suggest taking a look at Erland Sommarskog's page on passing arrays (list).
http://www.sommarskog.se/arrays-in-sql-2005.html or the older article for sql 200
http://www.sommarskog.se/arrays-in-sql-2000.html
Good coverage of the various possibilities (with performance results)
John
December 14, 2009 at 11:23 am
wisl (8/25/2009)
October 30, 2009 at 4:27 pm
RBarryYoung (9/11/2009)
sknox (9/3/2009)
Chirag (9/3/2009)
This is what i did
begin tryEXECUTE sp_rename N'fakename', N'fakename2', 'OBJECT'
end try
begin catch
select @@ERROR
end catch
Yes. That will catch the error as it happens. So you determined the value...
September 14, 2009 at 11:44 am
SanjayAttray (9/3/2009)
Though I selected " 0 " as answer but still not sure about @@error.
What is not clear?
John Moreno
September 3, 2009 at 11:45 am
kevin.l.williams (8/25/2009)
I found that the reason I got the GetBytes error was because I was connecting to the SQL 2008 server with MSSMS 2005.
I thought I was connected with the...
August 25, 2009 at 1:03 pm
Viewing 15 posts - 31 through 45 (of 57 total)