Interested to Buy Any Domain ? << Click Here >> for more details...
can we call functions from stored procedure in SQL Server
2005 ? How?
- 3 Answers
- 11792 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 purpose of self join?
What are transactions and its controls?
what is a join and explain different types of joins? : Sql server database administration
From where can you change the default port?
Can you roll back the ddl statement in a trigger?
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
Can store procedure call by user define function in SQL server?
How many non clustered indexes there can be on table ?
What is the dbcc command and why is it used?
How do you create type- insensitive operator?
Is the order of columns in the set clause important in ms sql server?
Why main is user defined 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)
