visitCounter++; textBox1.Text = visitCounter;
create TABLE ED( ID INTEGER PRIMARY KEY IDENTITY(1, 1) , UserID AS 'ED' + CAST(ID AS VARCHAR(32)) , I INTEGER ) DECLARE @I INTEGER SET @I = 0 WHILE @I < 100 BEGIN SET @I = @I + 1 INSERT INTO ED VALUES (@I) END
CREATE TABLE user(id INT NOT NULL IDENTITY(1,1), col AS 'ED'+ RIGHT( '0'+CAST(id AS VARCHAR(2)),2)) INSERT INTO userDEFAULT VALUES SELECT * FROM user
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)