Re: Nested select

"Hugo Kornelis" <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:jjvb12lparlmthnnllpsvrotgleknpm3ra@xxxxxxxxxx

(But in a table called "OrdersTable", I would really *hope* that the
Order column is NOT NULL...)


Hugo, I would hope so too. But if the table is truly called "OrdersTable"
then I would *expect* that anything is possible. :-)

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--


.

Relevant Pages

  • Re: Select Expression Operators
    ... Thanks Hugo. ... >>Sorry for what must seem like a dumb question, but I was wondering why I keep ... > SQL Server doesn't offer the same set of functions as Access and it ... > ISNULL will return the second expression if the first is NULL. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Trigger question on constraints
    ... Wayne Snyder, MCDBA, SQL Server MVP ... >> You could rewrite it as an INSTEAD OF trigger that would just perform ... >> David Portas ...
    (microsoft.public.sqlserver.server)
  • Re: using a trigger to enforce referential integrity
    ... You the man, Hugo!!! ... > When I have to mimic other users on my dev system, I use SQL Server ... This requires setting the SQL Server authentication mode ... > authentication and provide the login name and password for the test user. ...
    (microsoft.public.sqlserver.programming)
  • Re: percentages of top 10 tallies
    ... Hugo is using what is called a derived table. ... Columnist, SQL Server Professional ... My solution uses less IO and yours has the lowest query cost. ... >Hi Tom, ...
    (microsoft.public.sqlserver.programming)
  • Re: Hypothetical speed increase with parent/child records
    ... Yes it normally makes sense to index foreign keys. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)