Hi,
Actually I have one table table named tblcustomer that there are 10k rows. Now I tried exporting data to excelsheet with columns. Please find my code below,
create procedure DSP_ExportTOExcelsheet
(
@db_name varchar(100),
@table_name varchar(100),
@file_name varchar(100)
)
as
BEGIN
--Generate column names as a recordset
declare @columns varchar(8000), @sql varchar(8000), @data_file varchar(100)
select
@columns=coalesce(@columns+',','')+column_name+' as '+column_name
from
information_schema.columns
where
table_name=@table_name
select @columns=''''''+replace(replace(@columns,' as ',''''' as '),',',',''''')
--Create a dummy file to have actual data
select ...
Go to the complete details ...