Viewing 15 posts - 10,501 through 10,515 (of 11,678 total)
The expression language used in the derived column is not the same as using TSQL.
When in the derived column editor, look at the predefined functions at the top right.
January 13, 2011 at 3:15 am
irobertson has a valid point, there are enough (free) code formatters on the web. Personally, I wouldn't go through the hassle of creating all that code irobertson has written just...
January 13, 2011 at 3:13 am
GilaMonster (1/13/2011)
Steve Jones - SSC Editor (1/12/2011)
They are hoping that pennies get EOL'd. We'll see if it ever happens.
Happened here a few years back. The 1c and 2c coins were...
January 13, 2011 at 3:07 am
And how can I forget?
Compound operators alla += -= /= *=
January 13, 2011 at 2:28 am
Great, but difficult question.
I had to read the section on converting binary string data on the MSDN page for CAST and CONVERT a few times to get it.
But only 1...
January 13, 2011 at 12:20 am
TheSQLGuru (1/12/2011)
farax_x (1/12/2011)
Check queries that have high cpu usage using activity moitor, then by thinking on execution plan u can solve problem. sql profiler + advisor may also help u.
I...
January 12, 2011 at 11:47 pm
siamak.s16 (1/12/2011)
Lets not forget Intellisense 😀
I'm not always convinced it is an improvement 🙂
January 12, 2011 at 11:45 pm
piet.kouwer (1/12/2011)
January 12, 2011 at 11:44 pm
bitbucket-25253 (1/12/2011)
Now Available for Download
The RTM version of Service Pack 4 (SP4)
for Microsoft SQL Server 2005 is now available
for download, and includes SQL Server...
January 12, 2011 at 11:41 pm
Steve Jones - SSC Editor (1/12/2011)
As my friend Jeff would say, Bwaa-haa-haa
Nice one 😀
I didn't know this demotivational picture yet.
January 12, 2011 at 11:40 pm
piet.kouwer (1/12/2011)
Once a week (friday, 22:00) I make a full backup...
January 12, 2011 at 1:49 pm
tan110 (1/12/2011)
Yes, that worked, thank you so much!
No problem. Glad it all worked out.
January 12, 2011 at 11:50 am
Phil Parkin (1/12/2011)
I wonder what the Downgrade tool does, since you still had to manually intervene for the ProductVersion and edit the connectionstrings.
Sounds to me like a self-nomination for a...
January 12, 2011 at 11:32 am
Alvin Ramard (1/12/2011)
Canada's the backawards neighbour? I think someone got it backwards. 😎
Hey, don't shoot the messenger 😀
(I even don't live in the USA)
January 12, 2011 at 7:57 am
Viewing 15 posts - 10,501 through 10,515 (of 11,678 total)