Viewing 15 posts - 466 through 480 (of 2,038 total)
Jack Corbett (6/30/2009)
Lynn Pettis (6/30/2009)
Bored here at work today. I have things to do, but just can't get motivated.
Glad I'm not the only one that happens to. I'm...
June 30, 2009 at 1:27 pm
JC (6/30/2009)
I was wonderig what all these databases were:AdventureWorks_Data.mdf
AdventureWorksDW_Data.mdf
AdventureWorksLT_Data.mdf
1.) Is the general AdventureWorks database
2.) Is the Data-Warehouse of AdventureWorks
3.) Is the lite (less complex) version of AdventureWorks
I don't suppose there...
June 30, 2009 at 10:26 am
Ouch...
ROLLBACK TO PREV_FUN
ALTER SNIPPET WITH (
SELECT ZIP + '-' + PlusFour AS FullZIP
FROM [Address]
WHERE PlusFour IS NOT NULL
UNION ALL
...
June 29, 2009 at 4:09 pm
Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
:hehe:Lynn, refresh the page and look at my post above yours.
:blush:
😛
June 29, 2009 at 3:58 pm
SET FUN ON
Or, a UNION ALL if you generally don't like functions in your SELECT clause.
SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP
FROM [Address]
...
June 29, 2009 at 3:56 pm
GilaMonster (6/29/2009)
The cross join in the subquery?
Dang! I stopped reading the code after the issues I posted...
June 29, 2009 at 3:48 pm
Gift Peddie (6/29/2009)
Check the thread below I have attached a current copy of Northwind 2008 in .bak you still need to alter NText and Image column to NVarchar(max) and Vabinary(max).http://www.sqlservercentral.com/Forums/Topic672990-263-3.aspx
Thanks,...
June 29, 2009 at 3:22 pm
Uh... Sorry, folks! Didn't see that the discussion about the UPDATE-thread is ongoing here.
June 29, 2009 at 3:18 pm
Seems there are actually two or three errors in your code.
First: The error you posted (the less important):
The sub-query seems to return more than one row to take as UPDATE...
June 29, 2009 at 3:13 pm
AdventureWorks is the better choice in my opinion. It's more complex than Northwind but it covers much more features of SQL Server 2005 and many samples in BOL (Books On...
June 29, 2009 at 12:15 pm
Matt Miller (6/29/2009)
(cynicism alert)....seems awfully interesting that was the very first post from the OP....
(/cynicism alert)
Page is down now 😉
Edit: Didn't see Rajesh's post.
June 29, 2009 at 12:09 pm
Jack Corbett (6/29/2009)
June 29, 2009 at 12:07 pm
June 29, 2009 at 8:45 am
Gianluca Sartori (6/29/2009)
GilaMonster (6/29/2009)
June 29, 2009 at 8:32 am
There are two really good articles by GSquared which describe different ways of auditing:
http://www.sqlservercentral.com/articles/Auditing/63247/
http://www.sqlservercentral.com/articles/Auditing/63248/
Just search articles on this site to find many different solutions.
June 29, 2009 at 6:04 am
Viewing 15 posts - 466 through 480 (of 2,038 total)