Viewing 15 posts - 4,696 through 4,710 (of 7,187 total)
It isn't a script at all. It's a snippet from the documentation for ALTER TABLE... which name should suggest to you that it's to alter one table at...
February 15, 2012 at 8:29 am
I've never used this before, but this snippet from the ALTER TABLE documentation suggests you can drop more than one column at once:
| DROP
...
February 15, 2012 at 8:14 am
You need to set up a linked server on the server on which you create the proc.
John
February 15, 2012 at 5:36 am
Formatting is something that's better done in the presentation layer. However, if you insist on doing it in the data layer, just convert the number to varchar(4) and concatenate...
February 15, 2012 at 4:02 am
Mithra
Soon after SQL Server starts, there is a message in the errorlog something like "The NETBIOS name of the local node that is running the server is 'NODE1'. This is...
February 15, 2012 at 2:34 am
Are we talking about a cluster server here? You can look at the Windows event log and see whether any particular start of SQL Server occurred on the same...
February 15, 2012 at 2:08 am
Also, I would strongly recommend using different domain accounts for test and live servers. Think about it - at the moment, everything that your live server has access to,...
February 15, 2012 at 2:02 am
No they shouldn't. A table is an unordered set. The database engine will retrieve rows from a table in the way and in the order it judges most...
February 14, 2012 at 5:01 am
Appalled? I usually reserve that reaction for earthquakes, famines, wars and so on.
In any case, I don't agree that just because two statements are posted on the same page...
February 14, 2012 at 4:30 am
The only (easy) way I can think of for achieving anything like that is to use sqlcmd and pipe the output into your text file.
John
February 14, 2012 at 4:04 am
A header and a footer? I'm out of my depth now. Sounds like something you'd user Reporting Services for. Do you have a sample of what the...
February 14, 2012 at 3:48 am
Sounds like you're being taught to run before you can walk. Those are columns, not rows.
SELECT col1, col2, col3 FROM MyDB.dbo.USERS
John
February 14, 2012 at 3:34 am
Does this mean it works?
You tell me - you have access to the file; I don't.
John
February 14, 2012 at 3:32 am
You haven't read about fully qualified object names, have you? Nor have you read Phil's suggestion properly. The only way your code will work is if you have...
February 14, 2012 at 3:30 am
Viewing 15 posts - 4,696 through 4,710 (of 7,187 total)