Stored Procedures

Finding the Port of MS SQL Named Instance

DNN Expert posted on March 17, 2011 06:12

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...

Actions: E-mail | Permalink | Comments (0)

DNN Expert posted on October 27, 2010 14:32

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

Actions: E-mail | Permalink | Comments (0)

DNN Expert posted on April 21, 2010 04:54

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

Posted in: Stored Procedures

Actions: E-mail | Permalink | Comments (0)

P.O. BOX 2342 ~ BREWSTER, MA 02631
PHONE & FAX: (508) 714-0678