Alex-668179 (4/1/2012)

---

@ Andre Guerreiro Neto

I am not always in line with the consensus here (as you can see from my earlier posts) but I'd say yes.

For example I might...

IgorMi (4/1/2012)

---

--SQL 2012

CREATE TABLE [dbo].[test](

[int] NULL

)

CREATE SYNONYM [dbo].[

] FOR [mytestdb].[dbo].[test]

GO

Alter table test

Add j int null

--================

After scripting the table, the result is following

CREATE TABLE [dbo].[test](

[int] NULL,

[j] [int] NULL

)

I just...

Jeff Moden (3/31/2012)

---

Dang... I forgot about a very old trick for this because I haven't had to use it for years. The following code will demonstrate...

<snip>

Just keep in mind...

nicoalmontec (4/1/2012)

---

1- I created tbl_Address and inserted all distinct addresses, which gave me around 4 million records.

use tbl_newPeople

INSERT INTO tbl_address(street, house#, building, floor, city, state)

select distinct street, house#, building,...

Irresistible!!! El Jerry Can? Or can't he?

and little ladders

Nice easy question, thanks.

I spent a liitle time poring over it looking for some liitle snag that could make 2 the wrong answer; but then I remembered there was a...

Lynn Pettis (3/29/2012)

---

Anybody know whst the acronym vWOC means? I hate email letters that fail to define terms and then go to a questionnaire page before you can even get...

Sergeant

SQLRNNR (3/27/2012)

---

Stewart "Arturius" Campbell (3/27/2012)

---

Great question, Ron

thanks

As to who creates views with "SELECT * FROM...":

we recently had a vendor app breaking due to schema changes to the underlying tables (an...

MysteryJimbo (3/29/2012)

---

Revenant (3/28/2012)

---

The British...

You won't say that when management (ie sales) tells you that they're selling your system on the basis that the customer can use a 1Gbyte pen...

Sickly (and fattening)

Another 2012 question.

This could be getting educational: this one made me read some new bits and learn some new things.

Evil Kraig F (3/28/2012)

---

While we're at it, how the heck did England and America end up with two definitions of a ton? Wait, don't answer that today, I'm not sure...