SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_Name_GetDocuments]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_Name_GetDocuments]
(
@Title varchar(50)
)
AS
SELECT
Document.*,Staff.RealName
FROM
Document ,Staff
WHERE
Staff.Staff_ID = Document.UserID and Document.Title like [email protected]+'%'
'
END
这样写怎么一直提示'%' 附近有语法错误。。。菜鸟求教大神啊。。。
------解决方案--------------------
- SQL code
exec('SELECT Document.*,Staff.RealNameFROM Document ,StaffWHERE Staff.Staff_ID = Document.UserID and charindex([email protected]+'Document.Title)>0') 改成这样
------解决方案--------------------
Staff.Staff_ID = Document.UserID and Document.Title like [email protected]+''%''
------解决方案--------------------