Answer Posted / rajkumar v

select convert(varchar,getdate(),105)

How to create an index on an existing table in ms sql server?

1024

---

What is candidate key with example?

1030

---

Does index slows down insert statements?

1047

---

What are the different types of join?

1237

---

Are null values the same as that of zero or a blank space?

1088

---

What are the different types of collation sensitivity in sql server?

1162

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

993

---

What is the use of group by clause?

989

---

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?

1144

---

What is the difference between the application object and session object?

1118

---

What is a database in ms sql server?

1103

---

Define outer join in sql server joins?

987

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1064

---

Do you know what is sql service broker?

1161

---

What is amo? : sql server analysis services, ssas

1133

---