Wednesday, June 24th, 2009
Se vais fazer o exame de certificação da Microsoft de nome "MCTS Exam 70-432 - Microsoft SQL Server 2008 - Implementation and Maintenance" e queres passar... Não começes a estudar apenas um mês antes da data do exame.
PS: Lá se vai o voucher grátis para estudantes que me permitia fazer ...
Posted in informática | 1 Comment »
Saturday, February 2nd, 2008
Thanks David for your comment on my post.
Now i want to rectify the tip i give to you yesterday.
The best way to make an autonumber field is the Identity "process" - which i didn't know... is:
CREATE TABLE Users(
Id Identity(1,1),
Name nvarchar(50),
Email nvarchar(50),
)
INSERT INTO Users(Name, Email)
VALUES ('Andre', 'aslgomesATgmailDOTcom')
The Identity sintax is: Identity(value start,increment).
More at: MSDN - Identity
Posted in programação | No Comments »
Saturday, February 2nd, 2008
The type uniqueidentifier is the way to make an autoincrement field on a table, using SQL Server.
In this post i will demonstrate how you can autoincrement that field when you make an insert on the table, for example.
Now, creates a simple table:
CREATE TABLE Users(
Id uniqueidentifier,
Name nvarchar(50),
Email nvarchar(50),
)
To insert an element here, in Id field you should use ...
Posted in programação | 3 Comments »
