Hi,

In Oracle, the below query is valid :

insert into test(sno,sno1) values(1,2) returning id into val_ret;

// The above query in Oracle returns the affected row id's to the PL/SQL or host vriable(val_ret)

Is there any equivalent for the above in SQL Server ?

Please advice,

Thanks,
Smitha

Hi Smitha,

Is that you want to parse the Query in SQL query analyser to see if that query is a valid one, and if not show what the error is?

If so, in SQL query Analyser, Key in your query and use CTRL+F5 or Select PARSE from QUERY Menu.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

I'm not an Oracle expert but it looks like you'd need this (assuming you'd declared val_ret previously: --

Joe

I believe, I was out of focus while replying my last post on this. Joe's reply opened my eyes. That should be what you were looking for, smitha.

Cheers!

_________________________
- Vijay G
Strive for Perfection