Hari
3/30/2007 2:48:00 AM
Hello,
You can not refer a table name or alias name inside IF statement with out a
FROM clause.
Thanks
Hari
"Rhea" <Rhea@discussions.microsoft.com> wrote in message
news:84C5F0E2-AF19-4F29-A512-AF03719E4E27@microsoft.com...
>I have this line in a trigger I am trying to create:
>
> If (product.Gr_Bf_Each.value = 0) or (product.Gr_Bf_Each.IsNull)
> begin
>
> I get this error when I try to execute:
>
> An expression of non-boolean type specified in a context where a condition
> is expected, near 'begin'.
>
> What is the problem? I am new to SQL server. Thanks.