How to connect to a sql server using odbc_connect()?

0 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

What are the properties of the transaction?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What are .mdf files?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

What is openrowset sql server?

0 Answers  

---

What is difference between index seek vs. Index scan?

0 Answers  

---