Viewing 15 posts - 41,851 through 41,865 (of 49,562 total)
lucassouzace (1/9/2009)
What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?
SUser_Sname returns the user's login name. App_name returns the application that initiated the connection to SQL. In terms of the resource...
January 9, 2009 at 1:10 pm
vishudata (1/9/2009)
Write an SQL query if you want to select the data from one block which intern reflects in another block?
Um... That question makes absolutely no sense. Could you perhaps...
January 9, 2009 at 1:08 pm
Michael Earl (1/9/2009)
GilaMonster (1/9/2009)
Hmmm.http://www.sqlservercentral.com/Forums/Topic633720-338-1.aspx
I like how the OP re-stated the same non-question. Perhaps it should have been in bold the second time.
There seems to be an echo in...
January 9, 2009 at 1:03 pm
Did you read the link that I and several other people posted?
Based on the sample data that you gave, what are the exact results that you want?
January 9, 2009 at 1:01 pm
I would suggest you call Microsoft's customer support for this one. We don't have the tools or knowledge to interpret a stack dump
January 9, 2009 at 1:01 pm
January 9, 2009 at 12:43 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 9, 2009 at 12:39 pm
Please post the full error message, the exact version of SQL that you are on and what seems to cause the error.
January 9, 2009 at 12:38 pm
Steve Jones - Editor (1/9/2009)
January 9, 2009 at 12:36 pm
JPLeBlanc (1/9/2009)
January 9, 2009 at 9:00 am
crfenix (1/9/2009)
January 9, 2009 at 8:53 am
The inserted table will contain all the rows that were updated. There may be more than one, SQL doesn't have row triggers.
So, what you need is something like this
UPDATE tbl_Question1Answers...
January 9, 2009 at 8:41 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic633463-8-1.aspx
January 9, 2009 at 8:39 am
JPLeBlanc (1/9/2009)
January 9, 2009 at 8:26 am
There's no equivalent on SQL 2000.
On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated...
January 9, 2009 at 8:24 am
Viewing 15 posts - 41,851 through 41,865 (of 49,562 total)