I have a table in MS SQL that has people register for a newsletter and I want to add an ID so I can pull that number and show it in my ASP home page as the number of registered newsletter users. Example we have 2,301 newsletter users. So when I add a new newsletter user I want that number to go up.
2007-01-02 12:18:37 · 4 answers · asked by Gonzalo P 2 in Computers & Internet ➔ Programming & Design
I answered this previously.
http://answers.yahoo.com/question/index?qid=20070102171341AAiPvtT
2007-01-02 12:31:53 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Use the IDENTITY(x,y) datatype for the new column; MS SQL will increment the value with each new row created.
I don't have MS SQL here to test, but when the column is added, if MS SQL doesn't initialize the column, you could write an upte command to do that.
2007-01-02 12:32:53 · answer #2 · answered by BigRez 6 · 0⤊ 1⤋
it somewhat is obtainable that Tuxedo techniques sq. internally, considering the fact that sq. itself is in basic terms a wide-unfold question language for relational database. Conversely, the utility could use a non-relational database (hierarchical, listed and/or flat data) for its documents retrieval.
2016-11-25 23:38:01 · answer #3 · answered by ? 4 · 0⤊ 0⤋
I imagine you must have some simple table that you can query something like this...
SELECT COUNT(UserName?) FROM MySimpleTable
Otherwise your question is somewhat vague.
2007-01-02 12:26:06 · answer #4 · answered by Anonymous · 0⤊ 0⤋