代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/339165/12254092
txt sql.txt
SQL操作全集
下列语句部分是Mssql语句,不可以在access中使用。
SQL分类:
DDL—数据定义语言(CREATE,ALTER,DROP,DECLARE)
DML—数据操纵语言(SELECT,DELETE,UPDATE,INSERT)
DCL—数据控制语言(GRANT,REVOKE,COMMIT,ROLLBACK)
首先,简要介绍基础语句:
1、说
www.eeworm.com/read/252934/12254198
sql test.sql
INSERT CourseTable(CourseID,CourseName,Remark) VALUES('C001','ASP.NET网站开发','Asp.net网站开发')
INSERT CourseTable(CourseID,CourseName,Remark) VALUES('C002','C#.net程序设计','C#.net程序设计 你精通了吗')
INSERT CourseT
www.eeworm.com/read/252934/12254200
sql creat.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SCORETAB_REFERENCE_COURSETA]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[ScoreTable] DROP CONSTRAINT FK_
www.eeworm.com/read/150810/12260051
sql trade.sql
www.eeworm.com/read/150691/12276174
sql 存储过程.sql
---TB050272 王继州 综合设计储存过程、触发器
use supermarket
------------===========自定义视图===========---------------
--查询供货商对应自己的供货商品视图
go
create view wjz_progood
as
select tord.providerid ,t.
www.eeworm.com/read/150686/12276821
sql hcgl.sql
www.eeworm.com/read/150686/12276914
sql ypgl.sql
www.eeworm.com/read/150589/12284101
sql upgrade.sql
-- Run this, or portions of this, to upgrade from one
-- version to another.
-- upgrade from 2.0.6 to 2.0.7
alter table bug_attachments add ba_comment int null
/*
The SQL below might be somet
www.eeworm.com/read/150589/12284310
sql setup.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[bug_attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [bug_attachments]
if exists (select * from dbo.sysobjects