Hello Folks, today we will explore regarding Top 5 Static code Analysis Tools for Visual Studio, which also includes other
Month: December 2019
What is the use of @@TRANCOUNT in SQL Server?
Returns the number of active transactions for the current connection. PRINT @@TRANCOUNT — The BEGIN TRAN statement will increment the
How to return XML in SQL Server?
We can use FOR XML statement at the end of the query to return xml data from the SQL Server.
What is trigger in sql server?
Triggers allows us to execute a batch of SQL code when either an insert, update or delete command is executed