Learn About MEAN Stack

MongoDB, Express, AngularJS, Node.js abbreviated as MEAN, these are development pack by all Javascript. In this sample we are going to use MSSQL Server instead of MongoDb.

With this application sample we can create a new user, show all the user, modify user data & also can able to delete the user through API build with Express from frontend using AngularJS.

Components:

  • MSSql – SQL database
  • Express – NodeJS Framework
  • Angular – JavaScript frameworks for Frontend
  • NodeJS – JavaScript Execution environment (Server)

Read more “Learn About MEAN Stack”

Char, Nchar, Varchar & Nvarchar Data Types

CHAR vs VARCHAR

CHAR:

  1. It is a fixed length data type
  2. Used to store non-Unicode characters
  3. Occupiers 1 byte of space for each character

VARCHAR:

  1. It is a variable length data type
  2. Used to store non-Unicode characters
  3. Occupies 1 byte of space for each character

NCHAR vs NVARCHAR

NCHAR

  1. Is a fixed length data type
  2. Used to store Unicode characters (for example the languages Arabic, German and so on)
  3. Occupies 2 bytes of space for each character

NVARCHAR

  1. It is a variable-length data type
  2. Used to store Unicode characters
  3. Occupies 2 bytes of space for each character