Answer / Nitin Paliwal

DDL (Data Definition Language) statements for tables in MS SQL Server include CREATE TABLE, ALTER TABLE, DROP TABLE, and TRUNCATE TABLE. These statements are used to create, modify, delete, or clear the contents of a table.

Tell me what is normalization? Explain different forms of normalization?

1 Answers  

---

Does partitioning improve performance?

1 Answers  

---

How to set database to be single_user in ms sql server?

1 Answers  

---

How to link tables in sql server?

1 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

How do I delete a sql server database?

1 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,

---

How do you create a data source?

1 Answers  

---

What are date and time data types in ms sql server?

1 Answers  

---

What is sql server database?

1 Answers  

---

Where are full-text indexes stored?

1 Answers  

---