SQL SERVER COUNT BIG FUNCTION

SQL SERVER COUNT BIG FUNCTION

/* COUNT_BIG FUNCTION IN SQL SERVER SSMS */

--ALRIGHT, WE WILL BE USING THE COUNT_BIG FUNCTION IN THIS TUTORIAL

--FIRST WE START BY ENTERING THE KEYWORD, SELECT, THEN THE FUNCTION NAME

--COUNT_BIG TO COUNT_BIG ALL THE RECORDS IN A TABLE

SELECT COUNT_BIG(*)
FROM DimAccount;

--THE THEORY WORKS LIKE THIS

-- SELECT COUNT_BIG(ALL ROWS IN TABLE(S)

-- FROM TABLE NAME

-- SO SELECT THE CODE AND CLICK EXECUTE OR (F5)

-- AS YOU CAN SEE THE TOTAL NUMBER OF ROWS IN THE ACCOUNT TABLE IS 99

-- THAT IS IT