CREATE PROCEDURE pro_addfile
( @filetitle varchar(10),
@filecontent varchar(10),
@fromusername varchar(10),
@tousername varchar(10),
@filestatusname varchar(10)
)
AS
/* SET NOCOUNT ON */
insert into file(filetitle,filecontent,fromusername,tousername,filestatus)
valus(@filetitle,@filecontent,@fromusername,@tousername,@filestatusname)
RETURN
提示错误信息(关键字‘file’附近有语法错误)!!!大家帮忙看看
( @filetitle varchar(10),
@filecontent varchar(10),
@fromusername varchar(10),
@tousername varchar(10),
@filestatusname varchar(10)
)
AS
/* SET NOCOUNT ON */
insert into file(filetitle,filecontent,fromusername,tousername,filestatus)
valus(@filetitle,@filecontent,@fromusername,@tousername,@filestatusname)
RETURN
提示错误信息(关键字‘file’附近有语法错误)!!!大家帮忙看看
( @filetitle varchar(10),
@filecontent varchar(10),
@fromusername varchar(10),
@tousername varchar(10),
@filestatusname varchar(10)
)
AS
--file是系统的保留字或关键字,你要加[]
insert into [file](filetitle,filecontent,fromusername,tousername,filestatus)
valus(@filetitle,@filecontent,@fromusername,@tousername,@filestatusname)
RETURN
A. 重命名表
下例将表 customers 重命名为 custs。EXEC sp_rename 'customers', 'custs'