SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
what is formula to cal cute earth pit numbers and size of earth strip used in earthing?
can any one post the written test exam model papers for amar raja baterries in tirupati
hi this is hema, r there any books in particular for the preparation of the APPSC-A.E.E(electrical), if so please mail me the names ... thank u .
write a C program: To recognize date of any format even formats like "feb-02-2003","02-february-2003",mm/dd/yy, dd/mm/yy and display it as mm/dd/yy.
What do you do when in your duty, ME alarm oil mist detect high density?
What are the four features of Big Data?
u r an engineering student why po job?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
sample & previous year papers of sta & je (electronics 0
How many tabs in a tabbed dialog do you consider appropriate?
How can we communicate as realistic a picture as possible of a job and of the organization to prospective employees? What kinds of issues are most crucial to them?
what is the water cement ratio of 1:6 and 1:4 cement sand mortar. reply soon
Can an inverter be used as a converter? How?
Static and instance variable and method with live example. Why and when to use