Not to be picky but the T-SQL in answer #2 is:

Now notice the single quotation marks surrounding 10/10/9999.

Executing the statement...

Did below, while rbarryyoung was posting a better answer then I had:

Look in BOL at data available in these system views

sys.allcolumns

sys.objects

sys.columns

sys.tables

and "Querying the SQL Server System Catalog FAQ" (Yes this...

Your answer to Jeff Moden's question

Does not agree...

Modified your T-SQL to be a select rather than a delete for testing purposes only (eliminated the typing error of "where WHERE") and did not get the desired result:

Here is...

Steve this...

Starazam a somewhat theoretical question for you.

What happens, how are you informed if a Store stops selling a product - how do you delete that (if you must) from the...

I believe you have to use a two step procedure

1. Update existing values:

IF EXISTS(SELECT p.ProductName,p.StoreName FROM Products p, temptable t

WHERE p.ProductName = t.productname AND p.storename =...

Need a lot of additional information.

1. What consitutes an updatable row ... comparing one columns entry, multiple columns in temptable with what columns in "originalTable"

2. Supply if...

Using BOL partial definition of column in sys.sysobjects

Name Type Descripition

uid smallint Schema...

Try this to determine if it gives you enough information, using any database on the server (preferably a development db NOT a production db

CREATE TABLE ##MyTempTable (cola INT PRIMARY KEY)

INSERT...

Steve thanks for an eye opening question. Never knew nor would I ever find out about the "some / any" operators.

Now answer the following question: ...

My question is why do you want the tables columns created in a specific order? When you write a select statement the columns are returned in the sequence that...

What you are asking can be quite a complex task, especially if application code is using dynamic SQL statements in lieu of stored procedures. That said might I refer...

Developer edition available from Amazon.com

http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Daps&field-keywords=sQL+Server+developer+edition&x=18&y=18

for 44.95 and will ship next day if you elect to do so.

Did same and found it easy to install, once installed go to Microsoft...

Jeff Moden,

Jeff tried to send you a PM, but was not allowed to do so said something about you have too many of them.

Just...