Interested to Buy Any Domain ? << Click Here >> for more details...
can we call functions from stored procedure in SQL Server
2005 ? How?
- 3 Answers
- 11909 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 implicit mode in sql server?
Explain contrast amongst grouped and non-bunched records?
What is the purpose of sql profiler in sql server?
explain different types of joins? : Sql server database administration
how can a database be repaired? : Sql server administration
logshipping is Any difference 2000 and 2005?
What are triggers in ms sql server?
what is Archive old data?
Diffrent types of function
What is the difference between inner join and equi join?
Explain the storage models of OLAP?
What are the parts of a function?
-
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)
