Probably in most cases I can do that, but in some cases we have large wide columns (VARCHAR(4000) or so), and so I don't think I could do that in...

upstart (10/15/2010)

---

Changing the column type as you indicated should not produce any issues, so long as the data currently there fits into the new datatype.

Whenever you alter the structure of...

Interesting point, Steve. When it comes to public safety and/or health, one cannot be too careful.

BTW, loved the cat in your video of this post. 😉

I found that I had to set the IDENTITY_INSERT to ON, before I did the INSERT. Then I turned it back off again, which is the default.

To make it...

I've got a question. In Method 2, you've got:

CREATE TABLE DESTINATION_TB(

ID INT IDENTITY(125006,1) NOT NULL ,DATE DATETIME ,COST MONEY)

INSERT INTO DESTINATION_TB (ID, DATE, COST) SELECT...

My problem is I can just about guarantee that most of...

Lowell (9/27/2010)

---

the problem is unless you have your own SMS service, you can't do SMs messages to cell phones;

while every carrier has a supprt email that allows an email to...

LutzM (9/27/2010)

---

If you're talking about sending an email using SQL Server you might want to look up sp_send_dbmail in BOL.

If your system is not configured yet to send mails, you...

Having SQL skills, as a developer, is in my opinion essential. Well, perhaps I should say depending upon your work environment. I work in a small, departmental sized...

Good article, Steve. I remember that phrase, "computer programmer", too, and like you, I haven't heard it used in a coon's age. I'm currently a developer, or at...

Thank you for your response, Steve. My friend, Dave that I referenced in my reply, is one who does his best to remain current. Silverlight is a technology...

Over all, and generally speaking, I agree with your article, Steve. However, Dave Campbell, a good friend of mine, who is a developer and a MVP in Silverlight, has...

No, I haven't tried upgrading yet.

Thank you, nigel!

I don't understand everything you've done in the SELECT statement, Mike01, but it looks like that will work. Thank you!