[dbo].[Forum_FilterWordGetAll]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_FilterWordGetAll

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@PortalId	int	4
@Filter	nvarchar	1

SQL Script

create procedure dbo.Forum_FilterWordGetAll
@PortalId int,
@Filter nvarchar(1)
as

select * from Forum_FilterWords
where (PortalId = @PortalId) and (BadWord like @Filter + '%' )
order by BadWord

GO

Uses

[dbo].[Forum_FilterWords]
dbo