代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/377958/9255435
sql check.sql
alter table customers
add constraint ck_age check (age>3)
go
/*
如果改为age>5，则会出错。
因为表先建立，其中有age=5的数据
或者改为：
alter table customers
add constraint ck_age check (age>=5)
go
*/
alter table c
www.eeworm.com/read/377958/9255436
sql 增删改.sql
select * from customers
go
insert customers
(CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,Country,Phone,Fax)
values
('PECOF','Pecos Coffee Company','Michael Dunn','Owner'
www.eeworm.com/read/377958/9255438
sql proc.sql
use northwind
go
create proc dbo.overdueorders
as
select * from dbo.orders
where requireddate < getdate() and shippeddate is null
go
exec overdueorders
go
select getdate()
go
exec s
www.eeworm.com/read/377958/9255440
sql default.sql
use northwind
go
exec sp_help customers
go
use northwind
go
select * from customers
go
create default df_cust as 'unknow'
go
/*创建默认*/
exec sp_bindefault df_cust,'customers.conta
www.eeworm.com/read/377946/9256453
sql createdb.sql
Part II:
1. CREATE TABLE BOOK
(
PriAut char(10),
Title char(30),
ISBN char(30),
PubID char(10),
Edition integer(4),
PubDate char(20),
Price
www.eeworm.com/read/377869/9260225
sql material.sql
www.eeworm.com/read/181269/9260951
sql libsql.sql
www.eeworm.com/read/181269/9260956
sql createdb.sql
www.eeworm.com/read/181259/9262468
sql userinsert.sql
create trigger USERINSERT on USERINFO for insert
as
if exists (select * from inserted inner join USERINFO on inserted.UID=USERINFO.UID)
begin
insert into PHOTO(PID,PNAME)
select UID,UNAME from i
www.eeworm.com/read/181172/9270557
sql ddl.sql
#--数据表td_guestbook
CREATE TABLE `td_guestbook` (
`id` BIGINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
`name` VARCHAR(30) NOT NULL,
`qq` VARCHAR(30) DEFAULT 'no' NOT NULL,
`email` VARCHAR(100