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|
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
how many no of arguments can be passed in procedures and functions
what is the sql equivaent of the dataset relation object ?
How many types of indexes are there in SQL Server?
Explain couple pf features of SQL server
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to write stored procedure to update the data in 10 tables
How do you use DBCC statements to monitor various aspects of a SQL server installation?
what is the difference between table and view
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?