Answer / Tanveer Ahmad

To change the name of a database user in MS SQL Server, you can use the ALTER USER command followed by the new username and existing username.

What is the significance of null value and why should we avoid permitting null values?

1 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

1 Answers  

---

What is tempdb in sql server?

1 Answers  

---

Explain the difference between primary keys and foreign keys?

1 Answers  

---

What do I need to start working with sql studio? : sql server management studio

1 Answers  

---

What is ddl and dml commands?

1 Answers  

---

What is surrogate key? : sql server analysis services, ssas

1 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

What is difference between createstatement and preparedstatement?

1 Answers  

---

how many no of arguments can be passed in procedures and functions

2 Answers   ABC,

---

How to list all stored procedures in the current database using ms sql server?

1 Answers  

---