What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / appu
1.we can't call stored procedure inside query instead we can call function inside query.
2.we can't use stored procedure in select statement where as we can use function in select statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do mean by xml datatype?
What is the temp table?
How to define output parameters in stored procedures?
Why olap is used?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is intellisense?
Is it possible to update the views? If yes, how, if not, why?
How do I find the transaction log size in sql server?
How to call stored procedure using http soap?
What is the difference between a "where" clause and a "having" clause?
Does hive support indexing?
what data regions are and what are the different data regions?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
can an automatic recovery be initiated by a user? : Sql server administration
Do you know what is sql injection?