摘要：select sno,avg(score) from scgroup by sno having avg(score)>60 阅读全文

摘要：SELECT top 1 * FROM [GpsNew].[dbo].[InstrumentType] where InstrumentID not in(select top 10 InstrumentID from InstrumentType) 阅读全文

摘要：SELECT [SN] ,[MotherBoardSN2] FROM [GpsNew].[dbo].[MotherBoardInfo]where [MotherBoardSN2] in ('594299','580530','580245') 阅读全文

摘要：createTRIGGER [dbo].[OnInsert] ON [dbo].[Lock] after insertASbegindeclare @i int set @i=0 select @i=count(*) from [dbo].[Lock],inserted where Lock.SN=inserted.SN and Lock.IsLock='T' if(@i<>0) begin ROLLBACK TRANSACTION endend上述触发器的目的是在表Lock中插入一条数据时检测表中是否有和插入数据的SN号相同且IsLock为T的记录，如果有就回滚插 阅读全文

摘要：1 set ANSI_NULLS ON 2 set QUOTED_IDENTIFIER ON 3 go 4 5 6 -- ============================================= 7 -- Author: <兰保明> 8 -- Create date: <20110316> 9 -- Description: <根据机身号和用户发来的功能号信息得到功能号>10 -- =============================================11 ALTER FUNCTION [dbo].[get]12 (13 阅读全文

摘要：use mydbcreate table student(no int not null primary key,name char(10) not null,cj int,xueyuan char(30),major char(30),age int,jg char(20)) 阅读全文

摘要：create database Appdataon primary(name=Appdata,filename='F;\appdata.mdf',size=10mb,maxsize=100mb,filegrowth=10mb)Log on (name=Appdata,filename='F;\appdata.ldf',size=10mb,maxsize=100mb,filegrowth=10mb) 阅读全文