Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the differences between stored procedure and
functions in SQL Server 2000?

Answer Posted / lrk

The Text property exposes the Transact-SQL or other script
that defines the referenced Microsoft? SQL Server? 2000
database object.

The FunctionName property specifies the function name to
call in the Microsoft? ActiveX? script associated with a
script task or step.

Is This Answer Correct ?    38 Yes 73 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the properties of a relational table?

1014


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

955


what are the reporting service components in SSRS?

163


Name few of the dcl commands in sql?

1001


Write a sql query to sort on different column name according to the parameters passed in the function?

890


Tell me what is de-normalization and what are some of the examples of it?

1013


If a stored procedure is taking a table data type, how it looks?

6429


What is table constraint?

985


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

2222


What is the difference between a fill factor of 100 and 0?

976


What is the downside of using udf?

1098


Differentiate sql server reporting services vs. Crystal reports?

200


Does transparent data encryption provide encryption when transmitting data across the network?

1028


How to perform key word search in tables?

954


What are the advantages of using stored procedures?

942