Answer Posted / senthil kumar.m

Declare @sql_tmp varchar(100)

set @sql_tmp="insert into table1(col1,col2..)
select 'val1','val2','') "

sp_executesql @sql_tmp

Why normalization is used?

1065

---

Differentiate between delete and truncate.

1110

---

Explain about Views?

1120

---

Explain intellisense for query editing

1074

---

Define right outer join in sql server joins?

1108

---

What are the limitations in ssrs on sql server express edition?

195

---

Create and insert into temp table in sql server?

1080

---

Find first and last day of current month in sql server

1080

---

explain different types of constraints? : Sql server database administration

998

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

949

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1185

---

What is difference between group by and having?

990

---

What are user defined functions in ms sql server?

1062

---

What is an execution plan?

1234

---

What is the data tier application?

169

---