CREATE PROCEDURE [dbo].[GET_ALL_SYSROLE] AS --IF EXISTS (SELECT * FROM TL_USER A WHERE TLNANME= @TLNANME AND RoleName = 'TGD') BEGIN Select * from [TL_SYSROLE] END