Maximum characters of varchar max in sql server

Maximum 2^31-1 byte (2GB).

[2,147,483,647] Character

1 character = 1 byte

Variable-length, non-Unicode string data. n defines the string length and can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is the value of the actual data entered + 2 bytes. The ISO synonyms for varchar are char varying or character varying.

Ref:

http://msdn.microsoft.com/en-us/library/ms176089(v=sql.105).aspx

Remove Scrollbar from Textarea in IE

By default all versions of IE have a scrollbar on textareas, even when they are empty.

No other browsers do this, so if you want to remove it so IE can visually match other browsers, just:

textarea { overflow: auto; }

The scrollbar will return (rightfully) when the text in the textarea expands beyond it's bounds.

soruce:
http://css-tricks.com/snippets/css/remove-scrollbar-from-textarea-in-ie/

Disable Process Attach Warning in Visual Studio 2010

Problem:

We often debugging and we need to attach process like w3wp.exe, service process or any process in visual studio.Visual studio every time asks warning like "Attaching to this process can potentially harm your computer. If the information below looks suspicious or your are unsure, do not attach to this process."

We know that this process is not harmful and we want to disable that warning right?

Solution:

1. Close all instances of visual studio.
2. Update registry value:

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\Debugger

And set the value DisableAttachSecurityWarning to 1

OR

if you don't want to find registry and update value manually then just download this registry file from here and just open this file.

Mirth : Add parameter in database query

Problem:

Insert / Update database field value using param.

Solution:

//Add param.
params = new java.util.ArrayList();

var paramValue = 'SomeValue';

//Add param Value in param array.

params.add(paramValue);

//Insert / Update in DB.
dbCon.executeUpdate('INSERT INTO tableName (?) VALUES ("' + SomeValue + '")', params);

$(document).ready vs. $(window).load

jQuery offers two powerful methods to execute code and attach event handlers: $(document).ready and $(window).load. The document ready event executes already when the HTML-Document is loaded and the DOM is ready, even if all the graphics haven’t loaded yet. If you want to hook up your events for certain elements before the window loads, then $(document).ready is the right place.

$(document).ready(function() {
 // executes when HTML-Document is loaded and DOM is ready
 alert("document is ready");
});

The window load event executes a bit later when the complete page is fully loaded, including all frames, objects and images. Therefore functions which concern images or other page contents should be placed in the load event for the window or the content tag itself.

$(window).load(function() {
 // executes when complete page is fully loaded, including all frames, objects and images
 alert("window is loaded");
});

Format dates in SSRS reports

Displaying dates in different formats in your reports is a very common requirement that one faces while working with Sql Server Reporting Services (SSRS).

Let us see how we can display dates in different formats :

=Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08

=Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008

=Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08

=Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 =Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50

=Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008

Original Source: http://www.sqlservercurry.com/2008/02/format-dates-in-ssrs-reports.html

Converting Text to Proper Case or Capital Case or Lower Case in Access

Problem:
Convert text in different format like CAPITAL CASE, lower case and Proper Case in access.

Solution:
You user StrConv fuction for all case.

OR

For UPPER CASE Use UCASE();
For lower case use LCASE();

Syntax:

1) StrConv Function:
StrConv(Target String, Conversion Type)

Target String is a string which you want to convert the string in different case.
Coversion Type:
1 – Converts the string to uppercase characters.
2 – Converts the string to lowercase characters.
3 – Converts the first letter of every word in string to uppercase.

2) UCASE and LCASE

UCASE(Target String)

LCASE(Target String)

Examples:

For CAPITAL CASE.

Select StrConv("Target String", 1); Return: TARGET STRING

For lower case.

Select StrConv("Target String", 2); Return: target string

For Proper case.

Select StrConv("target string", 3);  Return:  Target String