And you are right about colid not even being highlighted.

colid as in, say

[font="Courier New"]select SC.[name]

from syscolumns SC

inner join sysobjects SO ON SO.[id] = SC.[id]

AND SO.[name] = 'Customer'

order by sc.[colid][/font]

So...

If a user is bothered by the color itself, he might as well use a black and white monitor... I think the OP was more concerned as to the implications...

Not directly related to the mechanics on how to do it, but:

By SSN, do you mean Social Security Number ? As a primary key in a database ?

SSN is a...

Posting just the query is not sufficient.

For us to hepl you, test data data is also required. And since we are volunteering our time free to help, in kind you...

Maybe "beyond relational" should be read in the context "relational and more" ?

Yup. Rather than just limiting ourselves to relational, let's just add non relational things... On top of XML,...

Change the coloring to be all the same color.

Wut ??

Highlighting keywords is a valuable assistance provided by the system. A typo in a keyword or failing to add...

Jeff,

I do not believe I could have figured that one out in a hundred. Still OOHing and AAAHing and drooling over that article. Time to print a clean copy...

Now, where...

Incrementing a value

An alternative way is to exploit MS SQL Server's proprietary update method of SET @variable = columnname = formula.

Give a SERIOUS look at this great article:

Solving the...

-> WebTechie38

You still have not indicated WHY you would bother with the order of the columns in the first place. Is this really the NEED or the need confused with...

-> R Barry Young

because it cannot effectively use any indexes and (at best) is forced to scan the whole table.

I am not clear as to why indexes cannot be used,...

The code posted by Lynn

[font="Courier New"]insert into #MyTest

select 'ANDERSON DAIRY PRODUCTS ','19','PA' union all

select 'ALLIED REFRIGERATION, INC. ...

-> dejanette.gordon

The only thing missing is the data generator...

[font="Courier New"]INSERT INTO myTable (Field1, Field2, etc.)

SELECT '10', '20' UNION ALL

SELECT '11', '21' UNION ALL

SELECT '12', '22' UNION ALL[/font]

As opposed to...

Peso,

Thanks for your last.

As a bonus, you reminded me to use "UNION ALL" instead of just "UNION". Granted that for a small set of 8 lin es it does not...

Gave it another try. Using the slash character, its ASCII value is 1 less than that of the 0 (zero) character. Works as long as the slash characgter...

Chris,

As shown in my real-life example, the OP data set is only a very restrictive of a larger, PRACTICAL set where length is not fixed. Besides, the OP also mentioned...