nakul_vachhrajani Commented 3 Years ago through
Blogs
Useful post, Madhivanan. Here's another style - same thing, just condensed into one single line:
exec sp_MSforeachtable 'Exec Master..xp_Cmdshell ''bcp "select * from AdventureWorks2008.?" queryout "C:\Data\?.txt" -S "SQL2K8\SQL2K8R2" -T -c'''...