ms sql insert into value from variable and select from table

Question

I want to insert into a table an value from variable and an select result.

declare @actual Date
set @actual = getdate()

This is my try:

insert into test (ID, Date) (select ID, @actual from Table)

I get an error Message!!

"An error message" - care to share? Those things usually include some useful information - even if you don't know what it means, it's possible that other people could help you. Also, when posting code, please highlight it and hit the {} button. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jan 29, 2013 at 8:44

John Woo · Accepted Answer · 2013-01-29 08:39:29Z

4

use INSERT INTO..SELECT statement,

DECLARE @actual Date
SET @actual = GETDATE()

INSERT INTO test (ID, Date) 
SELECT ID, @actual 
FROM   Tablename

answered Jan 29, 2013 at 8:39

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dileep · Accepted Answer · 2013-01-29 08:41:34Z

1

You can try like this for using a select clause for Insert

insert into test(id,date) select col1,col2 from table;

answered Jan 29, 2013 at 8:41

Dileep

6743 gold badges10 silver badges20 bronze badges

Jignesh.Raj · Accepted Answer · 2013-01-29 08:48:06Z

0

INSERT INTO TEST
(ID,DATE)
SELECT COLUMN1,COLUMN2 FROM TABLE

answered Jan 29, 2013 at 8:48

Jignesh.Raj

6,0074 gold badges30 silver badges57 bronze badges