Answer Posted / pradeep aryan
1. Function can returtn single value but proc san return
multiple values
2. Proc can call a function but function not.
3. function can call in select statement also and acn perform
action also but proc not.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What have included columns when we talk about sql server indexing?
How can we rewrite sub-queries into simple select statements or with joins?
what is unique and xaml nonclustered index
What will be the maximum number of index per table?
What are a scheduled jobs?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
How to create new tables with "create table" statements in ms sql server?
Explain system scalar functions?
What command must you use to include the not null constraint after a table has already been created?
What are drilldown reports?
What is standby servers? Explain types of standby servers.
What happens if ntwdblib.dll is missing on your machine?
What are the restrictions that views have to follow? : SQL Server Architecture
Is null vs coalesce?
What is the difference between set and select?