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

Explain about builtinadministrator?

1061

---

What are the difference between “where” and “having” clause in sql server?

1075

---

Explain aggregate functions?

1086

---

What is transaction server consistency?

1050

---

What does asynchronous call backs means?

1161

---

Differentiate between a local and a global temporary table?

957

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

994

---

What do you mean by a Composite primary key?

1105

---

Can truncate be rolled back?

950

---

What is the sql profiler?

947

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1947

---

Explain indexes disadvantages?

1089

---

What are distinctive joins find as a part of sql?

953

---

Explain the use of containers in ssis?

967

---

How you can get the list of largest tables in a database?

1018

---