Answer Posted / Rinku Sharma
System views in SQL Server are predefined views that provide information about various aspects of the database and its objects. Examples include sys.databases, sys.tables, and sys.columns. These views can be queried to retrieve detailed information about the database's structure, statistics, and runtime information.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
How can I check that whether automatic statistic update is enabled or not?
How to rebuild the master database?
what is the difference between openrowset and openquery?
How raid can influence database performance?
What is sql or structured query language?
What are the kinds of subquery?
What is acid mean in sql server?
How efficient you are in oracle and SQL server?
What are the different subsets of sql?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is normalization and what are the advantages of it?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
If any stored procedure is encrypted, then can we see its definition in activity monitor?
