Classic ASP, Stored Procedures and NText

This note is about the problem I had trying to display the NText variable from executing a stored procedure. Atlast, I figured out that we need to have the NText variable as the the last variable in the query in order for the data to get displayed in classic ASP pages.

NText, NVarchar in SQL Server - Support for Unicode Content

NText used for characters in excess of 8000 bytes (=~4000 characters) of unicode content

NText stores upto 1 GB of data (Text stores upto 2 GB of data)

NText cannot be indexed

NText will not employ string functions like Len, Replace

When substr function is used on NText, there is conversion to nvarchar

NVarchar stores upto 4000 characters with unicode support for characters. This is an extra overhead and use this only if it is really needed.

What is MMC? How to access Internet Service Manager?

MMC is the abbreviation for Microsoft Management Console. It provides an interface to manage services on windows machines.

You can access MMC by typing Start > Run > mmc.

You can call the Internet Service Manager MMC in many ways,
1) Start > Control panel > Administrative tools > Internet Services Manager
2) Start > Run > inetmgr (short cut to call IIS manager)

How to execute .asp or .aspx file from my computer?

When you want to execute your .asp/.aspx files on Windows IIS server you can get to know the name of the server or the local machine by right clicking on "My Computer" and then clicking "Properties" from the dialog box.

Under "Network Identification" or under the tab "Computer Name" there will be separate marking called "Full Computer name" followed by the name of the computer machine/server. For e.g. if the name is something like "myserver", then you can access the server side scripts by typing the following URL on the browser address bar

http://myserver/myprogram.aspx

Alternative way is to type http://localhost/myprogram.aspx or by typing
http://127.0.0.1/myprogram.aspx.

127.0.0.1 is the loopback address that causes requests to be sent to a web server on the local machine and 'localhost' is an alias for 127.0.0.1