How to append contents of files?

[wilbiew]

I have two files containing the SQL statements to drop and create two stored procedures, "StoredProcedure1.sql" and "StoredProcedure2.sql".

It is possible to (1) create a new file (2) take the contents of both files and append the contents of both files into this new file using T-SQL?

[jezemine]

Not without resorting to such hacks as xp_cmdshell.

I would use your favorite scripting language (python, dos, javascript, vbscript, whatever) to do this.

[wilbiew]

I've tried looking at xp_cmdshell, but I can't seem to find a solution even with xp_cmdshell.

[jezemine]

with xp_cmdshell, you can do *anything*. that's why you shouldn't use it :}

if you must know, however, you can use this DOS command in windows to concatenate two files to a third file:

copy file1.txt+file2.txt file3.txt

so you would just pass this to xp_cmdshell to do what you are asking.