CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS B...

[Read the rest of this article...]

I had a need for getting a property details for a SSR report and came up with the following store procedure  . . . I thought it might be useful t...

[Read the rest of this article...]

Ventrian Property Agent

Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL

When running a named instance of MS SQL the instance will run on a port other than the usual port 1433. To determine the port you can use th...

[Read the rest of this article...]

  @rUser table (UserId int) 'Set UserID' into @rUser (UserId) values (9) Print '==================================' Print 'DELETE from aspn...

[Read the rest of this article...]

Within a stored procedure use an IF STATEMENT to check a parameter for a NULL VALUE if( @CustomFieldID is null) begin    print 'NUL...

[Read the rest of this article...]

Stored-Procedure, Null-Value