eshop.sql(復制的時候注意路徑!!!)

USE [master]
GO
/****** Object: Database [eshop] Script Date: 2019/11/25 星期一 上午 08:54:14 /
CREATE DATABASE [eshop] ON PRIMARY
( NAME = N’eshop_dat’, FILENAME = N’D:\eshop\eshop_dat.mdf’ , SIZE = 10240KB , MAXSIZE = 51200KB , FILEGROWTH = 5120KB )
LOG ON
( NAME = N’eshop_log’, FILENAME = N’D:\eshop\eshop_log.ldf’ , SIZE = 10240KB , MAXSIZE = 51200KB , FILEGROWTH = 5120KB )
GO
ALTER DATABASE [eshop] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))
begin
EXEC [eshop].[dbo].[sp_fulltext_database] @action = ‘enable’
end
GO
ALTER DATABASE [eshop] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [eshop] SET ANSI_NULLS OFF
GO
ALTER DATABASE [eshop] SET ANSI_PADDING OFF
GO
ALTER DATABASE [eshop] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [eshop] SET ARITHABORT OFF
GO
ALTER DATABASE [eshop] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [eshop] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [eshop] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [eshop] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [eshop] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [eshop] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [eshop] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [eshop] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [eshop] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [eshop] SET DISABLE_BROKER
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [eshop] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [eshop] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [eshop] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [eshop] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [eshop] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [eshop] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [eshop] SET RECOVERY FULL
GO
ALTER DATABASE [eshop] SET MULTI_USER
GO
ALTER DATABASE [eshop] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [eshop] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N’eshop’, N’ON’
GO
USE [eshop]
GO
/ Object: Table [dbo].[members] Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[members](
[m_account] varchar NOT NULL,
[m_name] varchar NOT NULL,
[m_sex] char NULL,
[m_birth] [datetime] NULL,
[m_address] varchar NULL,
[m_salary] [money] NULL,
[m_password] varchar NULL,
PRIMARY KEY CLUSTERED
(
[m_account] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[orders] Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[orders](
[o_no] char NOT NULL,
[m_account] varchar NOT NULL,
[p_no] char NOT NULL,
[o_quantity] [int] NULL,
[o_date] [datetime] NULL,
[o_confirm_state] char NULL,
[o_pay_state] char NULL,
[o_send_state] char NULL,
PRIMARY KEY CLUSTERED
(
[o_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[products] Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[products](
[p_no] char NOT NULL,
[p_name] varchar NOT NULL,
[p_date] [datetime] NULL,
[p_quantity] [int] NULL,
[p_price] [money] NULL,
[p_information] varchar NULL,
PRIMARY KEY CLUSTERED
(
[p_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’Jinjin’, N’津津有味’, N’女’, CAST(0x0000756500000000 AS DateTime), N’北京市’, 8200.0000, N’jinjin’)
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’Lfz’, N’劉法治’, N’男’, CAST(0x00006D5C00000000 AS DateTime), N’天津市’, 4500.0000, N’lfz0826’)
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’liuzc518’, N’劉志成’, N’男’, CAST(0x0000674300000000 AS DateTime), N’湖南株洲’, 3500.0000, N’liuzc518’)
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’Wangym’, N’王詠梅’, N’女’, CAST(0x00006A6D00000000 AS DateTime), N’湖南長沙’, 4000.0000, N’wangym0806’)
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’Zhangzl’, N’張自梁’, N’男’, CAST(0x00006B6E00000000 AS DateTime), N’湖南株洲’, 4300.0000, N’zhangzl’)
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N’zhao888’, N’趙愛云’, N’男’, CAST(0x000066E300000000 AS DateTime), N’湖南株洲’, 5500.0000, N’zhao888’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000001’, N’jinjin’, N’0910810004’, 2, CAST(0x0000966B00000000 AS DateTime), N’1’, N’0’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000002’, N’lfz’, N’0910810001’, 1, CAST(0x000096AB00000000 AS DateTime), N’0’, N’0’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000003’, N’jinjin’, N’0910810004’, 1, CAST(0x000096AB00000000 AS DateTime), N’1’, N’1’, N’1’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000004’, N’lfz’, N’0910810004’, 2, CAST(0x0000966B00000000 AS DateTime), N’1’, N’1’, N’1’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000005’, N’lfz’, N’0910810004’, 2, CAST(0x000096AB00000000 AS DateTime), N’1’, N’1’, N’1’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000006’, N’liuzc518’, N’0140810324’, 1, CAST(0x000096E800000000 AS DateTime), N’0’, N’0’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000007’, N’liuzc518’, N’0910810004’, 2, CAST(0x000096E800000000 AS DateTime), N’1’, N’1’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000008’, N’wangym’, N’0910810001’, 1, CAST(0x000096AB00000000 AS DateTime), N’1’, N’0’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000009’, N’zhao888’, N’0240810333’, 2, CAST(0x0000966B00000000 AS DateTime), N’1’, N’1’, N’0’)
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N’0000000010’, N’liuzc518’, N’0910810001’, 1, CAST(0x000096E800000000 AS DateTime), N’1’, N’1’, N’0’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0130810324’, N’清華同方電腦’, CAST(0x0000972700000000 AS DateTime), 7, 8000.0000, N’優惠多多’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0140810330’, N’洗衣粉’, CAST(0x0000966500000000 AS DateTime), 1000, 8.6000, N’特價銷售’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0140810332’, N’紅彤彤臘肉’, CAST(0x0000965A00000000 AS DateTime), 43, 15.0000, N’是一種衛生食品’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0140810333’, N’力士牌香皂’, CAST(0x0000964C00000000 AS DateTime), 22, 6.0000, N’是一種清潔用品’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0240810330’, N’電動自行車’, CAST(0x0000966500000000 AS DateTime), 10, 1586.0000, N’價廉物美’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0240810333’, N’自行車’, CAST(0x0000966500000000 AS DateTime), 10, 586.0000, N’價廉物美’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0910810001’, N’愛國者MP3’, CAST(0x0000966500000000 AS DateTime), 100, 450.0000, N’價廉物美’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0910810002’, N’商務通’, CAST(0x0000965A00000000 AS DateTime), 10, 850.0000, N’價廉物美’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0910810003’, N’名人好記星’, CAST(0x0000966500000000 AS DateTime), 100, 550.0000, N’價廉物美’)
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N’0910810004’, N’奧美嘉 U盤’, CAST(0x0000966500000000 AS DateTime), 100, 350.0000, N’價廉物美’)
USE [master]
GO
ALTER DATABASE [eshop] SET READ_WRITE
GO

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/379363.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/379363.shtml
英文地址，請注明出處：http://en.pswp.cn/news/379363.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

doublevalue_Java Double類doubleValue（）方法與示例

doublevalue_Java Double類doubleValue（）方法與示例

doublevalueDouble類doubleValue()方法 (Double class doubleValue() method) doubleValue() method is available in java.lang package. doubleValue()方法在java.lang包中可用。 doubleValue() method is used to return the value denoted by this Double object converted…
閱讀更多...
ffmpeg 命令過濾器裁剪

ffmpeg 命令過濾器裁剪

1 圖片操作： 原圖： 使用ffplay 顯示左半邊 ffplay -i input.png -vf cropiw/2:ih:0:0 可以通過ffmpeg 保存 ffmpeg -i input.png -vf cropiw/2:ih:0:0 out.png 2 視頻操作： 原視頻： 顯示左半邊 ffplay -i cctvhttp.flv -vf …
閱讀更多...
去除aspx生成的頁面最開始的空行

去除aspx生成的頁面最開始的空行

使用.aspx生成的頁面一般都會有一個或多個空行&#xff0c;當然這些空行不會影響頁面在瀏覽器中的渲染結果&#xff0c;不過在查看源代碼的時候感覺有些別扭&#xff0c;我曾試著去刪除這些空行&#xff0c;但沒有成功&#xff0c;你知道你們有沒有去嘗試。 1 <% Page Langu…
閱讀更多...
PUBLISH.sql(復制的時候注意路徑!!!)

PUBLISH.sql(復制的時候注意路徑!!!)

USE [master] – GO – /****** Object: Database [PUBLISH] Script Date: 2019/11/25 星期一 上午 09:00:04 / – CREATE DATABASE [PUBLISH] ON PRIMARY – ( NAME N’PUBLISH’, FILENAME N’F:\PUBLISH\PUBLISH.mdf’ , SIZE 51200KB , MAXSIZE UNLIMITED, FILEGROWTH …
閱讀更多...
c ++ 函數的esp指針_在C ++中通過指針訪問成員函數

c ++ 函數的esp指針_在C ++中通過指針訪問成員函數

c 函數的esp指針Create a class along with data member and member functions and then access the member functions by using a pointer in C. 創建一個類以及數據成員和成員函數&#xff0c;然后使用C 中的指針訪問成員函數。 如何通過指針訪問成員函數&#xff1f; (How…
閱讀更多...
[iphone-cocos2d]分享一段Objective-C可調用的游戲中播放音樂(1)

[iphone-cocos2d]分享一段Objective-C可調用的游戲中播放音樂(1)

首先需要引入AudioTool 這個framework 代碼 -(id)initWithPath:(NSString *)path{ UInt32 size, maxPacketSize; char*cookie; inti; if(gThereIsAnActiveTrack) { NSLog("*** WARNING *** GBMusicTrack only plays one track at a time…
閱讀更多...
匯編語言-010（循環移位ROL,ROR 、進位循環進位RCL,RCR 、有符號數溢出 、雙精度移位SHLD,SHRD、SHL和ADD計算 、位運算應用）

匯編語言-010（循環移位ROL,ROR 、進位循環進位RCL,RCR 、有符號數溢出 、雙精度移位SHLD,SHRD、SHL和ADD計算 、位運算應用）

1 &#xff1a;循環移位ROL,ROR,帶進位循環進位RCL,RCR .386 .model flat,stdcall.stack 4096 ExitProcess PROTO,dwExitCode:DWORD.code main PROC;循環左移mov al,40h ;AL 010000000brol al,1 ;AL 100000000b ,CF 0rol al,1 ;AL 000000001b ,CF 1rol al,1 ;A…
閱讀更多...
[Z]POJ 計算幾何入門題目推薦[轉PKKJ]

[Z]POJ 計算幾何入門題目推薦[轉PKKJ]

http://www.cnblogs.com/eric-blog/archive/2011/05/31/2064785.html http://hi.baidu.com/novosbirsk/blog/item/723a9727a9ab8804918f9dca.html其實也談不上推薦&#xff0c;只是自己做過的題目而已&#xff0c;甚至有的題目尚未AC&#xff0c;讓在掙扎中。之所以推薦計算幾何…
閱讀更多...
2013年 833c語言程序 江南大學 （A卷）

2013年 833c語言程序 江南大學 （A卷）

1.編寫程序實現求兩個整數最大公約數和最小公倍數. 方法一&#xff1a;輾轉相除法 算法思路&#xff1a;兩個整數a,b,其中a>b&#xff0c;求其最大公約數和最小公倍數 步驟① a%bc,其中c為余數 步驟② 若余數c為0&#xff0c;即a可以把b給整除,也就是說這里的b就是其最大公…
閱讀更多...
二十幾歲失敗的原因

二十幾歲失敗的原因

1.缺乏人生目標。在研究過的人們中&#xff0c;9.98%的人沒有"人生目標"&#xff0c;這恐怕是人們失敗的最大原因。　　2.自學能力不足。歷史上所謂掌握最高教育的人&#xff0c;幾乎都是"自學型"的。所謂"有教育"的人&#xff0c;不能只看成是有…
閱讀更多...
C程序生成一定范圍內的隨機數

C程序生成一定范圍內的隨機數

Random numbers just numbers that lie within a range and any of the numbers can occur. 隨機數只是在一個范圍內的數字&#xff0c;任何數字都可能出現。 In programming, we come through a lot of scenarios where we need to generate random numbers. Like for dice g…
閱讀更多...
提示丟失libgcc_s_dw2-1.dll問題

提示丟失libgcc_s_dw2-1.dll問題

QT使用MinGW編譯器編譯中的的執行文件&#xff0c;執行問題 將qt中安裝的mingw編碼器的路徑添加到環境變量path (D:\Qt\Qt5.10.1\5.10.1\mingw53_32\bin)
閱讀更多...
第1章 數據庫系統概述

第1章 數據庫系統概述

第1章 數據庫系統概述 1.1 數據庫系統簡介 數據庫技術的發展歷史 人工管理階段文件系統階段數據庫系統階段
閱讀更多...
淺談多線程和異步

淺談多線程和異步

最近很忙&#xff0c;因此拿出時間來寫博客也算是忙里偷閑了&#xff0c;繼承前面的一貫風格&#xff0c;繼續淺談胡侃。　　最近在項目中遇到了Socket異步網絡傳輸的問題&#xff0c;所以沉下心來整理下。于是&#xff0c;先問了下度娘&#xff0c;結果找到了園友志良的一篇文…
閱讀更多...
查看Sql Server的log文件大小

查看Sql Server的log文件大小

SELECT DB_NAME(database_id) AS DatabaseName,Name AS Logical_Name,Physical_Name, (size*8)/1024 SizeMBFROM sys.master_filesWHERE DB_NAME(database_id) AdventureWorksGO 轉載于:https://www.cnblogs.com/top5/archive/2010/03/02/1676776.html
閱讀更多...
python調用帶參函數_Python | 帶有示例的函數調用類型

python調用帶參函數_Python | 帶有示例的函數調用類型

python調用帶參函數There are following types of function calls in python: python中有以下類型的函數調用&#xff1a; Call by value 按價值致電 Call by reference 通過參考電話 1)按價值致電 (1) Call by value ) When, we call a function with the values i.e. pass …
閱讀更多...
ffmpeg 命令添加文字水印

ffmpeg 命令添加文字水印

使用ffplay 預覽一下效果&#xff1a; ffplay -i cctvhttp.flv -vf “drawtextfontsize100:fontfileArial.ttf:tex t‘hello world’:x20:y20:fontcolorblue:alpha0.5” -x 640 -y 480 使用ffmpeg保存為文件 &#xff1a; ffmpeg -i cctvhttp.flv -vf “drawtextfontsize10…
閱讀更多...
jquery彈出層

jquery彈出層

這是一個彈出層的插件&#xff0c;有時候做東西的&#xff0c;經常會用到了&#xff0c;所以在次發一下&#xff0c;和大家分享一下&#xff01; [task]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/x…
閱讀更多...
MUL與IMUL區別（微機原理與接口技術 第2版）課后習題3.14、P123

MUL與IMUL區別（微機原理與接口技術 第2版）課后習題3.14、P123

MUL與IMUL的詳細區別 乘數位數隱含的被乘數乘積的存放位置舉例8位ALAX中MUL BL16位AXDX與AX中&#xff08;DX存放高16位、AX存放低16位&#xff09;MUL BX 課本P97例題 一&#xff09;、將以下指令中的立即數看作是無符號數實現相乘: MOV AL,0B4H ;ALB4H180 解釋以下&…
閱讀更多...
SDL_main導致main找不到入口

SDL_main導致main找不到入口

SDL main的錯誤 引用SDL.h就會報這個錯誤 因為SDL 將main 宏定義為 SDL_main,所以會找不到main入口 可以使用#undef main取消這個宏定義
閱讀更多...
最新文章

Copyright @ 2022~2023