Answer Detail: RE: What is the code to create a table having a column...

GeekInterview.com > Interview Questions > Database > SQL Server

Print |

Question: What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.

June 06, 2006 00:01:05	#2
rick	Member Since: Visitor Total Comments: N/A
RE: What is the code to create a table having a column...
CREATE TABLE mytable ([Date] SMALLDATETIME)

Back To Question