• Login

Snippets

Entries for April 2010

30
Configure Outlook to use port 587 for sending email In order to change your port 25 settings to port 587 in Outlook, you must do the following: ...

[Read the rest of this article...]

Posted in: E-Mail
30
Add the helper SPLIT function to your database CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) )  RETURNS @RtnValue ...

[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. Select L...

[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 'NULL V...

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

[Read the rest of this article...]

Date, Time
Posted in: C Sharp - C#