djj (4/23/2014)

---

Hello, Is there a difference in the following: DECLARE @T1 VARCHAR(50);

SET @T1 = (SELECT TOP(1) Col1 FROM MyTable); -- define variable first way

SELECT TOP(1) @t1 = Col1...

Of course, by breaking the MCM mold, Microsoft has insured that these minted certifications are now even more exclusive and valuable. 🙂

Given the cirsunstances, it's probably best to just hard code the definition of the temp table, which is the typical way of doing it. I wouldn't even dick around with...

Jeff Moden (4/21/2014)

---

Eric M Russell (4/21/2014)

---

Jeff Moden (4/20/2014)

---

Tom Brown (4/15/2014)

---

However on this particular project they don't like linked servers/openquery etc - So I don't have the Access level required...

In addition to the general advice "never stop learning", another piece of advice is "never stop browsing the job posting sites". The career advice dispensed by your mom the school...

Jeff Moden (4/20/2014)

---

Tom Brown (4/15/2014)

---

However on this particular project they don't like linked servers/openquery etc - So I don't have the Access level required - and almost certainly the...

Doctor Who 2 (4/18/2014)

---

Eric M Russell (4/18/2014)

---

Doctor Who 2 (4/18/2014)

---

I didn't know that SQL Server Developer Edition was something that one could purchase at a reduced rate. You gave the...

Today's young generation (not all of them but enough to matter) grow up with a sense of entitlement. Many get this message, perhaps inadvertently, from public schools that you get...

IMHO (4/18/2014)

---

I agree, but it's the fantasy of becoming the next Bill Gates, Steve Jobs, or Mark Zuckerberg that gets kids fired up and fills the ranks of the next...

A book on how to build video games or Facebook apps would make a good Christmas stocking stuffer for a kid, if you think they would be into that. I...

Doctor Who 2 (4/18/2014)

---

I didn't know that SQL Server Developer Edition was something that one could purchase at a reduced rate. You gave the cost in British pounds - what's...

😛

99% of newcomers entering IT looking for power and prestige...

At age 12, the only type of computing that kids are interested in is video games. If you want to tell a group of kids about your job as an...

NoSQL databases are the digital equivalent of a basement level archive with pallets full of boxes more or less organized. They typically can't function as a primary database of record...

Ian C0ckcroft (4/16/2014)

---

Hi guys, does any one have a good idea(or code) to reduce the size of live data so it can be used for dev. I have restored live...