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.
| Author |
Topic |
|
kode1
Starting Member
2 Posts |
 Posted - 2010-09-23 : 11:56:52
|
| Hi all,I am making stored procedure for backuping table in txt file. I am not just far. I gat to point where I need to fetch cursor into @variables, which havo to represent the table columns, but I didn't know how to make it dynamicaly. Every table has different number of columns.How can I do this?At the end I have to have exec sp_backup_table 'table_name', 'path'Any help is appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
dynamic cursor