Interested to Buy Any Domain ? << Click Here >> for more details...
can we call functions from stored procedure in SQL Server
2005 ? How?
- 3 Answers
- 12021 Views
- I also Faced
- E-Mail Answers
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 is the distinction amongst delete and truncate?
What is a bit datatype?
How to write a query with a right outer join in ms sql server?
What is transact-sql language?
What does the not null constraint do?
What xml support does the sql server extend?
what purpose does the model database serve? : Sql server database administration
Where the sql logs gets stored?
how to get max salary with employee number by using one select query and max function ??
How to use “drop” keyword in sql server and give an example?
How to execute function in stored procedure sql server?
Tell me can we use custom code in ssrs?
-
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)
