Answer Posted / arif

function can not have update,delete or insert statement but
Stored procedure can have

Write a sql query to get zero records from a table having n number of records?

1179

---

Can you explain different types of locks in sql server?

947

---

Why do you need a sql server?

1108

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

---

How to use group functions in the select clause in ms sql server?

1052

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

956

---

How to download and install microsoft sql server management studio express?

1037

---

What is default constraint in ms sql server?

1034

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1122

---

How do you check sql server is up and running?

1001

---

How do I view a stored procedure in sql server?

982

---

How you can move data or databases between servers and databases in sql server?

1049

---

What are a scheduled jobs?

956

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1134

---

Tell me when is the update_statistics command used?

1111

---