Whether we not concanate the two variable like

@Var1 + @Var2 ??

Hi,

Can you please check your query one more time, as it seems not right.

As the query itself will return 0 records.

select A.Column1, B.Column1, count(A.Column1) as Frequency

,sum(B.Column2-A.Column2) as Difference

from TEST_TABLE 1...

Hi

I find a script which also get the default constraints.

This script I already added to my blog.

http://matespoint.blogspot.com

Thanks.

Hi,

Colud you please check you column values.

If it containings null values, while counting null values the query will not count it as a record , but while count(*) it will...

Your query looks great!!

After this article I tried here and there but colud not get a compact solution, however I get a query to get all the constraints for a...

I am confused with this question which somewhere says it takes the default schema if you dont provide one.

Please check http://msdn2.microsoft.com/en-us/library/ms177544.aspx

I could not understand this question clearly.

May be someone please elaborate this.

Nice twisted question, people had to think once again, i get it wrong although i was knowing that no middle join is there, but do not beyond that it can...

It just doing simple mathmetical expression,

For ex -

declare @i int

select @i = -5

select @i*@i

Answer = 25

declare @i int

select @i = 5

select @i*-@i

Answer = -25

declare @i int

select @i = 5

select...