sql学生信息管理系统源码

来源:百度知道 编辑:UC知道 时间:2024/06/18 04:19:20
sql学生信息管理系统源码 要英文的那些在 查询分析器里打出来的那些 谢谢
麻烦各位请+qq 1035604821 教我下 谢谢
一定要VB+SQL的,SQL有4,5个表就得了,不用太多表。同时发SQL的表的备份DAT来。
各位帮帮忙啊!星期三要交了。

use master
go

if exists (select * from dbo.sysdatabases where name = 'Student')
drop database Student
GO

create database Student
go
use Student
go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[student_Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[result_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[result_Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gradecourse_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[gradeco