Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
rowcount « System Settings « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
System Settings
rowcount
26.27.rowcount
26.27.1.
Using the SET ROWCOUNT Option
26.27.2.
Updating an end user's expiration date.
26.27.3.
adds the account column to the authors table and creates the new bank and brokerage tables.
26.27.4.
if @@ROWCOUNT = 0, return
26.27.5.
if @@ROWCOUNT > 1, rollback
26.27.6.
@@rowcount can be used to verify the success of selected operations
26.27.7.
EXEC and @@ROWCOUNT