SQLRNNR (11/4/2013)

---

jasona.work (11/4/2013)

---

The joy and fun of migrating DBs to a new server...

Trying to get in touch with the people who need to update the application, people potentially trying to...

Chicken

hoseam (11/1/2013)

---

I need help here, I have this table, I may need to create another column I'm not sure yet.

CREATE TABLE [dbo].[Location](

[LocationID] [int] IDENTITY(1,1) NOT NULL,

[Location] [nvarchar](255) NOT NULL,

[Product_Code] [nvarchar](255)...

L' Eomot Inversé (11/1/2013)

---

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

[font="Wingdings"]Pretty sure, I don't think...

jasona.work (11/1/2013)

---

So, here's a goofy question:

What font and size do you have your SSMS text set to?

I'm trying to come up with one that I like for both readability and...

Kurt W. Zimmerman (11/1/2013)

---

Preferably I like to do all of my development on a slower box anyway. This way I can see performance related issues that are not masked...

In 2005, generate the script to create the table by using Script Table As...Create To...New Query Editor window. Then connect to your...

ix.lives (11/1/2013)

---

there is a substring_index function in MySQL, what is interesting is when I tried your code I get a syntax err msg stating "unknown column city in field list"...

Kurt W. Zimmerman (11/1/2013)

---

Are the 2 schemas the same? ...

Instead of updating the record's product_code field, why not just add a field that tracks when the row was added and another one for the last update?

The issues I see...

Mike.brickles (11/1/2013)

---

Hi

I have couple of SQL Tables with customers information the database works fine on SQL server 2005 but when doing a search when the tables are under SQL...

Richard Warr (11/1/2013)

---

So you'd replace the whole thing with

UPDATE Product SET Product_Code = Left(Product_Code,ProductID) + '-Altered';

That's still a really weird thing to do though. What is the Left(Product_Code,ProductID) bit supposed...

Ford Fairlane (11/1/2013)

---

Rune Bivrin (11/1/2013)

---

Well, good question, but the correct alternative was a bit misleading. You don't get a zero back, you get an empty result set. That's a different...

ix.lives (10/31/2013)

---

I need to parse a string in one column called "location" and copy the contents of "city,state" into 2 new columns of "city" and "state", while leaving location as...

That's one database with different files. There's still only one tempdb.