Tip Bank

DevX - Software Development Resource

MySQL to MS SQL Syntax

Question: I have the following dump for MySQL and am having a problem getting it corrected for MS SQL. Can you help? Here is the dump file: # MySQL dump

DevX - Software Development Resource

A Simple Sort Not Working

Question: I have the following: sql=”select * from products” How do I sort or order by two columns retrieved in the “*”? Answer: You need to specify them directly in

DevX - Software Development Resource

Use Strict Type Variables

If you want to improve performance of your application then you should always try to use strict type variables. You can use strict type (or strongly typed) variables by referencing

DevX - Software Development Resource

Control Transaction Rollback

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in SQL Server is to roll back only the statement that generated the