Tag Archives: OPENROWSET

Create Excel File Using OPENROWSET and XP_CMDSHELL Create PROCEDURE MCA_SP_CREATE_EXCEL @File_Name as varchar(50) = ” AS BEGIN SET NOCOUNT ON declare @File_Name as varchar(50) DECLARE @Cmd varchar(1000) DECLARE @fn varchar(500) DECLARE @provider varchar(100) DECLARE @ExcelString varchar(100) – New File Name … Continue reading →