Answer Posted / a.suresh

1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name

What is index, cluster index and nonclustered index?

943

---

What are character string data types in ms sql server?

1166

---

Explain primary key and foreign key constraints?

973

---

How can you set the threshold at which sql server will generate keysets asynchronously?

952

---

Indexes are updated automatically is the full-text index also updated automatically?

989

---

What are the new features are introduced in sql server 2012 reporting services?

145

---

Does group by or order by come first?

909

---

Tell me what is log shipping?

948

---

What is intellisense?

1005

---

What are the differences between web role and worker role?

122

---

What are the differences between substr and charindex in sql server.

1037

---

How to count groups returned with the group by clause in ms sql server?

1024

---

How to create a view with data from multiple tables?

977

---

Is mysql better than sql server?

1017

---

What is SQL Azure Fabric?

108

---