Definitions More Info.
Definition ID	437
Title	SQL
Category	NOTES
Definition	Data Types Veri Tipleri Tanlo Halinde
Definition Description	Veri Türü SQL Server Ansi Diskteki Boyut( BYTE) - Integer : Int Integer 4 bigint ----- 8 smallint,tinyint ----- 2,1 - Exact (Ör:8.75): decimal[(p[,s])] dec 2-17 - Numeric : numeric[(p[,s])] --- - Approximate : float[(n)] double 8 numeric precission Ör: 1/3 => .333) float[(n)] for n=8-15 ----------------------------------------------------------------------------------------------------- float[(n)] for 4 n=1-17 - Monetary : money,smallmoney --- 8,4 - Date and Time : datetime, smalldatetime --- - Caharacter : char[(n)] character [(n)] 0-8000 varchar[(n)] char VARYING[(n)] text --- 0-2 GB - Unicode nchar[(n)] --- 0 - 8000 character nvarchar[(n)] (4000 karakter) ntext 0 - 2 GB - Binary : binary[(n)] --- 0 - 0-8000 varbinary[(n)] VARYING[(n)] - Image : image --- 0-2 GB - Global identifier: uniqueidentifier --- 16 - Special : bit --- 1,0 - 8 Uniqueidentifier timestamp rowversion 8 sysname --- 256 table --- sql_variant --- 0 - 8016
RecordBy	cunay
Record Date	22-03-2014 17:37:23
Düzenle
Kopyala
Sil