SELECT SERVERPROPERTY('Collation')

Why would he need to use XML for this??

Ok, then the easiest way would probably be to add a table with alternate texts for lookup values as Remi suggested above.

Yes, very good indeed.

The question is though, do you also need to remember which description of the lookup value the user chose? That would have implications on which design to use.

Of course if the columns are char(4) and char(2) (and I would not be surprised if they are) then you could simply do:

WHERE yearcolumn + monthcolumn BETWEEN '200501' AND '200510'

The...

VS probably thinks it looks strange to have a unique constraint with only two possible values. Yes, the other columns increase the amount, but for two specific values of those...

Actually, AWE would not even be used. SQL Server would ignore it when starting on a server with <=4GB RAM.

Simple recovery mode does not mean things are not logged. It only means that the log can be truncated after a checkpoint. If an application is inserting a huge number...

Rudy, I did not say anything about how the rows are stored. I said that SQL puts meaning to the order in which you specify columns for a table. For...

http://blogs.msdn.com/davidnotario/archive/2005/04/27/412838.aspx

Aha. Yes, with Open File it seems that you get a Connect dialog every time. However if you press Ctrl+N, or New Query, then that will open a new empty...

I assume what you are asking is how to insert a new row into users_master and in the same transaction insert a row (or many) into users_personalinfo, using the same...

Have your application do this in batches. Read a number of rows into a disconnected recordset, process the numbers and write the results to a file. When you are done,...

You can use xp_cmdshell for all kinds of interaction with the shell. Using something like EXEC master.dbo.xp_cmdshell 'echo %FOO%' you can get the value of an environment variable called foo....