Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 generate script of content of one table as a .sql

Author  Topic 

meysam
Starting Member

1 Post

Posted - 2009-12-19 : 07:41:34
s this possible that i create a stored procedure that generates content of defined table to a path that i passed as its(stored procedure) parameter?
e.g a file with this content:
insert into table1 values(f1,f2,f3)
insert into table1 values(f1,f2,f3)
insert into table1 values(f1,f2,f3)
insert into table1 values(f1,f2,f3)
insert into table1 values(f1,f2,f3)
insert into table1 values(f1,f2,f3)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-12-20 : 04:02:30
you can do that. but where will these values come from? another table or file?
Go to Top of Page
   

- Advertisement -