Hello Friends,

Many times we required all columns from a table in Inserted format and select farmat

here i am using a Stored Procedure for this process You can use and take a enjoy………………!!!!

—————Start Procedure ——————-

CREATE PROCEDURE sp_insertstr

(

@cTableName varchar(50),

@cSourceDb varchar(50) = ”

)

AS BEGIN

SET NOCOUNT ON

DECLARE  @cInsertStr varchar(8000)

DECLARE @cSysCols TABLE ( column_name varchar(50) )
IF @cSourceDb = ” […]