I have one doubt for sql

Question

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

Nitin Sontakke · 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!

Mangesh G · Answer

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

Amudhan Kuppan · Answer

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 Kuppan · Answer

yes nithin UDF i think

Amudhan Kuppan · Answer

ok nithin sure i need use function also please help me nithin

Amudhan Kuppan · Answer

ok nithin sure i need use function also

Nitin Sontakke · Answer

@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 Kuppan · Answer

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 Kuppan · Answer

thank you mangesh

Mangesh G · Answer

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 Kuppan · Answer

ok i will check and let you know mangesh

Mangesh G · Answer

what error u are getting ? well remove () around student just student i just specified it for the table name

Nitin Sontakke · Answer

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 G · Answer

what error u are getting ?

Amudhan Kuppan · Answer

i have one error please help mangesh i will send screenshot

I have one doubt for sql

Answers (15)