|
|
-
Ramireddy Liked 7 Months ago through Just Learned | 1 Point
Start > Programs > high-lite any item on the Menu and right click > Sort by ...
|
-
Ramireddy Learned 7 Months ago through Just Learned | 1 Point
Start > Programs > high-lite any item on the Menu and right click > Sort by ...
|
-
Ramireddy 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 ...
|
-
Ramireddy 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 ...
|
-
Ramireddy 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 ...
|
-
Ramireddy 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 ...
|
-
Ramireddy Liked 10 Months ago through Just Learned | 1 Point
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Ramireddy Learned 10 Months ago through Just Learned | 1 Point
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Ramireddy Liked 10 Months ago through Just Learned | 1 Point
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Ramireddy Learned 10 Months ago through Just Learned | 1 Point
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|