<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by assismarques
»
T-SQL - What is the output of the statement
21 posts, Page 2 of 3
««
1
2
3
»»
T-SQL - What is the output of the statement
Rate Topic
Display Mode
Topic Options
Author
Message
Paul White
Paul White
Posted Wednesday, June 17, 2009 7:46 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 5:01 PM
Points: 10,990,
Visits: 10,545
Ray Laubert (6/17/2009)
Thanks for catching it and letting me know.
No worries. The answer was still clearly discernible from the information given.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #736557
SA-1
SA-1
Posted Wednesday, June 17, 2009 1:01 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 02, 2013 7:35 AM
Points: 1,140,
Visits: 933
Nice question!!!
Post #736902
crussell-931424
crussell-931424
Posted Wednesday, June 17, 2009 2:01 PM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:52 AM
Points: 1,715,
Visits: 61
I tested it on an existing test database table and immediately got an error because I had a trigger on the table. Using a table without a trigger gave me the kind of results intended.
Post #736951
Paul White
Paul White
Posted Wednesday, June 17, 2009 2:48 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 5:01 PM
Points: 10,990,
Visits: 10,545
crussell (6/17/2009)
I tested it on an existing test database table and immediately got an error because I had a trigger on the table. Using a table without a trigger gave me the kind of results intended.
There also can't be any CHECK constaints on the table, and it can't be either end of a FOREIGN KEY relationship.
Paul
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #736991
Lippy
Lippy
Posted Tuesday, October 06, 2009 4:39 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:07 AM
Points: 54,
Visits: 85
That is an incredibly useful bit of code.
Thank You
Post #798414
Alvin Ramard
Alvin Ramard
Posted Tuesday, October 06, 2009 8:12 AM
Hall of Fame
Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:24 AM
Points: 3,031,
Visits: 7,383
I didn't even get a chance to read the question and it says I got it right. Read ahead buffer acting up????
Alvin Ramard
Memphis PASS Chapter
All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #798537
Dan Guzman - Not the MVP
Dan Guzman - Not the MVP
Posted Tuesday, October 06, 2009 9:58 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708,
Visits: 660
Mine too.
I did get a new computer yesterday, but even with all the 'greatest OS ever', I'm pretty sure Win7 can't read my mind
Post #798650
SA-1
SA-1
Posted Tuesday, October 06, 2009 10:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 02, 2013 7:35 AM
Points: 1,140,
Visits: 933
Not only did I go the quetion right, I also had a note in the discussion. How about that?
This without logging in to the site.
Post #798679
Dan Guzman - Not the MVP
Dan Guzman - Not the MVP
Posted Tuesday, October 06, 2009 11:08 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708,
Visits: 660
SA-1 (10/6/2009)
Not only did I go the quetion right, I also had a note in the discussion. How about that?
This without logging in to the site.
Posted in June none the less.
Post #798687
Alvin Ramard
Alvin Ramard
Posted Tuesday, October 06, 2009 11:14 AM
Hall of Fame
Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:24 AM
Points: 3,031,
Visits: 7,383
Dan Guzman (10/6/2009)
SA-1 (10/6/2009)
Not only did I go the quetion right, I also had a note in the discussion. How about that?
This without logging in to the site.
Posted in June none the less.
aaaaaahhhh .... that explains why it was already answered.
Alvin Ramard
Memphis PASS Chapter
All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #798689
« Prev Topic
|
Next Topic »
21 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
