What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What is the purpose of data source?

0 Answers  

---

How to create new table with "create table" statements?

0 Answers  

---

What is a covered index?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---

How to provide column names in insert statements in ms sql server?

0 Answers  

---

When you use @@error and try-catch?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Explain how does the report manager work in ssrs?

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---