when we use function instead of procedure? plz tell me the
situation with ex?
Answers were Sorted based on User's Feedback
Answer / 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 |
Can you get second highest salary from the table?
What is NOT NULL Constraint in sql server 2012?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the pre-defined functions in the sql server?
Write an sql query to find first weekday of the month?
What is a non equi join?
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
What is the function of sql server agent windows service?
What is split brain scenario in DB mirroring?
Do you know the policy based administration feature of sql server 2008?
wht is normalization?can u explain me in detail?