Hi Ben Kubicek,

It's good Article. I have small Q. if we...

Hi All,

hope this will help you,

Link.

Thanks

Tharindu

Hi Vijaya Kumar,

recently i have read your article and it's helpful.And I have small doubt why are you used this,

(This works for Oracle but not MSSQL)

"I have used “Truncate”...

Good collection thank you for the all information

Hi Linson.Daniel,

Thanks for send comments for my article yes you are correct. I mention this for limitation because give idea to "doesn’t apply duplicate data to MERGE...

hi,

try this way,

--------

DECLARE @NIDTBL TABLE(NID INT);

DECLARE @NID INT;

BEGIN

INSERT A (

NAME,

AGE

)OUTPUT INSERTED.ID INTO @NIDTBL VALUES (

...

http://dhaneenja.spaces.live.com/blog/cns!52063E89E23A5AAB!390.entry

thanks guys it's done.