Interested to Buy Any Domain ? << Click Here >> for more details...
when we use function instead of procedure? plz tell me the
situation with ex?
- 3 Answers
- 11220 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / adil khan
procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get a list of columns in a view using "sys.columns" in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
You want to implement the one-to-many relationship while designing tables. How would you do it?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are the restraints imposed on the table design by a merge replication?
What is a non equi join?
What is a linked server in sql server?
Explain hostprotectionattribute in sql server 2005?
How do I port a number to sql server?
What type of locking occurs during the snapshot generation? : sql server replication
How many cores do I need for sql server 2016?
What is the difference between count () and rowcount ()?
What type of Index will get created after executing the above statement?
