var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Not able to do insert and select clause with aggregate function
Could some one help me how to do
insert into test2(id,name) values ((select max(id) from test1),'user1')
in MS SQL Server
its throwing "Subqueries are not allowed in this context. Only sc
alar expressions are allowed" Exception. Help is appreciated.
insert into test2(id,name) select max(id),'user1' from test1
Thanks for the quick reply. i misinterpreted the query syntax earlier. it worked. Thanks...