Line Feeds in VB.NET

 

http://weblogs.asp.net/ahoffman/archive/2003/04/27/6089.aspx

 

 

TSQL SQL UPDATE FROM

 

http://codesnippets.joyent.com/posts/show/277

 

 

Substring() Method VB .NET

 

http://www.homeandlearn.co.uk/net/nets7p5.html

 

 

 

C# VB.NET SqlCommand ExecuteScalar

 

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx

 

 

VB.NET string processing

 

http://www.lqnet.com/VB/VBNet_String.aspx

 

 

TSQL SET CONCAT_NULL_YIELDS_NULL - string concatenation with null

 

If you set SET CONCAT_NULL_YIELDS_NULL to OFF, when you concatenate a string with null, the end result is still the string you put in.

 

If you set SET CONCAT_NULL_YIELDS_NULL to ON, then when you concatenate a string with null, the end result is NULL.

 

 

http://msdn.microsoft.com/en-us/library/ms176056.aspx

 

http://doc.ddart.net/mssql/sql70/operator_2.htm

 

 

Why Debug command is disabled for my SSIS package?

 

If you have a dtsx SSIS package and wonder why you cannot run / debug the package inside Visual Studio, chances are you need a project associated with it.

 

 

http://blogs.msdn.com/michen/archive/2007/03/15/ssis-debug-disabled.aspx

DATEPART Transact-SQL tsql

 

 

If you want to know the day of the week from a given date, or a host of other handy date functions. Check this out.

 

 

http://msdn.microsoft.com/en-us/library/ms174420.aspx

 

 

Understanding and Using .NET Partial Classes

 

http://www.devx.com/dotnet/Article/22603