Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2006-01-12 : 01:14:35
|
| Is there a way to create functions in MS SQL Server 7.0? If not, can I create a stored procedure instead and use it in the select query.for example I've got a number stored in the database and I write a stored procedure to decode that number and read the string description associated with it. and then I use it in select statement to print the description along with other fields instead of numbers.thanks,ujjaval |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-12 : 01:30:29
|
| Functions are not available in SQL Server 7.0You can get the output of the procedure into a temp table and use it in a query. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-12 : 02:24:10
|
| Make use of stored procedureMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
function in SQL Server 7.0