No - but the syntax must be correct.

insert into test (test_id, testStr)
select (select max(test_id) from test), 'something'
select * from test


"Jeremy Moncho" <jeremy.moncho (AT) bluewin (DOT) ch> wrote

Can try using

Insert into test
select max(id), 'something' from test

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions
http://www32.brinkster.com/sqlvinod


"Jeremy Moncho" <jeremy.moncho (AT) bluewin (DOT) ch> wrote

Hello!

Using on other DBMS I am today needing to do some work on Sql Server 2000.
My question is, are Subqueries "really" illegal in insert statements?

I am trying something in the following:

Create table test(
test id int,
testStr varchar(25)
)

Insert into test values ((select max(id) from test), 'something')


Thank you in advance for the assistance,

jeremy