Sql Server CheckÔ¼Êø - MS-SQL Server / »ù´¡Àà

±íÃû£ºtb_star

×ֶΣºstar_id¡¡¡¡¡¡int
¡¡¡¡¡¡star_name varchar(50)



дһ¸öCheckÔ¼Êø£ºÒªÇóstar_name±ØÐë°üº¬andy»òjay¡¡¡¡¡¡

---

½¨table ?
SQL code:
create table tb_star(

star_id int,
star_name varchar(50),
CONSTRAINT check_name CHECK (charindex('andy',star_name)>0 or charindex('jay',star_name)>0 )
)

---

SQL code:
create table tb_star(star_id int,star_name varchar(50) check(star_name like '%andy%' or star_name like '%jay%'))

---

SQL code:

--¼Ócheck
Alter table tb_star add CONSTRAINT check_name CHECK (charindex('andy',star_name)>0 or charindex('jay',star_name)>0 )

---

SQL code:

CREATE TABLE tb_star(
star_id int NOT NULL,
star_name varchar(50) NOT NULL,
CONSTRAINT PK_tb_star PRIMARY KEY CLUSTERED(star_id),
CONSTRAINT CK_tb_star_star_name CHECK(star_name LIKE '%andy%' OR star_name LIKE '%jay%')
)

---

create table tb_star(

 star_id int,
 star_name varchar(50),