Answer / kumar.t

1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.

2. Select Clause we cann't use stored procdure. but
fucntion we can use.

3. XMl Clause contain we can use stored procdure. but
function we cann't use.

4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.

By
Kumar.T

Answer / samant

1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.

2. u can use function in expression but not stored
procedures

How many types of subqueries are there in sql server?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  

---

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  

---

internal language used in sql server 2000?

2 Answers  

---

Explain comment on transactions?

0 Answers  

---

What is a sub-query? When would you use one?

3 Answers  

---

What are diverse clauses that form a part of sql?

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---