What are the data types allowed in a table

Interview Candidate
Aug 26th, 2004
4
6814

Editorial / Best Answer

Answered by: rajesh

Sep 14th, 2005

binary	Bigint	bit	Char	datetime
decimal	Float	image	Int	Money
nchar	Ntext	nvarchar	Numeric	Real
smalldatetime	smallint	smallmoney	sql_variant	sysname
text	timestamp	tinyint	varbinary	varchar
uniqueidentifier

these are the data types used in sql table

Showing Answers 1 - 4 of 4 Answers

rajesh

Sep 14th, 2005

binary Bigint bit Char datetime
decimal Float image Int Money
nchar Ntext nvarchar Numeric Real
smalldatetime smallint smallmoney sql_variant sysname
text timestamp tinyint varbinary varchar
uniqueidentifier
these are the data types used in sql table

gdurga
Profile Answers by gdurga

Jun 15th, 2009

Dec(p,s), desimal(p,s), double precision, foat, int, inteager, real, smallint, numeric(p,s), number(p,s), char(size), varchar2(size), long, raw, long raw, date, timestamp, urowid(size), rowid, boolean, nchar(size) , nvarchar2(size), bfile, blob, clob, nclob...