I am adding a row to a table A and then want to add primary key value of this row to another table. How to achieve that? I have tried SELECT SCOPY_IDENTITY(), but what i always get is number '1', which i think is number of row affected. moreover, i believe in the sql query builder of VWD, i am...