Discuss the security levels which are assigned to users?

702

---

How to get last inserted id using laravel query?

741

---

What is the difference between stored procedure & function?

961

---

What is the default left margin in word 2010?

556

---

Do you know sql server 2008 backup compression?

958

---

How to open a link in new tab or window?

927

---

Do I need python if I have anaconda?

873

---

What is id in ios?

805

---

What is sap s/4hana?

95

---

What is ROI in Automation Anywhere?

58

---

What are some problems which we face while the development of a project when maven is not used?

171

---

what are the uniform public construction cost accounting act procedures?

1964

---

why we using different type of microwave antenna we using like one is connected to MMU and one more is connected to other slot what is use of both antenna?

1941

---

What is Microsoft Azure?

577

---

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.

2668

---