How will u test the stroded procedures and functions?
difference between SP and Triggers
Answers were Sorted based on User's Feedback
Answer / anand vanam
What is the difference between Functions and Stored
Procedures?
Answer:
1. Stored procedure supports deferred name resolution: but
Function won’t support deferred name resolution.
2. Stored procedures return always an integer value by
default zero. Where as function Scalar (single value or
table or row set)
3. Stored procedures are precompiled execution plan but
functions are not.
4. The result of the user defined function can be used with
in a sql server statement. Where as the result of stored
procedures can’t be used in sql server statements.
5. Stored procedure allows all functionality provided by a
function but the reverse is not true.
6. Functions in sql server can be one of two different types
1.scalar, 2. Table
Stored procedures are 2 types. 1. Regular sp, 2. Temporary
sp
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / surya
we can write store procedure without table also..but not
triggres..
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the different authentication modes in sql server?
What is the server name for sql management studio?
What is a partitioned view?
What is a print index?
What are scalar functions?
What is checkpoint in sql server?
What is raid and what are different types of raid levels?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Where the sql logs gets stored? : sql server database administration
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can Having clause be used without Group by clause?
6 Answers CarrizalSoft Technologies, CSC, CTS,
How will you make an attribute not process? : sql server analysis services, ssas
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)