Answer Posted / namz

Work Area used by the SQL statement

How to create prepared statements using odbc_prepare()?

776

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

757

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

719

---

what information is maintained within the msdb database? : Sql server administration

699

---

Explain transaction server distributed transaction?

675

---

---

Explain powershell included in sql server 2008?

765

---

What is the xml datatype?

805

---

What is sub-query in sql server? Explain its properties.

808

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2032

---

Do you know what is a with(nolock)?

792

---

How to create a dynamic cursor with the dynamic option?

718

---

What is the stored procedure?

748

---

How do I create a stored procedure in dbml?

687

---

Define left outer join in sql server joins?

710

---

What are the advantages of stored procedure in sql server?

635

---