If I want everything in a stored procedure to roll back if any part fails, does it need begin/commit transaction?
Also, if I insert into tableM and just after need the indentity value from that insert, is @@IDENTITY the correct way to get it? @@IDENTITY will get the last indentity value on any connection so I'm not sure about using it. But does being in a sproc or transaction make a different?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
This article will describe one method to parse a delimited string into a table of data.
Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message.
In the To field, type your recipient's fax number @efaxsend.com.
You can even send a secure international fax — just include t…