What is the sql case statement used for?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What happens if null values are involved in boolean operations?

0 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

What is the order in which the sql query is executed?

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

How to check if a table is being used in sql server?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---