bcp doesn't allow you to append files, but the COPY command certainly is able to do it.

here's a complete example: it uses the function i suggested above.

psuedocode: bcp, make header,...

lookjs like you are assuming a specific date format and preceeding zeros that you did not mention previously:

well this will work, but I agree with Ray that this isn't the...

I agree with Lynn no value to using a function in this case; also, I'd suggest creating an index on those 7 columns; it would most likely help on performance...

you'll want to use the convert function most likely...

assume a db has three int or other numeric columns:

SELECT * from sometable

WHERE CONVERT(VARCHAR,MAJORVERSION) + '.' + CONVERT(VARCHAR,MINORVERSION) + '.'...

look at this script from the contributions, which opens a file and appends to the end of it:

you could BCP to a file, and then use the script to append...

interesting; other than a restore of the data, everything i tried so far left the CRDATE in master.dbo.sysdatabases intact:

stopping/starting server. also tried rebooting the server.

backup full database, then backup transaction...

yep use a snapshot: a developer doing SELECT * FROM THE800MILLIONROWTABLE will kill usability, and he might have done it just to remind himself of column names.

keep developers off production.

ok it looks like you want to keep track of multiple results, but you wanted separate tables...

rethink the logic a bit;

why not create ONE table, and add one column CalledResultSet,...

--sql doesnt have an instrRev function, but separate functions you can combine to do the same thing:

--so you have to use substring and reverse:

declare @str varchar(1024)

set @str = '/pna/v3/pg/product/manual/display/0,,2076_15221_49434,00.HTML....

i use this to find tables or columns that contain some string all the time;

usage: sp_find Customer

CREATE procedure sp_find       

@findcolumn varchar(50)       

as       

begin       

 set nocount on       

 select sysobjects.name as TableFound,syscolumns.name as...

Here's my take:

no backups are a sign of an in-experienced DBA, or a developer who happens to have to wear the DBA hat. Unfortunately, he's been lucky up till now hiding...

As i understand it, the database is it's own self contained unit, and doesn't have info about other instances that exist;

There's a few metadata functions, like  SELECT @@SERVERNAME,@@SERVICENAME,@@VERSION ,...

I'm curious as to why you think you need to update the system tables directly anyway. What are you trying to accomplish? there might be a better way to do...

because there is no central source which captures which servers exist, you can't really query it.

you can ask the operating system to poll all the servers that are advertising...

OK, if you look at the procedure, it's pretty much getting two values for each companyId: the sum(moneyamount) and the sum(number of shares)

you can get the same information from a...