Stored Procedures

Snippets


Stored Procedures

 

NO Image:
01
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...]

15
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
16
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL
17
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...]

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

[Read the rest of this article...]

21
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
Posted in: Stored Procedures