Viewing 15 posts - 3,076 through 3,090 (of 3,221 total)
Not to be picky but the T-SQL in answer #2 is:
Select EmpName, DateOfLeaving from Employees order by isnull(DateOfLeaving,’10/10/9999'),EmpName asc
Now notice the single quotation marks surrounding 10/10/9999.
Executing the statement...
June 23, 2008 at 8:07 am
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...
June 22, 2008 at 7:52 pm
Your answer to Jeff Moden's question
No, temp table don't contain all records of orgininal table. it contains new inserted records + some of existing record with updated values.
Does not agree...
June 22, 2008 at 7:23 pm
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...
June 22, 2008 at 11:50 am
...but what I'd like to see a couple more years of support for each version, perhaps 7 years, so that a company can really get value for their investment.
Steve this...
June 22, 2008 at 10:20 am
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...
June 22, 2008 at 9:35 am
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 =...
June 21, 2008 at 12:18 pm
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...
June 20, 2008 at 3:55 pm
Using BOL partial definition of column in sys.sysobjects
Name Type Descripition
uid smallint Schema...
June 20, 2008 at 3:44 pm
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...
June 20, 2008 at 3:19 pm
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: ...
June 20, 2008 at 9:00 am
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...
June 18, 2008 at 8:04 pm
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...
June 17, 2008 at 4:25 pm
Developer edition available from Amazon.com
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...
June 17, 2008 at 11:46 am
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...
June 15, 2008 at 3:39 pm
Viewing 15 posts - 3,076 through 3,090 (of 3,221 total)