Answer Posted / kumar

Alredy We are having the emp table in our database at the
time only we can insert the data otherwise not possible.

We can insert the data into emp table into 2 ways by using insert command.Two syntax of insert command given below

1.insert into tablename values(<values list>)
2.insert into tablename(<column list>) values(<spcified column values >)

Define Unique Key?

1019

---

What are the differences between left join and inner join in sql server?

1110

---

How to enforce security in sql server? : sql server security

1111

---

What is rs.exe utility?

156

---

What is it unwise to create wide clustered index keys?

1007

---

Explain DBCC?

967

---

What are scheduled tasks in sql server?

1086

---

How to change parameter value inside the report?

164

---

What guidelines should be followed to help minimize deadlocks?

945

---

What is scalar user-defined function?

1109

---

What is isnull() operator?

1044

---

What is a matrix in ssrs?

153

---

What is normalization of database? What are its benefits?

1028

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1333

---

What is the partitioning method?

1021

---