Viewing 15 posts - 9,946 through 9,960 (of 39,883 total)
If you don't include the century, then what is this date?
4/12/49
Assuming this is US (Apr 12), is it 1949 or 2049?
April 14, 2015 at 10:51 am
Please also wrap this in a transaction if you're not sure.
select *
from SomeTable
where Auxid = 1219947569
AND Name = 'WALMART T'
and CID = 11987968
begin transaction
Delete from SomeTable
where Auxid = 1219947569
AND...
April 14, 2015 at 10:50 am
As mentioned, you cannot restore databases. You could use a copy to move tables, objects, data from one version to the other.
If you are trying to install on the same...
April 14, 2015 at 10:48 am
You have the name in the variable you set from the cursor. Use an IF statement to check if it's master and then skip the rest of your loop script.
April 14, 2015 at 10:47 am
Ed Wagner (4/14/2015)
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.Well done, Grant. I'd say you've earned a victory beer, so enjoy it.
After crossfit
April 14, 2015 at 10:46 am
First, the Starbucks story is made up, but based on real events reported by people. However, don't get wrapped up in I left my laptop on a table. You could...
April 14, 2015 at 10:14 am
Andrew..Peterson (4/9/2015)
April 13, 2015 at 11:54 am
Carl B. (4/9/2015)
We are upgrading all our databases with migration scripts. We implement it in a way that the tool (that is used to run the conversions) knows which...
April 13, 2015 at 11:52 am
In addition to David's link, I've got a bit on my blog (more coming): https://voiceofthedba.wordpress.com/tag/tsqlt/
There are also some posts from David Green: http://blog.dgta.co.uk/
We've got a few things at SimpleTalk :...
April 13, 2015 at 11:21 am
There are people doing this with databases. Red Gate has numerous clients doing it, and I've run into others that have built their own systems.
The article was written to introduce...
April 8, 2015 at 7:45 am
John Hick-456673 (4/7/2015)
Ha! It is a very quasi CI environment; mostly, when I feel updates need to go out, I fire off the batch file that calls the ps1 scripts...
April 8, 2015 at 7:35 am
Not sure if anyone here knew Larry Toothman (https://www.facebook.com/larry.toothman.7?hc_location=ufi, https://twitter.com/iowatechbear). He's a fellow speaker and part of the SQL community in Iowa. He had a stroke this past weekend and...
April 7, 2015 at 10:09 pm
SQLRNNR (4/7/2015)
It's not a rumor. SSMS 2014 SUCKS!If SSMS crashes - you've lost your work. There is no auto-recovery.
SQL Prompt
Tab Recovery
April 7, 2015 at 10:04 pm
Whatever you are doing has marked this post as SPAM. I don't see a reply to that post, but I'm guessing somehow your answer got stuck in a filter.
I would...
April 7, 2015 at 2:26 pm
Everyone bow their head in a moment of silence.
'14-'15 ski season is over.
April 7, 2015 at 10:14 am
Viewing 15 posts - 9,946 through 9,960 (of 39,883 total)