Tag: new data types in sql server 2008

• HierarchyId Data Type

  Here I Explained the New Data Type in Sqlserver 2008. What is HierarchIyd Data Type?  HierarchyId data type is a variable length System Data Type. What is the use of HierarchyId Data Type? Represent position in a hierarchy manner. HierarchyId does not automatically represent a tree, it is depend on how to application generate and…

  Amit Patriwala

  October 23, 2009

• Sql Server 2008 Feature – Part1

  Here I am explaining Sql Server 2008 Key Features. 1) Initializing variable when you declare declare @val as int =0 declare @currentdate as datetime = getdate() print @val print @currentdate 2) Compound assignment operators –operator like +=,-=,/=,*/,%= declare @val as int = 0 set @val += 10; print @val 3) Add multiple row in single…

  Amit Patriwala

  October 23, 2009