can we call functions from stored procedure in SQL Server
2005 ? How?
Answers were Sorted based on User's Feedback
Answer / monal
Yes you can call function from stored procedure, so far i
haven't had a chance to use it, but still would like to give
it a shot:
As per my guess you can call function in SP using select
statement as you would execute function usually.
| Is This Answer Correct ? | 26 Yes | 5 No |
Answer / suraj
Yes, we can.
Eg:
create proc Test
as
select getdate()
GO
-- EXEC Test
-- in the above query getdate() is a system function.
| Is This Answer Correct ? | 16 Yes | 5 No |
How to call stored procedure using http soap?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to see the event list of an existing trigger using sys.trigger_events?
What is the difference between system objects and user objects?
Where are sql server usernames and passwords stored in the sql server?
What is a recursive stored procedure in sql server?
What are the properties of primary key?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How you can change a cross join into an inner join?
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
What is GUID in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)