Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Another one of these choices... to go with a char or varchar for a field. Not really an issue with space since we are only looking at a couple of thousand records or so but just wondering what the ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

I have an MS SQL 2005 database, and a FileMaker 10 client accessing it via ODBC (SQL Native Client) The data I am trying to import is (varchar(max), null). I have no problem importing (varchar(64), ...