MS SQL - MySQL for indra :: Code Pin Board :: Networks

Networks » Code Pin Board » MS SQL - MySQL for indra

JavaScript is not enabled on your browser and in order to properly use Coder Profile JavaScript is required.
To view instructions on how to enable JavaScript on your browser click here.

MS SQL - MySQL for indra

Download Source Code

Author Details

Code Information

Craige ( Craige Leeder )

Pinned 5 Codes
Posted 0 Coding Articles

Send A Message
View Coders Profile

Language	SQL (Structured Query Language)
Expires	Never
Length	423 Characters (23 Lines)
Password	no password

/*
*Known on MS SQL
*/
UPDATE i
SET i.stock = i.stock - t.stock
FROM items i
INNER JOIN codes c
ON c.IDCodes = i.IDItems
INNER JOIN TEMPORARY t
ON t.Code=c.SMSCode
WHERE i.IDItems = '12341'
/*
*Possible MySQL
*/
UPDATE items i
INNER JOIN codes c
ON c.IDCodes = i.IDItems
INNER JOIN TEMPORARY t
ON t.Code=c.SMSCode
SET i.stock = i.stock - t.stock
WHERE i.IDItems = '12341'

Back To Code Pin Board

Post New Code

Please login to post comments.

Latest News About Coder Profile

RSS News Feed

Coder Profile Poll

If you made money from keeping your profile up to date, say $30 and up, per month. What extra time would you spend on your profile?

No extra time
A few hours at weekends
A whole day each week
Every minute i can get free

please login to cast your vote
and see the results of this poll

Latest Coder Profile Changes

Coder Profile was last updated
3.20 Years Ago

RSS Development Blog Feed

Official Blog :: Make A Donation :: Credits :: Contact Me
Terms & Conditions :: Privacy Policy :: Documents :: Wallpapers