Last post Mar 31, 2015 05:40 AM by angallay
Mar 31, 2015 02:16 AM|angallay|LINK
How to auto increate age (nvarchar(50)) column at the end of every years in sql database.
How to do auto increate age column in database.
Please provide me,
Mar 31, 2015 02:40 AM|oned_gk|LINK
I guess this culumn is not needed because you can calculate dob
Mar 31, 2015 03:19 AM|angallay|LINK
I can't calculate dob column because sometime not insert data in dob column.
Can I auto increate age int type column, but not increate null value in this column at the end of years in database.
Please provide me.
Mar 31, 2015 05:40 AM|angallay|LINK
I solved my problem with the following query.
update TableName set ColumnName=Convert(int,ColumnName)+1 where .............