新建一個數據庫存儲過程為什么總是報錯……USE User;GOIF OBJECT_ID('uspGetAllEmployees','P')IS NOT NULL DROP PROCEDURE uspGetAllEmployees; GO CREATE PROCEDURE uspGetAllEmployees AS SELECT UserId,UserName FROM User1; GO 手動添加的代碼,數據庫名User報錯……SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GOCREATE PROCEDURE1<Procedure_Name, sysname, ProcedureName> <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0> AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here SELECT <@Param1, sysname, @p1>,2<@Param2, sysname, @p2> END GO這是新建存儲過程時自動生成的,那位高手能解釋一下啊……不甚感激…… 自動添加的代碼1,2處報錯……
新建的存儲過程總是報錯
楊__羊羊
2018-11-28 18:08:51