SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Thursday, September 8, 2011
SQL Server Denali – EOMONTH()
›
EOMONTH() returns the date value that represents the last day of the month for given date. Syntax: EOMONTH( start_date [, months_to_add]...
Wednesday, September 7, 2011
SQL Server Denali: ColumnStore() a new Index Function
›
It is special type of index which stored columns in separate set of data pages instead of rows stored in data pages.It is optimized for th...
Tuesday, September 6, 2011
SQL Server Denali: CONCAT() Function
›
CONCAT() Function is new string function in SQL Server Denali. It returns a string that is the result of concatenating two or more string ...
1 comment:
Monday, September 5, 2011
SQL Server Denali– PARSE() and TRY_PARSE() conversion functions
›
PARSE() function converts expression (string value) to date/time and number data types if conversion is possible. If conversion isn’t poss...
Saturday, September 3, 2011
SQL Server Denali: FIRST_VALUE() and LAST_VALUE()
›
In SQL Server Denali introduced these two analytic function. As the Name suggests First_Value() returns the first value in an ordered set ...
‹
›
Home
View web version