How can u get the number of pupils connecting the database?

Question Posted / ravi2514

1 Answers
5778 Views
Cap Gemini, I also Faced
E-Mail Answers

How can u get the number of pupils connecting the database?..

try this below query:

use <databasename>
go
select db_name(dbid) as db, count(dbid) as connections from sys.sysprocesses where dbid > 0 group by dbid

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between a function and a stored procedure?

0 Answers

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers Cognizant, TCS,

What is the impact on other user sessions when creating indexes?

0 Answers

Write a program using SQL queries to find a unique entry in a table.

0 Answers Tech Mahindra,

What do you think of this implementation? Can this be implemented better?

0 Answers

How to provide values to user defined function parameters?

0 Answers

What is the default fill factor value?

0 Answers

Explain what is sql server english query?