Answer / Siddharth Mansaram Badwaik

"To use column default values in INSERT statements in MS SQL Server, simply omit the value for a specific column during the insert operation. If a column has a default value defined, that default will be used."

What are the new scripting capabilities of ssms? : sql server management studio

1 Answers  

---

How to find tables without indexes?

1 Answers  

---

What are number line correlation administrators will use while working with a subquery?

1 Answers  

---

How many columns can we include on clustered index ?

1 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

Why I have to use stored procedures?

1 Answers   Cognizant,

---

What is the purpose of optimization?

1 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

How much is a sql server license?

1 Answers  

---

What is transaction server explicit transaction?

1 Answers  

---

What is difference between join and natural join?

1 Answers  

---