代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/147091/5733462
sql unique.sql
alter table student
add constraint unq_telno unique(telno)
www.eeworm.com/read/147091/5733463
sql check.sql
alter table student
add sex char check(sex='M' or sex='F')
www.eeworm.com/read/147091/5733464
sql identity.sql
create table student
( studid int identity(101,5),
firstname varchar(20) not null,
lastname varchar(20) not null
)
www.eeworm.com/read/147091/5733467
sql default.sql
alter table studmarks
add constraint DF_examid default(101)for examid
www.eeworm.com/read/147091/5733473
sql is-null.sql
--在下面的示例中，对于所有预付款少于 $5,000 或者预付款未知（或为 NULL）的书，
--返回它们的书号及预付款。
USE pubs
SELECT title_id, advance
FROM titles
WHERE advance < $5000 OR advance IS NULL
ORDER BY title_id
--
select * from d
www.eeworm.com/read/147091/5733478
sql escape.sql
create table t1
(
c1 int,
c2 char(10)
)
go
insert into t1 values(1,'冰箱A_100')
insert into t1 values(2,'冰箱A_200')
insert into t1 values(3,'冰箱B_200')
insert into t1 values(4,'冰箱A_%%')
go
se
www.eeworm.com/read/147091/5733484
sql in-1.sql
USE pubs
SELECT au_lname, state
FROM authors
WHERE state IN ('CA', 'IN', 'MD')
www.eeworm.com/read/147091/5733489
sql in-2.sql
USE pubs
SELECT au_lname, au_fname
FROM authors
WHERE au_id IN
(SELECT au_id
FROM titleauthor
WHERE royaltyper < 50)
www.eeworm.com/read/147091/5733492
sql in-3.sql
USE pubs
SELECT au_lname, au_fname
FROM authors
WHERE au_id NOT IN
(SELECT au_id
FROM titleauthor
WHERE royaltyper < 50)
www.eeworm.com/read/147091/5733508
sql encryption.sql
use pubs
go
CREATE view VIEW_author_title1
with encryption
AS
SELECT authors.au_lname, authors.au_fname, titles.title
FROM authors INNER JOIN
titleauthor ON authors.au_id = titleauthor.au