SQL+CE 源代码

select * from student where not exists ( select * from sc where sno=student.sno and cno='1'and sclass=student.sclass )

use student_class select distinct student.* from student ,course,sc where student.sclass=sc.sclass and student.sno=sc.sno and…

use student_class select student.* from student ,sc where student.sclass=sc.sclass and student.sno=sc.sno and cno='2' and grad…

-- phpMyAdmin SQL Dump -- version 2.6.4-pl4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 20, 2006 a…

-- -- Add language preferences -- ALTER TABLE `user` ADD `language` VARCHAR( 4 ) DEFAULT 'FR' NOT NULL AFTER `password` ; -- -…

-- -- Firstname and lastname inversion -- ALTER TABLE `person` CHANGE `firstname` `lastname` VARCHAR( 45 ) CHARACTER SET latin1…

ALTER TABLE `person` ADD FULLTEXT `search` ( `lastname` , `firstname` , `note` ); ALTER TABLE `contact` ADD FULLTEXT `search` (…

-- -- Alter on table address -- ALTER TABLE `address` ADD `street_next` VARCHAR( 100 ) NOT NULL AFTER `street` ;

CREATE TRIGGER [CheckXS] ON [dbo].[XS] FOR DELETE AS delete from XS_KC where XH in(select XH from deleted)

--表'groupuser'的结构 if exists (select * from sysobjects where id = OBJECT_ID('groupuser') and OBJECTPROPERTY(id, 'IsUserTable') =…