Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mickbrooke
- Order by date
-
OSQL buffer contents
Does anyone know of a way to print out the contents of the OSQL buffer? I have written some scripts which, when I run via OSQL, simply return the status of each command. I would like to show the user the sql statement which is being executed. e.g. osql -d dbname 1> select * from table 2> go...- mickbrooke
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Max 255 characters
Cheers for that, it is basically a bug in SQL server. It uses 1 byte to designate the length (i.e. max 255). I have used TEXT instead and it is now OK. Thanks again.- mickbrooke
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Max 255 characters
Does anyone know if the following is a bug or am I simple. I have a table with a varchar (500), I use Enterprise manager to fill it with '#'s. When I select the field into my sqc (embedded sql) program I get 255 charachters and the rest is spaces. osql returns all 500 characters, isql returns...- mickbrooke
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
