|
|
-
G.S.Narayana Learned 2 Years ago through Just Learned
Do you know you can use system functions these way?
[code]
select * from
(
select 1 as number
) getdate(a)
[/code]
[code]
select * from
(
select 1 as number
) sum(a)
[/code]
[code]
select * from
(
select 1 as number
) count(a)
[/code...
|
-
G.S.Narayana Liked 2 Years ago through Just Learned
Do you know you can use system functions these way?
[code]
select * from
(
select 1 as number
) getdate(a)
[/code]
[code]
select * from
(
select 1 as number
) sum(a)
[/code]
[code]
select * from
(
select 1 as number
) count(a)
[/code...
|
-
G.S.Narayana Liked 2 Years ago through Just Learned
Do you know you can use system functions these way?
[code]
select * from
(
select 1 as number
) getdate(a)
[/code]
[code]
select * from
(
select 1 as number
) sum(a)
[/code]
[code]
select * from
(
select 1 as number
) count(a)
[/code...
|
-
G.S.Narayana Learned 2 Years ago through Just Learned
Do you know you can use system functions these way?
[code]
select * from
(
select 1 as number
) getdate(a)
[/code]
[code]
select * from
(
select 1 as number
) sum(a)
[/code]
[code]
select * from
(
select 1 as number
) count(a)
[/code...
|
-
G.S.Narayana Liked 2 Years ago through Just Learned
While trying to retrieve the select top count dynamically, initially tried this way
[code]
Declare @noOfRowsPerChunk int
set @noOfRowsPerChunk = 5
select top @noOfRowsPerChunk RecordID from myTable
[/code]
which throwed the syntax error.
Fix:...
|
RKA
91
·
2% ·
598
|
|
-
G.S.Narayana Learned 2 Years ago through Just Learned
While trying to retrieve the select top count dynamically, initially tried this way
[code]
Declare @noOfRowsPerChunk int
set @noOfRowsPerChunk = 5
select top @noOfRowsPerChunk RecordID from myTable
[/code]
which throwed the syntax error.
Fix:...
|
|
RKA
91
·
2% ·
598
|
|
-
G.S.Narayana Learned 2 Years ago through Just Learned
While trying to retrieve the select top count dynamically, initially tried this way
[code]
Declare @noOfRowsPerChunk int
set @noOfRowsPerChunk = 5
select top @noOfRowsPerChunk RecordID from myTable
[/code]
which throwed the syntax error.
Fix:...
|
|
RKA
91
·
2% ·
598
|
|
-
G.S.Narayana Liked 2 Years ago through Just Learned
While trying to retrieve the select top count dynamically, initially tried this way
[code]
Declare @noOfRowsPerChunk int
set @noOfRowsPerChunk = 5
select top @noOfRowsPerChunk RecordID from myTable
[/code]
which throwed the syntax error.
Fix:...
|
|
RKA
91
·
2% ·
598
|
|
-
G.S.Narayana Learned 2 Years ago through Just Learned
1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables
2) Table variables c...
|
-
G.S.Narayana Liked 2 Years ago through Just Learned
1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables
2) Table variables c...
|