Posted by Erland Sommarskog on 06/25/05 01:17

Sam (samuel.berthelot@voila.fr) writes:
> Hi,
> I've got the following Stored Procedure
>
> CREATE PROCEDURE pr_Admin_GetCtrlFields
> --Get the control fields, detail or flow according to the ModeID
> parameter
> @QueryID int,
> @ModeID int
> AS
>
> SELECT FieldID, FieldName, EntryInfo, ControlTypeID,ViewFieldTypeID,
> ViewTable, ViewField,
> F.SortOrder, InsertField, UpdateField, FieldTabId, ModeId
> FROM Fields F, Queries
>
> WHERE F.QueryID = @QueryID
> AND ControlTypeID <> NULL

Beware! This is most certainly not what you want. This condition
will never evaulate to TRUE. Use IS NOT NULL instead.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]