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 - 2001-05-30 : 09:43:39
|
Nat Geronimo writes "I would like to develop a simple Stored Procudure that queries a single value of a column. One it identifies the value, it updates that value with a new static value.
ie:
select name from user
update user set name="Bob" where name="&name_value&"
I know how to do this in PLSQL, but not in a TSQL stored procedure. Can you please help?
Nat Geronimo" |
|
|
|
|
|
Using a Stored Procedure to Select a Value and then Update the Value