How do I run a trace in sql server?

0 Answers  

---

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

How to receive output values from stored procedures?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

Explain the difference between cross join and full outer join?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

What are scalar functions in sql?

0 Answers  

---