Dont aware of this Output clause...
can anyone explain this well with a example?
Explanation and examples can be found here: http://msdn.microsoft.com/en-us/library/ms177564.aspx
If you still have questions after that, feel free to post those questions here.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis