Viewing 15 posts - 3,856 through 3,870 (of 4,080 total)
I also want to ask two questions just to make sure everyone is understanding correctly.
When you say "restore my database with this file", are you saying you believe this file...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 11:15 am
Who was it that defined legacy code as the stuff that has been around so long that you finally got most of the bugs out of it?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 10:55 am
Hey Jason,
After Matt's comment in your other post, I realized that there was a much better way.... using SELECT/FOR XML. The query at the bottom produced...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 10:49 am
Jeff: You have a great New Year's too! I'm off to Dallas to watch my Rebels play Texas Tech in the Cotton Bowl.
Matt: Quit spoiling everybody's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 10:26 am
Have you tried using a CTE? CONVERT the datetime column to a string in the cte, and then build your xml off the CTE instead of the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 8:17 am
Why do you need to? It's empty.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 8:15 am
Fifteen yard penalty for illegal use of The Force... will be assessed from the line of scrimmage.... third down...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 31, 2008 at 8:11 am
Peculiar... on our 2008 development box (which is pretty quiet this week), I ran Jeff's original test and all three ran almost neck and neck. EXISTS squeaked...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2008 at 1:08 pm
When I googled "sp_OAMethod Excel Refresh", I saw that you had this same question posted on at least one other SQL forum. The problem is that it's not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2008 at 12:32 pm
Calm down, Jeff. Have some Eggnog. Maybe a pork chop. 😀
I think the OP has abandoned us anyway. Don't know whether it was...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 7:10 pm
You have a couple of options, but they aren't things you can specify in T-SQL.
BCP can run queries and put their output in a file.
http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30027/
So...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 6:02 pm
Here is a high level approach to doing it with dynamic SQL.
1. Get list of columns for the table in question.
select c.name,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 5:01 pm
You're a good soul, Chris Harshman 🙂
Maybe I'm just getting cynical, but I'm finding myself less and less willing to help people who are just throwing up a problem and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 2:04 pm
Matt, that was my first thought, but there's a problem if they just defined the identity property for the column without expressly creating a constraint.
Try this:
Create table dbo.dummy (ID int...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 1:48 pm
Can ALTER TABLE affect the IDENTITY property? I'm looking at help online for ALTER TABLE and can't see it. If you search "identity columns/modifying properties", it just...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 1:12 pm
Viewing 15 posts - 3,856 through 3,870 (of 4,080 total)