USE [PMS_UnifiedDB_15]GO/****** Object:  StoredProcedure [dbo].[SP_GetLogInfo]    Script Date: 2/11/2015 3:04:13 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:		
     
      -- Alter date: 
      
       -- Description:	
       
        -- =============================================ALTER PROCEDURE [dbo].[SP_GetLogInfo]	-- Add the parameters for the stored procedure here	@id bigint,	@userRoleInput nvarchar(50)ASBEGIN	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