Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does the 1 Click DB Command Screen work _exactly_ like SQL Server Query Analyzer ?

April 26, 2017analyzer Click Command DB query screen SQL Server

0

10 Posted

Does the 1 Click DB Command Screen work _exactly_ like SQL Server Query Analyzer ?

1 Answer

0

10 Posted

No and this is for the simple reason that 1 Click DB uses ADO and Query Analyzer works with more low level ODBC commands. ADO is a middleware product that has some built in limitations. Show Plan results for 1 Click DB may be different than what appears from Query Analyzer because of automatic ADO translations of your SQL CommandText. Also when a fatal ADO error is triggered in a batch command using the OLEDB provider, output from the rest of the batch will not be returned.