Answer Posted / mt

select getdate();

How to view existing indexes on an given table using sp_help?

1137

---

Can you pass expressions to stored procedure parameters?

1032

---

What are the types of ssrs?

145

---

How to filter out duplications in the returning rows in ms sql server?

1140

---

Does hive support indexing?

959

---

Is there any difference between the primary key and unique key?

999

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

981

---

How do you test your database? : sql server database administration

1020

---

What is an example of a primary key?

991

---

How to generate create procedure script on an existing stored procedure?

1009

---

What is sql server database?

1009

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

921

---

what are constraints? Explain different types of constraints? : Sql server database administration

984

---

What is user-defined inline table-valued function?

949

---

What are the built in functions in sql server?

983

---