Knowledge Base

Snippets

30
Add the helper SPLIT function to your database CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) )  RETURNS @RtnVal...

[Read the rest of this article...]

SQL, FUNCTION
23
Solution was to configure the NTLM security. From Windows 7, click start, type local and open the Local Security Policy Manager. Sele...

[Read the rest of this article...]

Networking, Windows 7 Professional
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
19
Get the date and time in C#   vDate = Convert.ToString(System.DateTime.Today.Date.ToShortDateString()); vTime = Convert.ToString(System.DateTi...

[Read the rest of this article...]

Date, Time
Posted in: C Sharp - C#
17
Here you can find the list with the standard set of fonts common to all versions of Windows and their Mac substitutes, referred sometimes as "browser ...

[Read the rest of this article...]

Posted in: Web Design
12
  PROCEDURE GIBS_SEO_Content nvarchar(50) = null   AS BEGIN if (len(@city)=0) begin set @city=null end   SET NOCOUNT ...

[Read the rest of this article...]

Page 47 of 49First   Previous   40  41  42  43  44  45  46  [47]  48  49  Next   Last