SELECT *, 'INSERT INTO db_name.[dbo].tbl_name VALUES('''+  CAST([column_1] AS VARCHAR)  + ''', '''+ CAST(column_2 AS VARCHAR)+ ''', '''+ CAST(column_3 AS VARCHAR)+ ''')' FROM db_name.[dbo].tbl_name

I cant execute well

i am getting error that

Invalid object name 'Person.dbo.Test'.

Yess..got it..
Thank you

Hi,
I am Test this script and litte bit change..

SELECT *, 'INSERT INTO TestDB.[dbo].Employee VALUES('''+ CAST([EmpID] AS VARCHAR) + ''', '''+ CAST(EmpName AS VARCHAR)+ ''', '''+ CAST(ManagerID AS VARCHAR)+ ''')' as InsertQuery FROM TestDB.[dbo].Employee

Why you convet the each columns datatype to varchar,convet to actual datatype..

Anyway...this is working fine.... if you want something more then please replay me.

Hi,
I test this working fine also

Syntax:
---------
SELECT *, 'INSERT INTO db_name.[dbo].tbl_name VALUES('''+ CAST([column_1] AS VARCHAR) + ''', '''+ CAST(column_2 AS VARCHAR)+ ''', '''+ CAST(column_3 AS VARCHAR)+ ''')' FROM db_name.[dbo].tbl_name

Example:
-----------
SELECT *, 'INSERT INTO Employee.[dbo].Employee1 VALUES('''+ CAST([EmpId] AS VARCHAR) + ''', '''+ CAST(Name AS VARCHAR)+ ''','''+ CAST(Designation AS VARCHAR)+ ''','''+ CAST(Address AS VARCHAR)+ ''')' FROM Employee.[dbo].Employee


Thank you,




SRILATHA
.Net Developer