hi,
i created a query to insert a row in DataSet in Visual Studio 2005. i gave the method name to the query i created. as i understood it returns '1' if successful or '0' if not.
is it possible to get the ID or the row instead?
what did it say,or whats the eror code if there is?|||there is no error. the point is i would like to get the id of the row that i insert instead of default int value.
|||Hi,are you using a SQL 2k5? There is a new ouput clause in the syntax, where you can get values back. Look in the BOL for more information about that, or raise a hand if you need further assistance.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
i am using SQLExpress...
sorry should have mentioned earlier.
|||Hi,
ok then go the OUTPUT way (described in the BOL)
INSERT INTO Sometable (Columnlisthere....)
OUTPUT INSERTED.*
VALUES ...Values here...
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
