حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Get the count of records in table and assign to the temporary variable in sql

Vasanth

Hi

Please suggest an idea of the getting the count of records in a table and assign to the variable in sql

thanks in advance.

Mudassar

0 1

DECLARE @Count INT

SELECT @Count = COUNT(*)
FROM YourTable