CREATE PROCEDURE LG_see
@BlogName nvarchar(50)
AS
select top 13
select * from A where A.a like '%@BlogName%'
GO
应该怎样改?
'%@BlogName%'好像不是这样写
@BlogName nvarchar(50)
AS
select top 13
select * from A where A.a like '%@BlogName%'
GO
应该怎样改?
'%@BlogName%'好像不是这样写
select top 13 * from A where A.a like '%@BlogName%'
SQL有语法问题没有啊
@BlogName nvarchar(50)
AS select * from A where A.a like '%'+@BlogName+'%'
@BlogName nvarchar(50)
AS
select top 13 * from
(select * from A where A.a like '%'+@BlogName+'%') t
GO
@BlogName nvarchar(50)
AS select * from A where A.a like '''%'+@BlogName+'%'''
@BlogName nvarchar(50)
AS exec( 'select * from A where A.a like ''%'+@BlogName+'%''')
CREATE PROCEDURE LG_see @BlogName nvarchar(50)
AS
set @BlogName = '%' + @BlogName + '%'
select top 13 select * from A where A.a like @BlogName
GO CREATE PROCEDURE LG_see @BlogName nvarchar(50)
AS
exec('select top 13 select * from A where A.a like ''' + @BlogName + '''')
GO
@BlogName nvarchar(50)
AS
select top 13 * from A where A.a like '%'+@BlogName+'%'
GO
@BlogName nvarchar(50)
AS
select top 13
select * from A where A.a like '%'+@BlogName+'%'
GO
@BlogName nvarchar(50)
AS
select top 13
select * from A where A.a like '%'+@BlogName+'%'
GO