?? 倉(cāng)庫(kù)主文件_proc.sql
字號(hào):
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='倉(cāng)庫(kù)主文件_PROC' AND TYPE='P')
DROP PROC 倉(cāng)庫(kù)主文件_PROC
GO
create procedure 倉(cāng)庫(kù)主文件_PROC
as
CREATE TABLE [#倉(cāng)庫(kù)主文件] (
[倉(cāng)庫(kù)編碼] [varchar] (10),
[倉(cāng)庫(kù)描述] [varchar] (20),
[地址] [varchar] (100),
[聯(lián)系人] [varchar] (10),
[電話] [varchar] (15),
[傳真] [varchar] (15))
insert into #倉(cāng)庫(kù)主文件 select * from 倉(cāng)庫(kù)主文件
SELECT* FROM #倉(cāng)庫(kù)主文件
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -