Agreed.

For example:

ALTER TABLE dbo.tablename

DROP COLUMN Full_Name;

ALTER TABLE dbo.tablename

ADD Full_Name AS CAST(ISNULL(F_Name + ' ', '') + ISNULL(Lname, '') AS varchar(100))

-- change 100 to whatever max length you want for...

Jeff Moden (9/20/2012)

---

It is also possible that person wrote about themselves...

SomewhereSomehow (9/20/2012)

---

Actually it is...

GSquared (9/20/2012)

---

SomewhereSomehow (9/20/2012)

---

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I...

sqlguy-736318 (9/19/2012)

---

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat...

Quite true! In fact, don't start...

I think MS had that at one point but they dropped it.

In general, carefully determine rules among yourselves and

most of all, consistently follow them.

FWIW, here are my...

If you want/need EXEC() (vs sp_executesql), then you can use a temp table to return the row total:

DECLARE @sql VARCHAR(2000)

CREATE TABLE #result ( total_rows int )

SET @sql = 'DECLARE...

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT * FROM...

Sean Lange (9/19/2012)

---

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT...

Eugene Elutin (9/19/2012)

---

ScottPletcher (9/19/2012)

---

Eugene Elutin (9/19/2012)

---

...

ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and...

Eugene Elutin (9/19/2012)

---

You wouldn't...

I would use @@VERSION for that, because you can get the SQL version year, and then it's more self-evident about what you're checking:

DECLARE @isSqlServer2008 bit

SET @isSqlServer2008 = CASE WHEN...

Definitely don't use a cursor.

But you could pass all the values at once as a table-valued parameter; you just need to modify the code of the sp to handle a...

Lowell (9/18/2012)

---

i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or...