No products in the cart.

Diffrence between is selected and set …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Diffrence between is selected and set selected

Posted by Piyush Kumar 8 years, 2 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Naveen Sharma 8 years, 2 months ago

Depending on the scenario you may want to use both SET or SELECT.

Following are few scenarios for using SET

If you are required to assign a single value directly to variable and no query is involved to fetch value
NULL assignments are expected (NULL returned in result set)
Standards are meant to be follow for any planned migration
Non scalar results are expected and are required to be handled

Using SELECT is efficient and flexible in the following few cases.
Multiple variables are being populated by assigning values directly
Multiple variables are being populated by single source (table , view)
Less coding for assigning multiple variables
Use this if you need to get @@ROWCOUNT and @ERROR for last statement executed

ANSWER

http://mycbseguide.com/examin8/

Related Questions

Select round(6.5675,2);

Posted by Simran Batra 1 year, 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Display the details of all the employees whose value is null

Posted by Yashika Kakkar 1 year, 5 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Founder of python

Posted by Parth Chaudhary 1 year, 8 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Write a python program to plot aa bar chart showing the no. Of books published in respective year using the following data

Posted by Maanyata Sharma 1 year, 9 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

Posted by Sejal Gupta 1 year, 5 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Write a program that generates the table of a input number using for loop

Posted by Siya Vishwakarma 1 year, 6 months ago

CBSE > Class 12 > Informatics Practices

1 answers

what are aggregate function inSQL? Name any two

Posted by Arifa Meharun 1 year, 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Consider a given series,M1 write a program in python pandas to create the series

Posted by Martina Sangchoju 1 year, 9 months ago

CBSE > Class 12 > Informatics Practices

2 answers

List down the average of phone number what is the coding I couldn't remember

Posted by Akib Chowdhury 1 year, 5 months ago

CBSE > Class 12 > Informatics Practices

1 answers

All data types of MySQL with example

Posted by Prapti Dubey 1 year, 5 months ago

CBSE > Class 12 > Informatics Practices

0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Google Play

Download myCBSEguide App