|
|
-
Dave Vroman Liked 9 Months ago through Just Learned
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did ...
|
-
Dave Vroman knew 9 Months ago through Just Learned
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did ...
|
-
Dave Vroman Liked 9 Months ago through Just Learned
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did ...
|
-
Dave Vroman knew 9 Months ago through Just Learned
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did ...
|
|
|
|
|
-
What is MSX / TSX in SQL Agent ?...
|
-
Dave Vroman Commented 10 Months ago through Just Learned
CONVERT(VARCHAR, DateColumn, 111)
Will do the same for a date column....
|
-
Dave Vroman Commented 10 Months ago through Just Learned
CONVERT(VARCHAR, DateColumn, 111)
Will do the same for a date column....
|
-
Dave Vroman Liked 10 Months ago through Just Learned
Typically when we require a number to be represented as a string we employ a CAST or CONVERT.
Sometimes though we want to preserve the natural 'sortability' of the numbers **after** the conversion and this poses a problem as string '8' is "bigger" t...
|