Q: If I have multiple queries in the Query Window, can I execute only one of them? Q: How do I execute a query containing a server-side comment? That way, semicolons in you stored procedure will not be treated as statement separators. To make it work, type in your procedure and select Query->Execute SQL Buffer As-Is.Īlternatively, you can go to Settings -> Query Panel and only use 'go' as your statement separator. When creating a stored procedure, the procedure will most likely contain these statement separators so standard execute would fail.
DB Solo also removes both line and block comments before sending the statements to the server. Q: How do I create a stored procedure?īy default, DB Solo takes the text in the query window and splits it into separate statements using (semicolon) and 'go' as statement separators. To increase the default limit, go to Settings->Query Window and Settings->Browser Window and change the value in the 'Max Number of Rows Retrieved' field. To conserve memory and speed up response times, DB Solo only loads the first 1,000 rows by default. Q: My table contains over 5,000 rows, why do I only see the first 1,000 rows?
Db solo license install#
A single license allows a user to install and use the product on multiple computers (and operating systems) provided that only the licensed user is using the product. You can evaluate the product for 30 days without a license, but after the evaluation period you need to purchase a valid license for a fraction of the cost of other similar products. Should you have questions not addressed in this section or in the user documentation, please contact support.
This section provides answers to commonly asked questions.
0 kommentar(er)
