Another Sol :

Select ProductType,

Grade,

(Value*100)/productsales AS [Percent]

FRom

(

select...

Check out this Query

taken from http://gallery.technet.microsoft.com/scriptcenter/Get-all-SQL-Statements-0622af19

;WITH

XMLNAMESPACES

(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan'

...

Nice question ..

and thanks HUGO for explanation.

Create Table TableWithdefaultvalue (ID Int Constraint DF_ID DEFAULT(0) , name Varchar(10) , Country Varchar(10) )

Here we have ID column which will accept value 0(zero) as default value in table.

Here...

i am completely agree with cy-dba

thanx for the question 1+

That was easy.

Output clause is a nice inclusion in sql server.

Thanx for the question 1+ 🙂

Thanx for the question

1+ 🙂

Really it a great question

thanx ...

learnt something new..

🙂

Thanx for the question..

Another difference between coalesce and Isnull

Select coalesce(Null,Null)

Msg 4127, Level 16, State 1, Line 1

At least one of the arguments to COALESCE must be a typed NULL.

Select...

Thanx Hugo

got this

ISNULL : replacement_value

Is the expression to be returned if check_expression is NULL. replacement_value must be of a type that is implicitly convertible to the type of...

Thanx for the nice explanation

Please explain this

Select isnull ('A',1 ) does not return Error

select COALESCE( 'A', 1)

Conversion failed when converting the varchar value...

1+ for me

Best question ..

coz i like this topic 1+

thanx:-)

i did something in past 1+