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
Explain the properties of a relational table?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
what are the reporting service components in SSRS?
Name few of the dcl commands in sql?
Write a sql query to sort on different column name according to the parameters passed in the function?
Tell me what is de-normalization and what are some of the examples of it?
If a stored procedure is taking a table data type, how it looks?
What is table constraint?
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
What is the difference between a fill factor of 100 and 0?
What is the downside of using udf?
Differentiate sql server reporting services vs. Crystal reports?
Does transparent data encryption provide encryption when transmitting data across the network?
How to perform key word search in tables?
What are the advantages of using stored procedures?