Answer Posted / chauhan rakesh botad

1>Procedure can return zero or n values whereas function can
return one value which is mandatory.

2>Procedures can have input,output parameters for it whereas
functions can have only input parameters.

3>Procedure allow select as well as DML statement in it
whereas function allow only select statement in it.

4>Functions can be called from procedure whereas procedures
cannot be called from function.

5>Exception can be handled by try-catch block in a procedure
whereas try-catch block cannot be used in a function.

6>We can go for transaction management in procedure whereas
we can't go in function.

7>Procedures can not be utilized in a select statement
whereas function can be embedded in a select statement.

Explain a checkpoint?

1018

---

Difference between report and query parameter. Why do we need different type of parameter?

944

---

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

902

---

What is the difference between count () and rowcount ()?

1016

---

What do mean by xml datatype?

1085

---

What are cursors stored procedures and triggers?

1003

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1063

---

how many type of indexing in database?

975

---

Will the writetext statement activate a trigger?

1079

---

why would you use sql agent? : Sql server database administration

1200

---

What is difference between clustered and non clustered index?

978

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1148

---

Explain magic tables in sql server?

1048

---

How to list all field names in the result set using mssql_field_name()?

907

---

What is data source in connection string?

900

---