You havn't got it: I don´t whant the alias BIRTHDATE on the column. If the month of the field birthdate is january, I want the alias to '1', ... if...
How can I be sure that all records on the LDF have been recorded on the MDF? I want to delete the LDF and atatch only the MDF, but I do not want to...
declare @mes smallint, @extenso as varchar(255) set @mes=datepart(mm,getdate()) set @extenso = DATENAME(month, getdate()) EXEC('select fdata as...
This one is crazy.... I need to dynamically give an alias to a field of my select. Something like this: SELECT NAME, BIRTHDATE AS MONTH(BIRTHDATE)...
Separate names with a comma.