Answers were Sorted based on User's Feedback
Answer / parifs
Functions - the tasks or actions that software is intended
|Is This Answer Correct ?||2 Yes||0 No|
Answer / kotikhammam
Functions are saved T-sql routines that returns a value.
|Is This Answer Correct ?||1 Yes||0 No|
Answer / subrahmanyam
Function is collection of T-Sql statements and used as unit
|Is This Answer Correct ?||0 Yes||0 No|
How would you Update the rows which are divisible by 10, given a set of numbers in column?
how many types of store procedre in sqlserver 2000?
How to Handle the exceptions in Sqlsrver 2005??
what is Constraint? How many types of constraints in SQL ?
What is the difference between views and stored procedures? Can we have input parameters for views?
When do you use SQL Profiler?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
does physical index sort data
on line cluster can we make if yes tell me the procedure
What is a Join in SQL Server?
what is the purpose of creating view is sql server 2000