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 how to integrate the ssrs reports in application?

943

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1006

---

How does the report manager work in SSRS?

142

---

What is sql server profiler?

954

---

What is a database table?

924

---

How do you delete a trigger?

917

---

how many type of indexing in database?

935

---

What do you understand by recursive stored procedure?

873

---

What are logical database components? : SQL Server Architecture

959

---

What is inner join? Explain with an example?

1117

---

application server is slow what may be the problem

2165

---

What are various ways to enhance the ssrs report?

920

---

What is the maximum size of column in sql server?

845

---

Do you know what is a trace frag? Where do we use it?

956

---

Is there any difference between primary key and unique with the not null condition?

886

---