Answer / Manoj Kumar Chaubey

{"block statement": {"description": "A block statement is a series of SQL statements enclosed within BEGIN and END keywords. It allows the grouping of multiple statements to be treated as a single unit."}

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

What is the native system stored procedure to execute a command against all databases?

1 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---

How to display a past time in days, hours and minutes?

1 Answers  

---

Do you know the cursor optimization tips?

1 Answers  

---

Explain contrast amongst grouped and non-bunched records?

1 Answers  

---

What are the differences between stored procedure and the dynamic sql?

1 Answers  

---

Define msdb database?

1 Answers  

---

What is Command line parameters in PLSQL.?

1 Answers   MCN Solutions,

---

What are the steps to follow to configure SQL*Net?

1 Answers   Tech Mahindra,

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

Explain triggers?

1 Answers  

---