Answer / Shashank Tyagi

In SQL (Structured Query Language), a clause is a part of a query that serves a specific purpose. Clauses are used to filter, sort, or group the data returned by a query. Some common clauses include SELECT, FROM, WHERE, GROUP BY, and ORDER BY.

What is scalar function in sql?

1 Answers  

---

what is the difference between blob and text? : Sql dba

1 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

what is sp_pkeys? : Transact sql

1 Answers  

---

Does truncate require commit?

1 Answers  

---

Why function is used in sql?

1 Answers  

---

How do I view an execution plan in sql?

1 Answers  

---

What is set transaction?

1 Answers  

---

Is clustered index a primary key?

1 Answers  

---

can i call procedure in package

3 Answers   TCS,

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

Is sql easier than java?

1 Answers  

---