Code/Resource
Windows Develop
Linux-Unix program
Internet-Socket-Network
Web Server
Browser Client
Ftp Server
Ftp Client
Browser Plugins
Proxy Server
Email Server
Email Client
WEB Mail
Firewall-Security
Telnet Server
Telnet Client
ICQ-IM-Chat
Search Engine
Sniffer Package capture
Remote Control
xml-soap-webservice
P2P
WEB(ASP,PHP,...)
TCP/IP Stack
SNMP
Grid Computing
SilverLight
DNS
Cluster Service
Network Security
Communication-Mobile
Game Program
Editor
Multimedia program
Graph program
Compiler program
Compress-Decompress algrithms
Crypt_Decrypt algrithms
Mathimatics-Numerical algorithms
MultiLanguage
Disk/Storage
Java Develop
assembly language
Applications
Other systems
Database system
Embeded-SCM Develop
FlashMX/Flex
source in ebook
Delphi VCL
OS Develop
MiddleWare
MPI
MacOS develop
LabView
ELanguage
Software/Tools
E-Books
Artical/Document
Super market数据库文件.sql
Package: Super+market_Csharp.rar [view]
Upload User: nbcygd
Upload Date: 2008-07-25
Package Size: 2566k
Code Size: 2k
Category:
SQL Server
Development Platform:
C#
- use master
- go
- if exists(select * from sysdatabases where name='wkdl')
- begin
- drop database wkdl
- create database wkdl
- on primary
- (
- name='wkdl_data',
- filename='D:wkdl.mdf',
- size=3,
- filegrowth=15%
- )
- log on
- (
- name='wkdl_log',
- filename='D:wkdl.ldf',
- size=3,
- filegrowth=15%
- )
- end
- else
- begin
- create database wkdl
- on primary
- (
- name='wkdl_data',
- filename='D:wkdl.mdf',
- size=3,
- filegrowth=15%
- )
- log on
- (
- name='MyQQ_log',
- filename='D:wkdl.ldf',
- size=3,
- filegrowth=15%
- )
- end
- go
- use wkdl
- go
- create table userlogin
- (
- uid int identity(1,1),
- uName varchar(50) not null,
- uPassword varchar(50) not null,
- usa varchar(50) not null
- )
- go
- alter table userlogin
- add constraint pk_id primary key (uName)
- go
- create table ware
- (
- [Id] int identity(1,1),
- wareName varchar(20) not null,
- price decimal(18,2) not null,
- entries int not null,
- [keep] int not null
- )
- go
- alter table ware
- add constraint qk_id primary key (wareName)
- go
- --添加数据
- insert into userlogin (uName,uPassword,usa) values('wdxg','ayjl','管理员')
- insert into userlogin (uName,uPassword,usa) values('sa','.','管理员')
- insert into userlogin (uName,uPassword,usa) values('test','test','员工')
- insert into userlogin (uName,uPassword,usa) values('super','super','员工')
- go
- insert into ware (wareName,price,entries,[keep]) values('火龙果',1.22,120,12)
- insert into ware (wareName,price,entries,[keep]) values('黄瓜',2.22,22,1)
- insert into ware (wareName,price,entries,[keep]) values('土豆',3.33,0,2)
- insert into ware (wareName,price,entries,[keep]) values('番茄',4.44,2,3)
- insert into ware (wareName,price,entries,[keep]) values('西瓜',5.55,14,4)
- insert into ware (wareName,price,entries,[keep]) values('胡萝卜',6.66,52,5)
- insert into ware (wareName,price,entries,[keep]) values('苦瓜',7.77,9,6)
- insert into ware (wareName,price,entries,[keep]) values('葡萄',8.88,0,8)
- go