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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:29:41
|
| chuff writes "Windows 98SQL Server 7.0I was wondering if it is possible to use a function like statement within a stored procedure? I have a stored procedure that has multiple update and selects statements that are repeated but with different variables. I would like to put the update and select statements in a function and then pass the variables to it, but I don't want to create other stored procedures to do this. Is this possible? I have not been able to find any information that could help me." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-16 : 10:13:52
|
| User-Defined Functions are a SQL 2000 construct and not available in SQL Server 7.0. Maybe you can post the DML of your proc, as there are usually ways to accomplish these types of things with a CASE statement in your WHERE clause.<O> |
 |
|
|
|
|
|
Using a function in a stored procedure???