Prev: SQL0901N Error.
Next: Convert DECIMAL to DATE
From: Serge Rielau on 10 Mar 2006 11:19
Ian Boyd wrote:
> VALUES is a cool construct. i don't know if it's in SQL92/99/etc, but
> SQL Server should have something like it - even if i can't think of good
> uses for it right now :)
Using VALUES you can PIVOT tables and you can also simplify that
UPDATE trigger of yours into a single INSERT statement.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
From: Ian Boyd on 10 Mar 2006 11:23
>> VALUES is a cool construct. i don't know if it's in SQL92/99/etc, but
>> SQL Server should have something like it - even if i can't think of good
>> uses for it right now :)
> Using VALUES you can PIVOT tables and you can also simplify that
> UPDATE trigger of yours into a single INSERT statement.

Whoa, whoa, slow down.

Let me figure out how to do SELECTs first :)


From: Ian Boyd on 10 Mar 2006 11:34
> It's called PL/SQL.

>>i hope they aren't case-sensitive
>
> For object names, databases are case-sensitive.

*shudder* Let's hope i never have to use Oracle.

> However, if not
> enclosed in double-quotes, it is implicitly uppercased before being
> evaluated. Therefore, it appears as case-insensitive.
> SQL Server breaks this, however, and is rather annoying.

Breaks what? SQL Server isn't case sensitive.

>>i hope they allow identifiers to be longer than 18 characters.
>
> IIRC, it's 30.

i tried to do a quick check: At *least* 2000 identifiers we would have
to shorten if we're limited to 30 characters. Some database names,
some table names, index, keys, foreign-keys, etc


From: Ian Boyd on 10 Mar 2006 11:35
> >Right now it's WoW.
>
> Which server?
>
> I finally just got enough gold to get my epic mount. I just need a
> guildy to buy it for me, so i can save the extra hundred gold.

Elune (PvE).

We were on Ner'zhul (PvP), but jumped ship when the honor system came out.

Our guild on Elune is <Honor System Refugees>

Not too many people get it, but i think it's clever.


From: Ian Boyd on 10 Mar 2006 11:37
> Ian,
> try c-style comments. They should work across the board.
> /*... */
> Prereq is FP9

Excellent! That works. i don't know what FP9 is, but what do i care, it
works!


First  |  Prev  |  Next  |  Last
Pages: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Prev: SQL0901N Error.
Next: Convert DECIMAL to DATE