Viewing 15 posts - 13,366 through 13,380 (of 19,560 total)
Alvin Ramard (7/12/2010)
rvasanth (7/12/2010)
Also you can do like below:update table set col1=isnull(@newvalue1,col1), col2=isnull(@newvalue2,col2),etc...
Don't forget that if your UPDATE statement does not have a WHERE clause, you will be updating every...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 10:40 am
sprocket
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 10:26 am
choco
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 10:18 am
Tom.Thomson (7/12/2010)
I thought that Jason's sending the url for the UPDATE page of BoL was one of the most unhelpful things I have ever seen (and many people, I think,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 10:08 am
Steve Jones - Editor (7/12/2010)
Chad Crawford (7/12/2010)
Jeff Moden (7/9/2010)
I promise to publish it right after PASS if it's not called upon.
🙁 I don't want to wait. I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 9:48 am
toadish
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 8:31 am
GilaMonster (7/12/2010)
Alvin Ramard (7/12/2010)
Seemed obvious to me that the OP had never programmed an UPDATE statement before.
Agreed. That's not something that you can just forget. Plus, someone who's done consulting...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2010 at 8:30 am
Steve Jones - Editor (7/11/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 11:02 pm
CirquedeSQLeil (7/11/2010)
Jeff Moden (7/11/2010)
http://www.sqlservercentral.com/Forums/Topic950419-145-1.aspx
This is one of the reasons I'm so adamant about not posting answers to interview and homework...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 6:09 pm
Nice question - thanks.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 4:33 pm
lmu92 (7/11/2010)
CirquedeSQLeil (7/11/2010)
...Long live the vuvuzela!!!!!!!!!!!!!!
Would you repeat that face to face with Gail? (assuming she can hear you and doesn't still have that bee swarm sound in her ears...)
:Whistling:
Possibly...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 4:17 pm
lmu92 (7/11/2010)
The first half wasn't as excellent as expected but it went better and better starting with...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 3:37 pm
Jeff Moden (7/11/2010)
http://www.sqlservercentral.com/Forums/Topic950419-145-1.aspx
This is one of the reasons I'm so adamant about not posting answers to interview and homework questions....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 3:34 pm
azarcomp (7/11/2010)
so if only @col2 needed to updated, what to pass to the rest?
Here is a refresher article on that topic
http://msdn.microsoft.com/en-us/library/aa260662(SQL.80).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 3:33 pm
this got hosed into the wrong thread
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2010 at 3:31 pm
Viewing 15 posts - 13,366 through 13,380 (of 19,560 total)