Some times we need to back up of insert statements, that time we can use below query.
Output:
insert into EmpTable(id,name) values('1''Ranga Rajesh')
insert into EmpTable(id,name) values('2''Kumar')
insert into EmpTable(id,name) values('3''Nambur')
select 'insert into EmpTable(id,name) values('''+CAST(Id AS varchar)+''''''+Name+''')' as query from empTable
Output:
insert into EmpTable(id,name) values('1''Ranga Rajesh')
insert into EmpTable(id,name) values('2''Kumar')
insert into EmpTable(id,name) values('3''Nambur')
Post a Comment
Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.