Hi

don't use double codes. use single codes. You have not mentioned concatination symbol (+) for each field.

select 'insert into sam(Id,Name,type,Email,Versionnumber)

values(' + ''''+id+''+','+''''+Name+''''+','+ ''''+type+''''+','+''''+Email+''''+','+''''+Versionnumber+''''+ ')'

from sam

Thanks

Siva Kumar J

Hi

-- created sample table.

create table product

(cust varchar(25),

product varchar(20),

qty int)

-- inserting sample record

insert into product (cust,product,qty) values('KATE','SODA',6)

-- script to generate dynamic script

select 'insert into Product (cust,product,qty) values('+

''''+cust+'''' +','+''''+ product+''''+','+convert(varchar(10),qty)+')'...