Viewing 15 posts - 106 through 120 (of 667 total)
Chad Crawford (5/29/2013)
If you go to Crucial.com, you can either enter your mfg/model or use their tool to scan your laptop and they will tell you exactly what type...
May 29, 2013 at 9:30 am
Chad Crawford (5/23/2013)
May 23, 2013 at 4:56 pm
Edit: Oops, quoting the wrong post...
May 23, 2013 at 4:44 pm
ScottPletcher (5/21/2013)
This should "turn off" the identity property:
SELECT *
INTO dbo.newtable
FROM dbo.table
UNION ALL
SELECT TOP 1 (*)
FROM dbo.table
WHERE 1 = 0
Nice one, Scott! Need to remember this.
May 22, 2013 at 3:14 am
L' Eomot Inversé (5/20/2013)
... one originally Windows 2...
Wow, someone else who remembers Windows 2.0. Second piece of software I got to write for my then-employer was for Windows 2.0. Read...
May 20, 2013 at 10:46 am
Brandie Tarvin (5/20/2013)
... I just hope the Win 8 upgrade I bought allows me a free 8.1 upgrade. I'd hate to spend the money twice.
May 20, 2013 at 8:31 am
BTW, personally I would find it much more intuitive to work from the left-hand side, where that one would be the one where I'd expect to have more new rows....
April 22, 2013 at 4:06 pm
Vertigo44 (4/17/2013)
I think I got it using a full outer join.
Yes, it would, but it is not necessarily quite the thing you want, unless you want to see all the...
April 22, 2013 at 3:59 pm
Apart from what Sean said (i.e. the missing DDL, which is basically table create statements plus some INSERT statements of sample data to create your scenario), I assume you also...
April 22, 2013 at 3:26 pm
...Don't mind the goldfish...
Now we eventually know what that avatar of yours represents 🙂
April 22, 2013 at 2:42 pm
Agree with Hugo (again), but then again I should have read the question properly and wouldn't have a red cross next to my answer. 😛
April 15, 2013 at 1:42 pm
Lynn Pettis (4/11/2013)
This really makes one want to help, doesn't it.
Dunno, but it really looks like he was dumped into getting this job done.
April 11, 2013 at 11:10 am
Something like this?
CREATE TABLE myTable
(
ColA int NOT NULL,
ColB varchar ( 10 ) NOT NULL
);
GO
INSERT INTO myTable ( ColA, ColB )
SELECT COALESCE ( MAX (...
April 10, 2013 at 1:27 am
mister.magoo (4/9/2013)
...extra thought: were you maybe installing a feature that was not compatible? I just installed the engine and management tools...
No, it didn't get to the point where one...
April 10, 2013 at 12:16 am
opc.three (4/9/2013)
I agree, it ought to work unless they are repositioning SQL Server away from Enterprise use and moving more towards Home use 😀
😀 indeed!
April 9, 2013 at 1:22 pm
Viewing 15 posts - 106 through 120 (of 667 total)