What are the blocks in stored procedure?

6 Answers   Microsoft,

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

how to create object in plsql

3 Answers   Microsoft,

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

What is a sql select statement?

0 Answers  

---

Is sql dba a good career? : SQL DBA

0 Answers  

---

What are the two types of exceptions.

0 Answers  

---

Is drop table faster than truncate?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---