var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Can I use like
insert into table1 values ('select max(col1) from table1', ....)
The real question is can a select statement used while inserting rows into a table?
Any help is appreciated.
yes, this is possible. Just make sure that your insert and your select statement have the same number of columns and the same data types.
In BOL are some examples, just look for "insert..select" in the index.
you'll have to remove VALUES clause.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors