Add Function

deontae45 · September 25th, 2006, 09:48 AM

How do I Add 1 to a column in a stored procedure?

Alexander Nelson
Programmer

SQLScott · September 25th, 2006, 10:47 AM

Uh...not quite sure what you mean. Do you want to change the column name (for example, Name to Name1) or do you want to change a value in a specific column?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Jeff Mason · September 25th, 2006, 11:31 AM

Not sure I understand your question, but, for example, to add one to every column value for a particular column in a table:

Code:

UPDATE yourtable
    SET yourcolumn = yourcolumn + 1

or to interpret your question another way:

Code:

SELECT yourcolumn + 1 as incrementedcolumn
FROM yourtable

What are you trying to do?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com