Export SQL Data

SQL Server steps to grab table columns and then build insert statements based on structure of existing table.

--A
--exec sp_getColumns 'microsite_content', 'list'

--B
--exec sp_getColumns 'microsite_content', 'list', 'dbo.sqlsafe(', ') + '', '' + '

--Using output from parts A & B
--Optionally use 'Set identity_insert tablename on' before and then 'Set identity_insert tablename off' at end
select 'insert into microsite_content (id, Site_Id, Sequence, Page_template, Page_Name, Page_URL, Page_Title, Page_Body_ID, Page_Meta_Desc, Page_Meta_Keys, Page_Header, Page_SubTitle, Page_Tag_Line, Category_ID, Is_Parent_Menu, Product_Family, Last_Updated, Insert_By, Update_By, View_Status, RecordStatus) values (' +
dbo.sqlsafe(id) + ', ' + dbo.sqlsafe(Site_Id) + ', ' + dbo.sqlsafe(Sequence) + ', ' + dbo.sqlsafe(Page_template) + ', ' + dbo.sqlsafe(Page_Name) + ', ' + dbo.sqlsafe(Page_URL) + ', ' + dbo.sqlsafe(Page_Title) + ', ' + dbo.sqlsafe(Page_Body_ID) + ', ' + dbo.sqlsafe(Page_Meta_Desc) + ', ' + dbo.sqlsafe(Page_Meta_Keys) + ', ' + dbo.sqlsafe(Page_Header) + ', ' + dbo.sqlsafe(Page_SubTitle) + ', ' + dbo.sqlsafe(Page_Tag_Line) + ', ' + dbo.sqlsafe(Category_ID) + ', ' + dbo.sqlsafe(Is_Parent_Menu) + ', ' + dbo.sqlsafe(Product_Family) + ', ' + dbo.sqlsafe(Last_Updated) + ', ' + dbo.sqlsafe(Insert_By) + ', ' + dbo.sqlsafe(Update_By) + ', ' + dbo.sqlsafe(View_Status) + ', ' + dbo.sqlsafe(RecordStatus) 
+ ')'
from microsite_content where id > 90