代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/210370/15200297
sql 学号.sql
--创建自定义函数,得到新的ID
create function f_getid(
@YXDM varchar(3),
@zydm varchar(4)
)
returns int
as
begin
declare @re int
select @re=right(id,4) from(
select id=max(id) from tb where yx
www.eeworm.com/read/206376/15296116
sql 连接.sql
select * from employee right outer join jobs
on employee.job_id=jobs.job_id
www.eeworm.com/read/183001/5258729
in sql.in
SET search_path = public;
BEGIN;
HASINIT create function dinit_CFG_MODNAME(internal)
HASINIT returns internal
HASINIT as 'MODULE_PATHNAME'
HASINIT language 'C';
NOSNOWBALL cr
www.eeworm.com/read/290357/3977498
sql 学号.sql
--创建自定义函数,得到新的ID
create function f_getid(
@YXDM varchar(3),
@zydm varchar(4)
)
returns int
as
begin
declare @re int
select @re=right(id,4) from(
select id=max(id) from tb where yx
www.eeworm.com/read/415827/2132066
sql if语句.sql
DECLARE @myavg float
SELECT @myavg=AVG(writtenExam) from stuMarks
print '本班平均分'+convert(varchar(5),@myavg)
IF (@myavg>70)
BEGIN
print '本班笔试成绩优秀，前三名的成绩为'
SELECT TOP 3 * FROM stuMarks O
www.eeworm.com/read/415827/2132067
sql 变量.sql
/*--查找李文才的信息--*/
DECLARE @name varchar(8)
SET @name='李文才' --使用SET赋值
SELECT * FROM stuInfo where stuName = @name
/*--查找李文才的左右同桌--*/
DECLARE @seat int
SELECT @seat=stuSeat from stuInfo wher
www.eeworm.com/read/396547/2414307
sql a.sql
drop table Article_USER cascade constraints;
drop table Article_ADMIN cascade constraints;
drop table ARTICLE_MANAGER cascade constraints;
select * from ARTICLE_MANAGER;
select * from Artic
www.eeworm.com/read/379170/2676516
sql 权限.sql
insert into Role_Right values(1,2)
insert into Role_Right values(2,2)
insert into Role_Right values(3,2)
insert into Role_Right values(4,2)
insert into Role_Right values(5,2)
insert into Role
www.eeworm.com/read/375680/2722721
sql delstudent .sql
create TRIGGER DelStudent ON class
FOR DELETE
AS
IF @@RowCount = 0 Return
Declare @ID int
Select @ID=class_id From Deleted
de
www.eeworm.com/read/472564/6870541
sql delstudent .sql
create TRIGGER DelStudent ON class
FOR DELETE
AS
IF @@RowCount = 0 Return
Declare @ID int
Select @ID=class_id From Deleted
de