Set ansi_nulls on
Set quoted_identifier on
Go
-- ===================================================== ======
-- Author: <author, Name>
-- Create Date: <create date,>
-- Description: <description,>
-- ===================================================== ======
Alter procedure [DBO]. [sp_ifexistinfo]
-- Add the parameters for the stored procedure here
@ Websitelistid int,
@ Tablename varchar (50 ),
@ Fieldname varchar (50 ),
@ Inputinfo varchar (100)
As
Begin
-- Set nocount on added to prevent extra result sets from
-- Interfering with select statements.
-- Set nocount on;
Declare @ sqlstmt nvarchar (4000)
Declare @ returnid varchar (50)
-- Insert statements for procedure here
Set @ sqlstmt = 'select @ returnid = count (1) from ['+ @ tablename +'] Where '+ @ fieldname +' = ''' + @ inputinfo + ''' and websitelistid = '+ Cast (@ websitelistid as varchar)
Exec sp_executesql @ sqlstmt, n' @ returnid int output', @ returnid output
If @ returnid> 0
Return '1'
Else
Return '0'
End