The @@ROW COUNT variable returns the number of rows read by the last executed statement. If any statement does not return any rows, then value of @@ROWCOUNT variable is set to zero.
MSSQL @@ROWCOUNT VARIABLE SYNTAX
Using @@ implies that it is a global variable. Also @@ROWCOUNT returns the value of int type i.e. the maximum no of rows @@ ROWCOUNT can return is 231 (2,147,483,647). For returning rows greater than this limit, ROWCOUNT_BIG function is used.
SQL School provides real-time trainings, projects and Jobs on various technologies including SQL Server, SQL DBA, MSBI, Power BI, Microsoft Azure, PL SQL, Oracle DBA, RAC DBA, Oracle Golden Gate and DataScience. We have experienced and certified trainers on these technologies.
SQL School (www.sqlschool.com) have been providing trainings, placements and projects for more than TEN years and working with many MNCs for their direct training requirements including ADP, MindTree, Sonata, L& T, and many more. Few of the recent invoices can be found at www.sqlschool.com/clients
SQL DBA TRAINING – CDC, SERVER ALIAS n NETWORK PROTOCOLS
SQL SERVER DBA TRAINING CDC, Aliases, Network Protocols
This video explains SQL DBA Training Content – CDC [Change Data Capture], Server Aliases and Network Protocols.
Change Data Capture is used to AUDIT DML [INSERT. UPDATE, DELETE] and minimal DDL[ALTER TABLE .. ADD/ALTER COLUMN/CONSTRAINT .. statements] operations on any SQL Server Table. Applicable for Enterprise and Data Center Editions.
Server Aliases are used for SQL Server Connection Aliasing and Application Level Connection Abstraction.
Network Protocols to ensure secured transfer of TDS [Tabular Data Stream] Packets between SQL Server and any client like SSMS, SQLCMD, PSSDIAG, etc..
At SQL School Training Institute, we provide complete real-time and practical traininings on SQL Server T-SQL, SQL DBA, MSBI (SSIS, SSAS, SSRS), Power BI and more…
For details course curriculum available at :
To register for a free demo, visit: