DataAsInsCommand
Version: SQL Server 7.0/2000 Created by: Alexander Chigrik http://www.MSSQLCity.com/ - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams). This script will generate insert statements for the given tables. You can pass the tables names into DataAsInsCommand stored procedure separated by commas, as in the example below: EXEC DataAsInsCommand 'employee,titleauthor,pub_info' |
Version: SQL Server 7.0/2000 Created by: Alexander Chigrik http://www.MSSQLCity.com/ - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams). This stored procedure can be used to insert the result set of the particular select statement into Excel file (c:\ImportToExcel.xls, by default). You can pass the server name, user name, user password, the select statement to execute, and the file name to store the results set, as in the example below: EXEC ExportToExcel @server = '.', @uname = 'sa', @QueryText = 'SELECT au_fname FROM pubs..authors', @filename = 'c:\ImportToExcel.xls' |
Version: SQL Server 7.0/2000 Created by: Alexander Chigrik http://www.MSSQLCity.com/ - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams). This stored procedure can be used to export the text string into Microsoft Word. You can pass the text string and the file name (if the file name was not specified, the c:\ImportToWord.doc will be used) into this stored procedure, as in the example below: EXEC ExportToWord @Text = 'Test example', @filename = 'c:\ImportToWord.doc' |
Blogger Comment
Facebook Comment