SQL SERVER FUNCTION COUNT

SQL SERVER FUNCTION COUNT

/*COUNT FUNCTION SQL SERVER MANAGEMENT STUDIO*/

--HI VIEWERS, TODAY WE ARE LOOKING AT THE COUNT FUNCTION IN SQL SERVER MANAGEMENT STUDIO

--WE WILL COUNT THE NUMBER OF ROWS IN A TABLE

--FIRST WE START WITH ENTERING THE KEYWORD, SELECT, THEN THE FUNCTION NAME COUNT(

SELECT COUNT(*)
FROM DBO.DimProduct;

--SO THE THEORY IS AS SO

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

-- FROM TABLE NAME;

--NOW HIGHLIGHT THE CODE AND CLICK EXECUTE OR (F5)

-- AS YOU CAN SEE FROM THE RESULT BELOW, THERE ARE 606 RECORDS IN THE PRODUCT TABLE