|
|
-
rajasekhar Liked 9 Months ago through Just Learned | 1 Point
@@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 ...
|
-
rajasekhar Learned 9 Months ago through Just Learned | 1 Point
@@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 ...
|
-
rajasekhar Liked 9 Months ago through Just Learned | 1 Point
@@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 ...
|
-
rajasekhar Learned 9 Months ago through Just Learned | 1 Point
@@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 ...
|
-
rajasekhar Commented 11 Months ago through Just Learned | 1 Point
Hi All,
One more Extended SP is there for version.
xp_msver will give all details....
|
-
rajasekhar Commented 11 Months ago through Just Learned | 1 Point
Hi All,
One more Extended SP is there for version.
xp_msver will give all details....
|
-
rajasekhar Liked 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
rajasekhar Learned 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
rajasekhar move 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
rajasekhar Liked 12 Months ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|