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
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
|Is This Answer Correct ?||9 Yes||2 No|
Answer / surya
we can write store procedure without table also..but not
|Is This Answer Correct ?||1 Yes||0 No|
hi,i want t0 knom d syntax for a super key with an example
what is trigger . hw will it use them
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
how to select 5 to 7 rows from a table, which contains 10 rows?
How do we get current date in SQL Server 2000, Oracle, MS Access?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are the different types of replication? How are they used?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
What is DAC? what is the use of it?
What is the difference between HAVING clause and the WHERE clause?
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
From where can you change the default port?