Link to home
Start Free TrialLog in
Avatar of ASPDEV
ASPDEV

asked on

After SQL INSERT,Show the INSERTED RECORDS or Records afftected in SQL Server 2005

Hello Experts,

I have some special req. where I Insert records from a Text file, once Inserted I need to show the Records successfully Inserted.

For Instance, if i have inserted 10 records, I can get records afftected count. But I need the Result Set of the records affected with the Insert.


Thanks,
ASPDEV
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Imran Javed Zia
Imran Javed Zia
Flag of Pakistan image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ASPDEV
ASPDEV

ASKER

Both of your solutions make sense , I will try it.

Thanks,
ASPDEV.