You can use Ordinal position in the ORDER BY Clause for sorting the resultset. The ordinal position refers the column position in the SELECT statement. Consider the following select statement select * from ( select 17 as a,2 as b union all select...

You can use Ordinal position in the ORDER BY Clause for sorting the resultset. The ordinal position refers the column position in the SELECT statement. Consider the following select statement select * from ( select 17 as a,2 as b union all select...

How build a trap for self using float type. ...

Yes, I did. At one server (2008r2) I've got 14 rows, but at (2005) - that I'm working with - is
.userprofile { color: #36c; font-size: 12px; font-weight: bold; text-decoration: none; } .userprofile A:VISITED { color: #039; font-size: 16px; font-weight: bold; text-decoration: none; } .userprofile A:HOVER { font-size: 16px; font-weight: bold; text-decoration: underline; }

Madhivanan JR 3 · 39% · 12419

I recently downloaded a cool fighter plane game (iFighter lite) on my iPhone. As I started playing, I felt that plane is moving a bit slow!! But soon enough I saw a little perk on the screen and I flew over it and suddenly plane's speed increased. Soon ...

Very nice, but what may be reason that I - using your example - do not have any records? Is that means that table can be stored at any other place?...

Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code declare @t table(i int) select * from tempdb.INFORMATION_SCHEMA.TABLES The result is TABLE_CATALOG TABLE_SCHEMA TA...

Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code declare @t table(i int) select * from tempdb.INFORMATION_SCHEMA.TABLES The result is TABLE_CATALOG TABLE_SCHEMA TA...

We know that it is impossible to access a temporary table from within a user define function e.g., the following script will fail --Checks if the #Temp table exists or not and if so drops it IF OBJECT_ID('tempdb..#Temp') IS NOT NULL BEGIN Drop Ta...

We know that it is impossible to access a temporary table from within a user define function e.g., the following script will fail --Checks if the #Temp table exists or not and if so drops it IF OBJECT_ID('tempdb..#Temp') IS NOT NULL BEGIN Drop Ta...