Blog Archives

Basic points to be considered when starting with SQL Server – – Part 2

Hello friends, In the previous post, we discussed when to use which datatype for string values.
Today, I want to draw your attention to some more data type selection. I mean we have several data types in SQL like:-

Read the rest of this entry

Advertisements

Some Important T-SQL Programmability feature of SQLSERVER 2008

There are lots of new feature introduced with SQLServer 2008 for improving the SQL experience of developers. Here we will cover some very important and useful features of SQLServer 2008. Features which we are going to cover is –

  1. Declaring and initializing new variables.
  2. Compound assignment operators
  3. Table value constructor
  4. Enhanced Convert Function
  5. Date and Time Data types
  6. Table Type

Read the rest of this entry

%d bloggers like this: