Which built-in function returns the number of active transactions?
Ans: @@TRANCOUNT

Here you will find all type of interview questions with answers, Most famous set is SQL Server Interview Questions.
Ans: @@TRANCOUNT
What is Report Builder in SSRS? Report Builder is an Report authoring tool use to design ad-hoc reports and to manage the existing report...
How to display data on single tablix from two datasets in SSRS ? We can display data on single tablix from two datasets with the help of ...
Here we come with top 50 SSAS/PowerBI DAX interview questions with answers. Explain what is DAX? DAX stands for Data Analysis Expressio...
What are different types of DataSources in SSRS ? In SSRS we have few options available for choosing the DataSource. Some of datasource...
How to display total number of rows in a Single SSRS report? We can display the total number of rows in a single SSRS Report with the he...
Hi Readers this time we come with very much demanding interview questions which is requested by many database testers, So here we come with...
Suppose you have a table #Temp as shown in the below image(left table) and you want to repeat rows based on "NTimes" column valu...
How to find Running Total in SSRS ? We can find running total in SSRS with the help of a RunningValue Function . Running Value Functio...
Drill Through Reports : Drill through reports is when user click on the values ,redirect the user to another detail report. Drillthrough r...