Viewing 15 posts - 6,796 through 6,810 (of 9,400 total)
ramana3327 (12/23/2014)
I am working with database restore. It is showing database is in use. Instead of single_user mode, I use the below query. It is giving error
USE [master]
GO
DECLARE @dbName...
December 23, 2014 at 8:49 am
Eirikur Eiriksson (12/23/2014)
Jeff Moden (12/22/2014)
Stefan Krzywicki (12/22/2014)
jasona.work (12/22/2014)
Stefan Krzywicki (12/22/2014)
Steve Thompson-454462 (12/22/2014)
Stefan Krzywicki (12/22/2014)
Steve Thompson-454462 (12/22/2014)
Brandie Tarvin (12/16/2014)
But still... To my mind, since I'm already fixing one part of the...
December 23, 2014 at 6:49 am
I love string puzzles when I have the time to do them. There are usually several ways to pull off the same result and the fun part is figuring...
December 23, 2014 at 6:45 am
Luis Cazares (12/22/2014)
Instead of fighting with this, why don't you do things correctly? You should store each value in its own column.
Luis raises an excellent point here. If you...
December 22, 2014 at 11:22 am
If you want to split your string based on the presence of an X, format each part of it and then repopulate your column, you can do this using the...
December 22, 2014 at 11:20 am
Maybe I'm not seeing a complexity you know about. I would write the update to over the whole table and just run it once. I don't see the...
December 22, 2014 at 10:59 am
Yeah, that was an easy one. I was looking for the trick in wording, but then looked at who posted it and relaxed a bit.
December 22, 2014 at 10:31 am
If it's really as simple as you describe, I think the REPLACE command ought to do it for you.
December 22, 2014 at 10:29 am
I worked for a company that had no kitchen at all. We had a couple of microwaves off to the side and I.T. had their own refrigerator. It...
December 22, 2014 at 10:28 am
Sean Lange (12/19/2014)
Steve Jones - SSC Editor (12/19/2014)
Merry Christmas and Happy Holidays, everyone.I'll be gone after tomorrow, heading away for a week. Everyone behave.
Have a great holiday Steve. We...
December 19, 2014 at 11:15 am
Greg Edwards-268690 (12/19/2014)
I liked the old licensing model better - it was much clearer and easier to understand.
I couldn't agree more if I tried. We're trying to gather licensing...
December 19, 2014 at 7:03 am
While yes, initial assignment was introduced in SQL 2008, I think the point of the question was what it prints out and the data types involved. I thought it...
December 19, 2014 at 5:33 am
Greg Edwards-268690 (12/18/2014)
Ed Wagner (12/18/2014)
Greg Edwards-268690 (12/18/2014)
Brandie Tarvin (12/18/2014)
We have a business user that...
December 18, 2014 at 7:58 am
SQLRNNR (12/18/2014)
Ed Wagner (12/18/2014)
crookj (12/17/2014)
SQLRNNR (12/17/2014)
Ed Wagner (12/17/2014)
SQLRNNR (12/17/2014)
djj (12/17/2014)
Ed Wagner (12/17/2014)
TomThomson (12/16/2014)
Sean Lange (12/16/2014)
Ed Wagner (12/16/2014)
SQLRNNR (12/16/2014)
Ed Wagner (12/16/2014)
djj (12/16/2014)
SQLRNNR (12/15/2014)
ContortionPain
Weakness
leaving
Body
piercing
shriek
Scream
Ice cream
gelato
Heavy Cream
Whipped cream
Sour Cream
Stroganoff
Mushroom
Risotto
December 18, 2014 at 7:15 am
Greg Edwards-268690 (12/18/2014)
Brandie Tarvin (12/18/2014)
We have a business user that keeps asking for X...
December 18, 2014 at 7:13 am
Viewing 15 posts - 6,796 through 6,810 (of 9,400 total)