Follow in Twitter & Facebook


Like in Facebook

Powered By Blogger Widgets

Free Download

FREE Tools


Sunday, December 23, 2012

Difference between char and nvarchar / char and varchar data-type?

- No comments
char[(n)] -
 Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character.

nvarchar(n) -
 Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying. 

varchar[(n)] -
 Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 characters in length. The SQL-92 synonyms for varchar are char varying or character varying. 

Naming Conventions for variables and methods.

- No comments

Remember while writing programs,Microsoft suggests using Camel Notation (first letter in lowercase) for variables and Pascal Notation (first letter in uppercase) for methods.

Each word after the first word in the name of both variables and methods should start with a capital letter. For examples variable names following Camel notation could be:

Thursday, December 13, 2012

SharePoint 2010 best practices

- No comments
Here is video tutorial by Russ Houberg about SharePoint 2010 best practices. They explained about Authentication mechanism, Business connectivity servies, search and search connectors , powershell, user profile , workflow etc.

Monday, December 3, 2012

Introduction to Asp.Net MVC 4 video tutorial

- No comments
In this video you will get some developer overview on Asp.Net MVC 4. You will see how to start with Asp.Net MVC 4 as well as new features.

You will see a new demo application on Asp.Net MVC 4.