oracle.sqlpass.org

http://www.mssqltips.com/sqlservertip/1060/bcp-xml-format-files-with-sql-server-2005/

http://www.tcscblog.com/2012/03/27/creating-a-database-backup-and-restoring-it-in-code/

http://sqlandme.com/2012/03/27/exporting-data-to-csv-file-using-sqlcmdbcp/

http://blogs.msdn.com/b/mssmallbiz/archive/2012/03/14/microsoft-sql-server-2012-virtual-labs-available-to-you-online-plus-many-more-sql-server-2012-resources.aspx

http://sqlyoga.com/

http://beyondrelational.com/blogs/nakul/default.aspx

http://sqlserver-help.com/

http://www.amitbansal.net/

 http://www.sqlserverfaq.net

alter procedure usp_Export2ExcelVS
(
@db_name varchar(100),
@table_name varchar(100), 
@file_name varchar(100)
)
as

--Generate column names as a recordset
declare @columns varchar(8000), @sql varchar(8000), @data_file varchar(100)
select
@columns=coalesce(@columns+',','')+column_name
from
information_schema.columns
where
table_name=@table_name

select @columns = '''''' + replace(@columns,',',''''',''''') + ''''''

print @columns
--Create a dummy file to have actual data
select @data_file=substring(@file_name,1,len(@file_name)-charindex('\',reverse(@file_name)))+'\data_file.xls'

print @data_file

--Generate column names in the passed EXCEL file
set @sql='exec master..xp_cmdshell ''bcp " select '+@columns+' as t" queryout "'+@file_name+'" -c -T -S "<server>"'''
exec(@sql)

--Generate data in the dummy file
set @sql='exec master..xp_cmdshell ''bcp "select * from '+@db_name+'..'+@table_name+'" queryout "'+@data_file+'" -c -T -S "<server>"'''
exec(@sql)

--Copy dummy file to passed EXCEL file
set @sql= 'exec master..xp_cmdshell ''type '+@data_file+' >> "'+@file_name+'"'''
exec(@sql)

--Delete dummy file
set @sql= 'exec master..xp_cmdshell ''del '+@data_file+''''
exec(@sql)
GO

/*
exec usp_Export2ExcelVS 'Northwind','OrderHistory','c:\temp\excel.xlsx'
*/

http://www.mssqltips.com/sqlservertip/1272/file-validation-in-sql-server-with-xpfileexist-stored-procedure/

http://www.codeproject.com/Tips/326527/Create-a-sample-SQL-database-in-less-than-2-minute?utm_source=twitterfeed&utm_medium=twitter

http://support.microsoft.com/kb/224587/en-gb