this is a job for a programming language; here's an example in vb.net for the...

we don't know what your preferred programming language is;

here's a link to an article on how to make a registration form in asp.net;

if you prefer php or something else, just...

--three char table: bigger range

CREATE TABLE X(XID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CHECK ((XID> 0) AND (XID < 17577)),

XCALCULATED AS

CHAR(((XID -1)/...

besides Seans sage advice, noone on your side has thought through possible max values, right?

if you force a min length of 3 characters, and also a max length of three...

if just the IP, is specified, then the instance that answers is whatever is listening on Port 1433.

you can see it in SSMS by connecting to each instance and finding...

sql-lover (10/19/2012)

---

Apologies,

Maybe I am not following, or I am not explaining myself properly, but I do not see the reason why we cannot elaborate an answer with the two column...

skb 44459 (10/19/2012)

---

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file...

here's an example of what you are asking;

you'll have to use a cursor if you want to send emails on a per-email basis from the data.

remember that when you assign...

you would have to uninstall 8 different cumulative updates, it looks like to me:

from http://sqlserverbuilds.blogspot.com/

see the number of rows different...

sql-lover (10/18/2012)

---

Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.

The real tables are more complex. I just simplified it using...

sql-lover (10/18/2012)

---

Do I have to use SET IDENTITY INSERT on the trigger itself? When inserting, I am getting this error ...

Cannot insert explicit value for identity column in table 'MyTable_A'...

ok i can do an instead of trigger;

here's a simple version of your example:

note how the isnerts into Table_A ignore whatever was passed for the c2 column

CREATE TABLE dbo.MyTable_A

(

...

well, you identified the fix: creating an INSTEAD OF TRIGGER on the view, that inserts the data into the "right" table.

but if you don't want to use a trigger, then...

a couple of prerequisites:

install the AccessDatabaseEngine_x64.exe from microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

make sure you open an Administrative command prompt window, and run it with the c:\Downloads\AccessDatabaseEngine_x64.exe /passive

command line flag;

this will force the...