h1

Tipuri de date MsSql si tipuri bd mssql

November 10, 2009

In continuare vom descrie pe scurt tipurile de BD sistem aflate in Object Explorer ->Databases->System Databases ca in printscreen-ul de mai jos:

tipuribd

master – BD ce controleaza BD ale fiecarui user in parte (conectat pe un anumit server), configureaza variabilele mediului de lucru, erorile si mesajele de eroare sistem

Exista 2 tipuri de BD: a) System Databases cum sunt acestea

b) User Databases create de user (comanda CREATE DATABASE)

model – furnizeaza un template sau prototip pt.noile baze de date create de utilizatori (practic aceasta bd este folosita atunci cand un nou user creeaza o noua bd cu CREATE DATABASE)

tempdb – temporary tables and other temporary storage needs

msdb- storage area for scheduling information and job history

Tipurile de date disponibile in MSSQL:

int

bigint

float

binary

bit -valoare booleana 0 sau 1

char(10)

datetime

timestamp

decimal(3,2) – 3 zecimale ; 2 zecimale dupa virgula

image

money

nchar(10)

ntext

numeric(18,0)

nvarchar(50)

nvarchar(MAX)

real

smalldatetime

real

smallint

sql_variant

text

tinyint

uniqueidentifier

varbinary(50)

varbinary(MAX)

varchar(50)

varchar(MAX)

xml

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: