delete from person where no='000007'
DBstar+SQL 源代码
汇集 DBstar+SQL 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
alter table person add constraint check_sex check(sex in('男','女'))
alter table person add nation char(12) default'中国'
select * from person where sex='男'
insert into dept values('00106','培训部')
CREATE TABLE [dbo].[读者信息] ( [条形码] [varchar] (40) NULL , [编号] [varchar] (20) NOT NULL , [姓名] [varchar] (20) NULL , [性别] [va…
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_工资发放历史表_职员基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey'…
exec sp_addlogin 'lsm9','123456' exec sp_addlogin 'lsm8','123456' exec sp_grantdbaccess 'lsm9' exec sp_grantdbaccess 'lsm8' …
Set Term ^; /*月结帐过程修改=================================================================== 上期余额及收款日期等应重置 2004-05-16 */ Alte…