Interested to Buy Any Domain ? << Click Here >> for more details...
can we call functions from stored procedure in SQL Server
2005 ? How?
- 3 Answers
- 11889 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 |
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Define full outer join in sql server joins?
What is @@rowcount in sql?
How to select true false based on column value in sql server?
What is sql service broker?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is an identity column in insert statements?
What is bcnf normalization form?
What is Schema? and why we use schemas?
How many .ndf files can we create in Sql server 2005?
What are the advantages of paper records?
What are the different types of columns types constraints in the 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)
