.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

How can I select all transactions for the day?

Posted By :Syed Shakeer Hussain     Posted Date :September 17, 2010    Points :10   Category :Sql Server 
SELECT * FROM [dbo].[Orders]

You can also find related Interview Question to How can I select all transactions for the day?  below: 

How many types of Transactions are there in COM + .NET ?

There are 5 transactions types that can be used with COM+. Whenever an object is registered with COM+ it has to abide either to these 5 transaction types.

Disabled: - There is no transaction. COM+ does not provide transaction support for this component.

Not Supported: - Component does not support transactions. Hence even if the calling component in the hierarchy is transaction enabled this component will not participate in the transaction.

Supported: - Components with transaction type support will be a part of the transaction. This will be only if the calling component has an active transaction. If the calling component is not transaction enabled this component will not start a new transaction.

Required: - Components with this attribute require a transaction i.e. either the calling should have a transaction in place else this component will start a new transaction.

Required New: - Components enabled with this transaction type always require a new transaction. Components with required new transaction type instantiate a new transaction for themselves every time. (More...)

Select Syntax


How can we find the open transactions details in sql server?

Yes, it is possible.

select * from sysprocesses where open_tran > 0

This query will provide list of all the open transaction details. (More...)

Write and justify output of - select nullif('test','test')

The output will be - NULL
Justification : nullif returns NULl if given two arguments are same else returns the first specified argument. So, for the given SQL, output will be NULL. (More...)

Difference between Set and Select keyword in sql server?


1.Set is a ANSI standard for variable assignment.
2.We can assign only one variable at a time
3.When assigning from a query that returns more than one value, SET will fail with an error.


1.Select is a Non-ANSI standard when assigning variables.
2.We can assign multiple variable at a time
3.When assigning from a query that returns more than one value, SELECT will assign the last value returned by the query and hide the fact that the query returned (More...)

What are The Transactions In Sql Server ?

BEGIN Transaction

Roll BAck Transaction

Commit Transaction

Save Transaction (More...)

How to Select a value from Dataset?

By Using DataTable.Selet() Method? (More...)

Write a query to Select top 2 Highest salaries?

select Top(2) salary from Tablename order by Salary desc.... (More...)

Consider the following code:

public class Example extends Thread
public void run()
System.out.println ("Hello");

public static void main (String args[])
new Example();

Select the correct option regarding the preceding code ?

1, The code will not compile.
2, The code will compile but will not execute.
3, The code will compile, execute, and display Hello as the output.
4, The code will compile, execute, but will not display anything.

Answer : 4 (More...)

Select the correct statement that sets the priority of a thread among a group of threads to maximum.

1, threadObj.getPriority(THREAD.MAX_PRIORITY);
2, threadObj.setPriority(MAX_PRIORITY);
3, threadObj.setPriority(THREAD.PRIORITY);
4, threadObj.setPriority(THREAD.MAX_PRIORITY);

Answer : 4 (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend