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 do you mean by SQL injection attack?
where do you use Isolations?give me some exmpale?
What is the new security features added in sql server 2014? : sql server security
what is Constraint? How many types of constraints in SQL ?
38 Answers HCL, IBM, NIIT, Wipro,
What is after dml trigger?
What is the difference between join and inner join?
How can we check the sql server version?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
Differencr Between DELETE and TRUNCATE?
According to you what goes into making the best database administrator? : sql server database administration
select names starts with a,b,c
8 Answers Scope International,
What you can do to delete a table without the delete trigger firing?
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)