Answer / koti-khammam

when QUOTED_IDENTIFIER option is specified as ON ,the
identifiers are placed with in double quotation and
constants are placed with in single quotation.
when QUOTED_IDENTIFIER is OFF,the identifiers are not placed
with in double quotation and we must follow all T-SQL rules
for the identifiers.

Answer / bobby

When SET QUOTED_IDENTIFIER is ON, identifiers can be
delimited by double quotation marks, and literals must be
delimited by single quotation marks. When SET
QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and
must follow all Transact-SQL rules for identifiers. For more
information, see Identifiers. Literals can be delimited by
either single or double quotation marks.

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is the maximum size per database for sql server express?

0 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

Explain identity in sql server?

0 Answers  

---

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

What value could be assigned to Varchar Type?

3 Answers  

---

What is the need for indexing?

0 Answers  

---

Explain how to use linked server?

0 Answers  

---