I have a column with values like "050706" I would like to change this to datetime type. The varchar represents 05 month, 07 date and 06 is the year...
Thank you guys. Problem Solved.
adrian thats a good idea but unfortunately my system architect doesnt want me to have null values and then handle them. He want me to populate the...
I dont need the current datetime. I need to insert the maximum value of datetime datatype supported by SQL 2000 as default.
I need help with inserting maximum value of datetime datatype in a column as default. I have a table with column Enddate defined with datetime...
Separate names with a comma.
