Here is an example of how to use the sp_msforeachtable stored
procedure
to
bcp out data for each table:
sp_MSforeachtable c:\? /U <user name /P <password> /S <server name> /c'" |
For more information on sp_msforeachtable, please read the archived article.
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,658 reads
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
2002-05-31
15,615 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,869 reads
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,716 reads
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,213 reads
