I have one doubt for sql

Amudhan Kuppan

8y975SQL

hi,

anyone clear my doubt please i will send one file please check this is my table and how will you create a computed column age in my table please anyone help me

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
Do you mean User Defined Function (UDF)? If yes, please say so.

For such a small calculation why do you want a UDF anyway? Is this is a real project or an interview question?

Do we have to keep on guessing what exactly you want. DateDiff is a function, which I already used!
Amudhan Kuppan8y ago
this is correct requirement nithin please help me
hi
anyone help me it is possible if possible please send a query mostly iam tried i will send requirement
requirement.
when we wish to be find age or get age for date of birth we should be derive at that time
so is there any way to derived age automatically when ever required.
Solutions.
its many many way to get the age automatically
1) use function
2) computed column.
etc.
Amudhan Kuppan8y ago
yes nithin UDF i think
Amudhan Kuppan8y ago
ok nithin sure i need use function also please help me nithin
Amudhan Kuppan8y ago
ok nithin sure i need use function also
Nitin Sontakke8y ago
@Amudhan,

In your original question you asked for 'computed column'. Mangesh gave you script for 'computed column'.

Now you are saying: "I need to calculate age using computed column or function". What exactly does that mean?

Please be very specific in your question. What exactly you want?

If you wish, you can use it as follows:
select *
  ,datediff(year, [DateOfBirth], getDate()) [Age]
from [dbo].[Student]
Amudhan Kuppan8y ago
ALTER TABLE (TableName) ADD Age AS DATEDIFF(YEAR, DOB, GETDATE())

Mangesh this is computed column i need to calculate age using computed column or function please help me mangesh
Amudhan Kuppan8y ago
thank you mangesh
Mangesh G8y ago
Agree with Nitin Sir for the SQL we need the script that will be helpful here

and close question if it works for u
Amudhan Kuppan8y ago
ok i will check and let you know mangesh
Mangesh G8y ago
what error u are getting ?
well remove () around student

just student i just specified it for the table name
Nitin Sontakke8y ago
You took efforts to create a dummy table, populated it with data and provided an image to us! How helpful is that?

Going forward, please give the script as a text so that we can help you better.

Hope you get the point.
Mangesh G8y ago
what error u are getting ?
Amudhan Kuppan8y ago
i have one error please help mangesh i will send screenshot
Mangesh G8y ago
ALTER TABLE (TableName) ADD Age AS DATEDIFF(YEAR, DOB, GETDATE())

Just Add this column and u will be done for new Records it will automatically calculate the age
for old u need to do it manually