T-SQL

 

Die Abfragesprache des Microsoft SQL-Servers.

 

 

Definition

 

CREATE FUNCTION udf_OrderCanEdit

(@OrderID varchar(20))

RETURNS bit

AS 

BEGIN

                declare @RECCNT int

                declare @CanEdit bit

 

               

                SELECT @RECCNT = COUNT(*) FROM tArticlesOrdered

                WHERE OrderID=@OrderID and ArtOrdStatusID=2

               

                if (@RECCNT > 0)

                               set @CanEdit = 0

                else

                               set @CanEdit = 1

 

                return @CanEdit

END

 

 

Aufruf im SQL Profiler: 

select dbo.udf_OrderCanEdit('059815915875') as CanEdit