代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/181694/9240645
sql createwebshoppedb.sql
/* Install WebShoppe database */
set nocount on
USE master
declare @dttm varchar(55)
select @dttm=convert(varchar,getdate(),113)
raiserror('Starting installation of WebSh
www.eeworm.com/read/181540/9246779
sql dbcarsys.sql
/*-----------------------------------------------------------*/
/* 创建数据库 */
/*-----------------------------------------------------------*/
use master
go
if exists(select * from sysdatab
www.eeworm.com/read/181485/9248277
sql library.sql
www.eeworm.com/read/181464/9254511
sql new.sql
exec sp_addlogin 'SGteacher','123456','StuGrade'
exec sp_addlogin 'SGstudent','123','StuGrade'
use StuGrade
go
exec sp_grantdbaccess N'SGteacher'
exec sp_grantdbaccess N'SGstudent'
exec sp_addro
www.eeworm.com/read/377958/9255403
sql 聚合函数.sql
use northwind
go
select top 5 with ties orderid,productid,quantity from [order details]
order by quantity desc
go
select sum(quantity) from [order details]
go
select * from [order details
www.eeworm.com/read/377958/9255411
sql 子查询.sql
use northwind
go
select * from orders
go
select T.orderid,T.customerid
from(select orderid,customerid
from orders) as T
go
select orderid,customerid from orders
go
select * f
www.eeworm.com/read/377958/9255413
sql sales.sql
www.eeworm.com/read/377958/9255415
sql function.sql
use northwind
go
create function fn_newregion
(@myinput nvarchar(30))
returns nvarchar(30)
begin
if @myinput is null
set @myinput = 'Not Applicable'
return @myinput
end
go
selec
www.eeworm.com/read/377958/9255418
sql 多表联接.sql
select * from suppliers
select * from products
select a.supplierid,companyname,sum(unitprice )
from suppliers as a
inner join products as b
on a.supplierid=b.supplierid
select * from orders
www.eeworm.com/read/377958/9255432
sql 表变量.sql
use sales
go
alter database sales
set recovery simple
go
exec sp_help
go
dbcc useroptions
go
create table #cust
(
cust_name varchar(8) ,
cust_age varchar(2)
)
go
declare @