SQL Server 26 - PRIMARY KEY, NOT NULL, UNIQUE

preview_player
Показать описание


~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
Рекомендации по теме
Комментарии
Автор

your videos is awesome!!! would you explain morE about index in SQL server? or maybe about index selecion.. thankyou!

risasujanawati
Автор

Hi Caleb, can you do a similar video for surrogate keys? Thanks.

merciinike
Автор

bruh. you helped more than my teacher did

WannyPena
Автор

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL, `infor` VARCHAR(150) NOT NULL, `address` VARCHAR(150) NOT NULL )' at line 1


this is the error i have got can you please tell me

sisteminformasi
Автор

create table City
(
CityID int Identity(1, 1) constraint pk_CityID primary key,
CityName varchar(100) constraint uk_CityName unique not null,
)
insert into City values('ynr')
insert into City values('kkr')
insert into City values('chd')
insert into City values('abc')

select * from City
sp_help City




city id city name
4 abc
3 chd
2 kkr
1 ynr


hey...diz iz wOt i got after execution of ma program...so ma question is..why it takes the output in clustered from.and why it picks up the values plz solve it..thnqu so mch

aarzoochopra
Автор

Is not an attribut alway required ? So don't we always have to add NOT NULL or when don't we need to add NOT NULL after an atribute ?

kenzan
Автор

Caleb, why do we still have the "DROP TABLE" line at the top? And since the name of the table is indeed Animals, why wasn't the table deleted in the last video? I must be missing something here lol

thefreaks