Generate Insert Query in SQLSERVER 2000

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  August 26, 2010 at 4:39 am

  #72057

  Hi All,

  How to generate a insert query script in sqlserver 2000. In Sql server 2000 don't have option to

  generate a script.

  Example

  select empname,empid from employee

  select 'insert into employee (empname,Empid) values('

  empname +','+ empid ')' from employee

  I need a following format output like

  insert into employee(empname,empid) values('1000','Balaji') like that..

  While i'm executing the above script. its getting error.

  Syntax Error..

  I would be greatly appreciated if any one help me out to solve this issue..

  With Thanks & Regards

  Balaji.G

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  August 26, 2010 at 4:46 am

  #1212203

  Cross post -> http://www.sqlservercentral.com/Forums/Topic973282-5-1.aspx

  (I've answered you in your original post)

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---