Interested to Buy Any Domain ? << Click Here >> for more details...
If you have an application to test and there are no requirement specs, no test cases , no documents, you dont know even the functionality then how would you perform testing?
6 10436Post New Colayer Interview Questions
What is the Concept of Encapsulation in OOPS
What is advantage of java?
What processor architectures are supported by the cloud connector?
When is the next census due in which the Delimitation Commission has proposed that the next census should be panchayat wise?
How do I add office 365 email to outlook?
Where is activex control in chrome?
Which trace flags are enabled in sql server?
What are disadvantages of REST web services?
What are the design resources sub theme will inherit and will not inherit?
What is the latest version of microsoft sql server?
Do you know about trigger.new?
Where the sql database files are stored?
Why should Schlumberger hire you?
Why do we use regex?
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.
