Archive for the ‘SQL’ Category
Tuesday, February 12th, 2008
I tried to run a query today and have the results go to a file. The output was a ton of rows with only one column. If you need to output query analyzer results to a format compatible with Excel just do the following:
Go to "Tools"
Click "Options"
Click the ...
Posted in IT, Programming, SQL, Software, Technology, Web Development | No Comments »
Monday, August 13th, 2007
The default values limit all text retrieved from text and image fields to 4096 characters (bytes). The workaround for this is as follows.
ini_set("mssql.textsize", 536870912);
ini_set("mssql.textlimit", 536870912);
mssql_connect(...);
mssql_select_db(...);
mssql_query("SET TEXTSIZE 536870912");
Please note that you must call the ini_sets before you connect to the database.
Related posts:Connecting to Microsoft SQL Server with PHPInstall SSH Server ...
Posted in PHP, SQL, Technology, Web Development | No Comments »
Thursday, August 9th, 2007
I decided to be secure and came up with a 33 character password for a MS SQL Server account. After writing a settings file for my new PHP blog application and a DB class I tried to connect. No go. The permissions were checked and everything looked ...
Posted in PHP, SQL, Technology, Web Development | 7 Comments »
