SQL @@CONNECTIONS is one of the System Statistical Function, which returns the number of connections since SQL server is last started. This includes both successful and unsuccessful connections.
Syntax behind this is @@CONNECTION is
SQL @@CONNECTIONS Example
Below code snippet will show you the total number of connections for this SQL Server.
-- SQL Server @@CONNECTIONS Example SELECT @@CONNECTIONS AS [Total Connections]
You can use GETDATE() function along with this function to see the total number of connections until today.
-- SQL Server @@CONNECTIONS Example SELECT @@CONNECTIONS AS [Total Log In Attempts], GETDATE() AS [As of Today]