Source Code for Me (s-c.me)

Code's Tags

- TSQL
Your Codes

None
Reffers

- http://163.26.101.129/phpbb/pr...
- http://www.roidsmall.com/links...
Linked Codes

- 1945. <Module> <!-- You can modify
- 1944. <iframe width="600" height="40
- 1943. TRUNCATE TABLE DevicesData DE
- 1942. CREATE TABLE DevicesData (
- 1941. USE master ALTER DATABASE Test
- 1939. SET NOCOUNT ON SET TRANSACTION
- 1938. SET NOCOUNT ON SET TRANSACTION
- 1937. SET TRANSACTION ISOLATION LEVE
- 1936. SET TRANSACTION ISOLATION LEVE
- 1935. SET TRANSACTION ISOLATION LEVE

Code:

As HTMLAs CSS Selected Language:
Show Linenumbers:

Short link for Twitter:

HTML:

<blockquote><code><a href="http://s-c.me/1940/s">Copy&nbsp;Source</a>&nbsp;|&nbsp;<a href="http://s-c.me/1940/h">Copy&nbsp;HTML</a> SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL SNAPSHOT &nbsp; DECLARE @SumVal int BEGIN TRANSACTION SELECT @SumVal = SUM(Value) FROM DevicesData WHERE DeviceId &gt; 999000 WAITFOR DELAY '00:00:03' IF (@SumVal) = 0 &nbsp;&nbsp;&nbsp;INSERT INTO DevicesData (DeviceId, Value) VALUES (1000000, 111) COMMIT </code></blockquote>

Copy to clipboard (IE,FF)

HTML view:

Copy Source | Copy HTML SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL SNAPSHOT DECLARE @SumVal int BEGIN TRANSACTION SELECT @SumVal = SUM(Value) FROM DevicesData WHERE DeviceId > 999000 WAITFOR DELAY '00:00:03' IF (@SumVal) = 0 INSERT INTO DevicesData (DeviceId, Value) VALUES (1000000, 111) COMMIT

Source Code for Me (s-c.me)

Code's Tags

Your Codes

Reffers

Linked Codes