SET in MSSQL-query
| From: | Thomas | Date: | Mon, 08 Jan 2001 13:57:59 +0000 |
| Subject: | SET in MSSQL-query | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4858@lists.php.net to get a copy of this message | ||
Hello!
If I want to change e.g. the textsize with SET TEXTSIZE 16384, it is no
problem in the qury-analyzer.
If I want to do it in script with
mssql_query( "SET TEXTSIZE 16384", $db );
and check it in the query- analizer with:
SELECT @@TEXTSIZE
it has still the old value.
What do I wrong?
2nd questiion: How can I get the result of "SELECT @@TEXTSIZE" in a
php-script?
Many thanks,
Thomas