how to copy data from one table to another table and table name is genrated runtime

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I have two table say table1 and table2 all the columns in both table are same but table2 has some extra column in which i want to insert a some default value and name of table is generated runtime

Posted 19-Feb-13 20:21pm

sayed farhan

Add a Solution

Comments

sayed farhan 20-Feb-13 3:35am

thanx susheel for answering it.
but this is not working my both table is present in database and this is creating a new table

sayed farhan 20-Feb-13 3:40am

table is present in database and table name is genrating runtime i.e if firt time table name is table1 and table2 next time table can be table3 and table4 which has different fields

gvprabu 20-Feb-13 7:00am

You need to frame Dynamic SQL Query and Execute as per your requirements.

2 solutions

Solution 1

Try This

select *,'ABC' as NewColumn1,'PQR' as NewColumn2 into Table2 from Table1

Hera 'ABC' and 'PQR' are Default value.

Posted 19-Feb-13 21:19pm

Susheel Kumar Verma

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

gvprabu · Accepted Answer · 2013-02-20T00:59:00

Hi Sayed,

Check the following Script

SQL

-- Variable Declaration 
DECLARE @TabName VARCHAR(100)='TestTable2', @ExtColumnDtls VARCHAR(1000)='M1 INT, M2 INT, M3 INT, Total INT',
    @SqlString VARCHAR(2000)
-- Source Table Creations
CREATE TABLE TestTable1 (SNO INT, Name VARCHAR(50))
INSERT INTO TestTable1 (SNO, Name) VALUES(1,'A'),(2,'B'),(3,'C')

-- Generate SQL Statement
SELECT @SqlString = 'SELECT * INTO '+ @TabName +' FROM TestTable1 GO ALTER TABLE '+@TabName +' ADD '+@ExtColumnDtls
PRINT @SqlString
EXEC (@SqlString)

SELECT @SqlString='', @SqlString='SELECT * FROM '+@TabName
EXEC (@SqlString)

Regards,
GVPrabu