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 |
What are the steps to process a single select statement?
How many types of stored procedures are there in sql server?
What is update locks?
How to find the latest updated value in a table without sending any parameters to that query
Simple example for difference between select and cursor in sql
What is an example of a foreign key?
What are subqueries in sql server?
How to encrypt Strored Procedure in SQL SERVER?
what is trigger
1 Answers CarrizalSoft Technologies, NIIT,
What are a scheduled jobs or what is a scheduled tasks?
What are the system database in sql server 2005?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Oracle (3253)
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)