Pages - The SQL Ideas

Sign in | Join

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	Pages

Upload Image

Close it

Select File

The SQL Ideas

Administrators


	Like

Invite Friends

Browse by Tag · View All

DDL	1
trigger	1
DML	1
backup	1
SQL Scripts	1
sql server general	1
database	1
#sql	1
#SQL Server	1
t-sql	1

The SQL Ideas

Share a link · Home · Posts · FAQ · Comments · Liked (19) · Preferences

1
Liked

PERCENTILE_CONT() and PERCENTILE_DISC() - A new analytic functions in SQL Server Denali CTP3

PERCENTILE_CONT() : Computed by linear interpolation between values after ordering them. Like in example for the four values of group, it will be calculated as per following formula,...

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

New analytical functions in SQL Server Denali CTP3 - FIRST_VALUE() and LAST_VALUE()

1.FIRSTVALUE : Returns first value based on partition and order by clause 2.LASTVALUE : Returns last value based on partition and order by clause...

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

SQL Server Denali CTP3 - IIF function - Returns one of two arguments, depending on the evaluation of expression

I just learned about IIF function provided by SQL Server 11 CTP3, which takes 3 arguments, first argument is condition. If condition returns true, it returns second argument. If condition returns false, it returns third argument. It was already part of ...

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

EOMONTH - Returns End Date of Month in SQL Server Denali CTP3

EOMONTH is really intresting feature introduced by SQL Server 11 CTP3. It returns the end date of Month based on the passed date in query....

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

CONCAT - Used to concatenate two or more strings in SQL Server Denali CTP3

I just installed SQL Server 11 CTP3 in my machine and started to review new functionalities. One feature I learned is CONCAT(tsql function) which is used to concatenate two or more strings. This function requires 2 to 254 arguments....

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

SSIS - Set DelayValidation to "TRUE" in Send Mail Task to prevent file existance check at the beginning of Package execution

I set "DelayValidation" parameter of Send Mail Task to TRUE and then it skipped to validate existence of file at the beginning of file execution....

Paresh Prajapati Posted on Mar 23 2012 12:00AM
Profile · Blog · Facebook · Twitter

Copyright © Rivera Informatic Private Ltd

Contact us Privacy Policy Terms of use Report Abuse Advertising

[ZULU1097]