USE [PMS_UnifiedDB_15]
GO
/****** Object: StoredProcedure [dbo].[SP_GetLogInfo] Script Date: 2/11/2015 3:04:13 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Alter date: <Alter Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_GetLogInfo]
-- Add the parameters for the stored procedure here
@id bigint,
@userRoleInput nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
declare @query nvarchar(max);
set @query ='select * from dbo.COM_Function where function_label='''+@userRoleInput+'''';
print @query
exec sp_executeSql @query
END