{"id":6,"date":"2011-06-20T11:35:17","date_gmt":"2011-06-20T11:35:17","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/20\/using-connections-variable\/"},"modified":"2011-06-20T11:35:17","modified_gmt":"2011-06-20T11:35:17","slug":"using-connections-variable","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/20\/using-connections-variable\/","title":{"rendered":"USING @@CONNECTIONS VARIABLE"},"content":{"rendered":"<div>@@CONNECTIONS Variable&nbsp;contains the number of connections that were called on to the SQL Server Service.<\/div>\n<div>This number includes both Successfull and unsuccessful connections.<\/div>\n<div>Basic Syntax for using @@CONNECTIONS:<\/div>\n<p><code><br \/>\nSELECT @@CONNECTIONS<br \/>\n<\/code><br \/>\n&nbsp;<\/p>\n<p>Output for the Above query would give the following depending up on your server:<\/p>\n<p style=\"padding-left: 90px\"><a href=\"\/wp-content\/uploads\/2011\/06\/ConnectionsResult.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5\" title=\"ConnectionsResult\" src=\"\/wp-content\/uploads\/2011\/06\/ConnectionsResult.jpg\" alt=\"\" width=\"184\" height=\"95\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>@@CONNECTIONS Variable&nbsp;contains the number of connections that were called on to the SQL Server Service. This number includes both Successfull and unsuccessful connections. Basic Syntax for using @@CONNECTIONS: SELECT @@CONNECTIONS &nbsp; Output for the Above query would give the following depending up on your server: &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19],"class_list":["post-6","post","type-post","status-publish","format-standard","hentry","category-sql-server-variables","category-sqlserverpedia-syndication","tag-connections","tag-connections-global-variable-in-sql-server","tag-connections-variable-in-sql-server","tag-find-number-of-connections-in-sql-server","tag-get-number-of-connections-sql-server","tag-how-to-check-number-of-connections-in-sql-server","tag-need-of-connections-variable-sql-server","tag-number-of-connections-in-sql-server","tag-number-of-connections-in-sql-server-2000","tag-number-of-connections-in-sql-server-2005","tag-number-of-connections-in-sql-server-2008","tag-number-of-connections-in-sql-server-2012","tag-number-of-connections-in-sql-server-database","tag-sql-server-system-variable-connections","tag-use-of-connections-variable-sql-server","tag-what-is-connections-variable"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/6\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}