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

Question Posted / ravi2514

1 Answers
5781 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 instead of dml trigger?

0 Answers

Explain different types of index?

0 Answers

What is difference statement and preparedstatement?

0 Answers

What is difference between materialized view and view?

0 Answers

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers

Whether the updations made to the views reflect the original records in the table

5 Answers NIIT,

What is the difference between Drop and Truncate

20 Answers GT Nexus, IBM,

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers

Do you know the policy based administration feature of sql server 2008?

0 Answers

What is scalar user-defined function?

0 Answers

What is the use of stored procedure?

0 Answers

For more SQL Server Interview Questions Click Here