Viewing 15 posts - 2,086 through 2,100 (of 7,484 total)
Koen Verbeeck (11/6/2014)
TomThomson (11/6/2014)
It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly?...
November 6, 2014 at 1:40 pm
Andy sql (11/4/2014)
It is a very important concept in the Powershell world; in this example, the "dir" alias doesn't just return a list of databases - it...
November 6, 2014 at 4:02 am
Good question.
It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It shouldn't...
November 6, 2014 at 3:26 am
Ed Wagner (11/5/2014)
djj (11/5/2014)
Ed Wagner (11/5/2014)
Stuart Davies (11/5/2014)
Jeff Moden (11/4/2014)
Ed Wagner (11/4/2014)
SQLRNNR (11/4/2014)
PistolRifle
Porkchop Cannon 😀
Hamburger Bishop
Caliber
Twenty-two
Forty-four
Bulldog (11.18)
November 6, 2014 at 2:51 am
The whole point of holding prices in two places is to avoid updating one when the other changes - the two prices are two different things, and trying to cram...
November 6, 2014 at 2:41 am
Good question.
I was careless, and ignored the implicit conversion of ((RAND() * 10) + 1) to int; since implicit conversion to int rounds towards 0 in SQL, and...
November 5, 2014 at 1:47 pm
Ed Wagner (10/31/2014)
SQLRNNR (10/31/2014)
Ed Wagner (10/31/2014)
crookj (10/31/2014)
Ed Wagner (10/31/2014)
Stuart Davies (10/31/2014)
Ed Wagner (10/30/2014)
SQLRNNR (10/30/2014)
coldSnow
Shoes
Running
Nose
Smell
Death
Creeping
Crawling
October 31, 2014 at 3:18 pm
SQLRNNR (10/29/2014)
Ed Wagner (10/29/2014)
SQLRNNR (10/29/2014)
Ed Wagner (10/29/2014)
SQLRNNR (10/28/2014)
Ed Wagner (10/28/2014)
crookj (10/28/2014)
SQLRNNR (10/28/2014)
Ed Wagner (10/28/2014)
SQLRNNR (10/28/2014)
Nos4A2Code
bite
Rabies
Disease
desirable
Wanted
Dead or Alive
Bon Jovi
Steel Horse
Fess
October 30, 2014 at 4:57 am
Nice question, but why does the explanation say "first" instead of "last" when the last character is removed by SUBSTRING(Ms, 1, DATALENGTH(Ms) / 2 - 1) and the first...
October 30, 2014 at 4:54 am
Nice question. At one point I would have found a means of logging full and incremental backups but not log backups useful, but that feature has never been provided.
October 30, 2014 at 4:39 am
rfreiberg001 (10/27/2014)
Koen Verbeeck (10/27/2014)
karthik babu (10/27/2014)
I got the below answers in my SQL 2014 instance.. Could you please explain why this answer was incorrect...
Escobar2014-04-06 00:00:00
Escobar2014-04-07 00:00:00
Escobar2014-04-07 00:00:00
Jeter2014-04-01 00:00:00
Jeter2014-04-01 00:00:00
Jeter2014-04-01...
October 27, 2014 at 5:04 pm
It looks to me as if it would be easier to avoid strange results if you left out the EndDate column. Since you say tha entering a start date...
October 25, 2014 at 9:24 am
Ed Wagner (10/23/2014)
sing4you (10/23/2014)
Ed Wagner (10/23/2014)
SQLRNNR (10/23/2014)
crookj (10/23/2014)
happy Mole day...Ole
Sole
Cod
Whitefish
Hake
October 25, 2014 at 5:24 am
spaghettidba (10/21/2014)
It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I...
October 23, 2014 at 9:48 am
Steve Jones - SSC Editor (2/11/2010)
jparker2 (2/11/2010)
If you want to work with strings greater than 8K then declare them as XML or TEXT.
In Access use a...
October 23, 2014 at 9:26 am
Viewing 15 posts - 2,086 through 2,100 (of 7,484 total)