?? proc_insertstorage.sql
字號(hào):
use db_SMS
go
if object_Id('proc_insertStorage') is not null
drop proc proc_insertStorage
go
create proc proc_insertStorage
(
@StoreName varchar (100),
@StorePeople varchar (20),
@StorePhone varchar (20),
@StoreUnit varchar (100),
@StoreRemark varchar (1000)
)
as
if exists(select * from tb_Storage where StoreName=@StoreName)
begin
return 100
end
else
begin
insert into tb_Storage(StoreName,StorePeople,StorePhone,StoreUnit,StoreRemark)
values(@StoreName,@StorePeople,@StorePhone,@StoreUnit,@StoreRemark)
end
go
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -