代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/320192/13431222
sql queries.sql
1.
Answer:
Select libid, fname, join_date
From member4
where (libid like 'A&%B%' escape '&' or libid like 'A&B%')
and join_date < to_date('1997/11/30', 'YYYY/MM/DD');
2.
Answer:
Selec
www.eeworm.com/read/320190/13431226
sql createdb.sql
CREATE TABLE PUBLISHER(
PublisherID INTEGER,
Name VARCHAR(30),
Address VARCHAR(40),
CONSTRAINT
PK_PUBLISHER PRIMARY KEY(PublisherID),
UNIQUE(name)
www.eeworm.com/read/319971/13438071
sql checkin.sql
USE HR1
GO
CREATE TABLE Checkin
(CheckDate char(10) NOT NULL,
Emp_Id int NOT NULL,
qqDays decimal(4,1),
ccDays decimal(4,1),
bjDays decimal(4,1),
sjDays decimal(4,1),
www.eeworm.com/read/319971/13438075
sql mystupor(部分).sql
USE HR1
GO
CREATE TABLE Evaluation
(EvaMonth char(10) NOT NULL,
Emp_Id int NOT NULL,
ztEva varchar(200),
jlReason varchar(200),
jlAmount smallint,
cfReason varchar(200),
www.eeworm.com/read/319971/13438076
sql check.sql
use master
GO
if exists (select * from dbo.sysdatabases where name = 'HrSys')
drop database HrSys
GO
create database HrSys
GO
use HrSys
GO
if exists (select * from dbo.sysobjects whe
www.eeworm.com/read/319292/13456301
sql easyobjectsquickstarts.sql
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID('daab_GetCategories') AND sysstat & 0xf = 4)
DROP PROCEDURE [daab_GetCategories];
GO
CREATE PROCEDURE [daab_GetCategories]
(
@Cat
www.eeworm.com/read/318673/13473996
sql datediff.sql
CREATE OR REPLACE FUNCTION datediff
(form varchar2,date1 date,date2 date)
return number
as
t_Form VARCHAR2(10);
begin
t_Form :=LOWER(RTRIM(LTRIM(form)));
if t_Form='year'
then
www.eeworm.com/read/318620/13474540
sql setupdatabase.sql
www.eeworm.com/read/318594/13475356
sql test.sql
-- 运用此程序集实现的不同 SQL 对象的查询示例
-----------------------------------------------------------------------------------------
-- 存储过程
---------------------------------------------------------------------
www.eeworm.com/read/318508/13476876