You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

If the user enters data with an apostrophe into a text box, and you attempt to build and SQL string to execute, you get something like this in your string:<BR><BR><B>INSERT INTO MyTable ...