?? cardfile.sql
字號:
CREATE DATABASE CardFile
Go
USE CardFile
CREATE TABLE [CardFile].[dbo].[ACCOUNT] (
[AccountID] [varchar] (32) NOT NULL ,
[Name] [varchar] (50),
[Address] [text],
[Phone1] [varchar] (20),
[Phone2] [varchar] (20),
[Email] [varchar] (128),
[Note] [text]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [CardFile].[dbo].[CONTACT] (
[AccountID] [varchar] (50) NOT NULL ,
[Name] [varchar] (50) NOT NULL ,
[Title] [varchar] (50),
[Phone] [varchar] (20),
[Extn] [varchar] (10),
[Email] [varchar] (128),
[Note] [text],
[PhotoID] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROC get_Contacts (@AccntID varchar(32) ) AS
SELECT * FROM Contact WHERE Contact.AccountID = @AccntID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -