Viewing 15 posts - 226 through 240 (of 3,221 total)
Thanks
Good question - have not had to use in so long - it is good to be remineded of those long forgotten operators ..
November 13, 2012 at 8:55 pm
Not truly knowing your groups background and how deep in depth you wish to go with your training, may I suggest reviewing the "SPACKLE" articles here on SSC.
Just enter the...
November 13, 2012 at 7:28 am
I suggest that you look at the MERGE statement (new in sql 2008) that said here is a good discussion with excellent examples that might be of use to you.
http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/
November 9, 2012 at 9:14 am
With the limited information you have given, I suggest that you use BOL (Books On Line) the SQL help file and look at the item titled "Merge"
or use GOOGLE and...
November 8, 2012 at 11:26 am
L' Eomot Inversé
I am indeed getting old (although I can't seem to catch up with Ron),
Seems like I will have to invoke DBCC TIMEWARP:
http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx
But I am having this problem
those...
November 8, 2012 at 10:03 am
Hmm caught me on that one with Halloween coming up in the USA tomorrow thought this was one of those joke questions ... OH well so be it
October 30, 2012 at 8:11 pm
Meow Now (10/30/2012)
October 30, 2012 at 5:40 pm
I do not have an instance of SQL Server 2000 available for checking, but you might want to test by using this:
select * from master.dbo.sysperfinfo
If you do use the above,...
October 29, 2012 at 12:00 pm
For a free tool (Microsoft's upgrade advisor) go to this link:
October 29, 2012 at 7:50 am
Here is an excellent read on the subject:
http://msdn.microsoft.com/en-us/library/aa259228(v=sql.80).aspx
Scroll down a little more than half the page to see examples.
Here is a quick example:
SET QUOTED_IDENTIFIER OFF
DECLARE @Toff...
October 28, 2012 at 5:08 pm
From the justification of what the correct answer is:
Therefore a single value in the WHERE... IN clause can be surrounded by multiple pairs of parenthesis. Multiple values cannot.
Why then...
October 28, 2012 at 7:40 am
Nice question to start the week . .. Thanks
October 28, 2012 at 7:17 am
This might do it for you:
CREATE TABLE #T(userid INT, emailname VARCHAR(50))
INSERT INTO #T
SELECT 1, 'a@a.com Bill' UNION ALL
SELECT 2, 'a@a.com Billy'...
October 26, 2012 at 2:44 pm
When designing a data base I always start in a manner that most think is backwards. That is I ask and ask again what does the user(s)...
October 25, 2012 at 11:45 am
Viewing 15 posts - 226 through 240 (of 3,221 total)