|
|
|
|
|
|
|
|
-
Sergejack Commented 6 Months ago through Blogs | 1 Point
But what are your conclusions? Are you recommanding the usage of some methods (on specific scenarios)?...
|
-
Sergejack Liked 10 Months ago through Blogs | 1 Point
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
-
Sergejack refreshed 10 Months ago through Blogs | 1 Point
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
|
|
|
|
-
Sergejack Commented 1 Years ago through Blogs | 1 Point
I was pretty sure only global temporary table could be accessed.
You prove me wrong....
|
-
Sergejack Commented 2 Years ago through Blogs | 1 Point
BTW, try this :
declare @two int
set @two = 2
select a,b from
(
select 1 as a,3 as b
union all
select 1 as a,2 as b
) t
order by @two, a
It should put on light that using a number to refer a retrieved column is a strict (shorhand) s...
|