You can check for the length instead of the value like this.

Declare @Header VarChar(500)

Set @Header = ' '

If DATALENGTH(@Header) > 0

print 'True'

Else

...

Rich Yarger (2/11/2011)

---

Sean, it's not a situation that will ever see more than 1 record being updated at a time (this is on a smaller sized version of our PROD...

LadyRuna (2/11/2011)

---

I have a practical example of where "Select *" fails:

Our product has a VIEW called "Customerz" defined as "SELECT * FROM CustomerTable" (view & table name changed...

You could combine the second two like this

update s

set s.clean_city = l.output_city ,

s.input_city= l.input_city from mst_Address as s

inner join digitlookups.dbo.city_lookup as l

on s.clean_country=l.city_country

and addressline5 LIKE '%' + L.input_City + '%'

where...

You should probably try joining to the inserted table instead of just getting values from it. If there is an insert that inserts multiple records at once your trigger will...

Lutz - that is exactly what I said...however yours can be interpreted by somebody other than myself. 😛 Well spoken!!!

Your project(s), clients, requirements and your desire to learn sql are the answers to that question. If you are looking for a reason not to learn sql then just hire...

WHILE EXISTS

(

SELECT top 1 NULL

FROM dbo.tmp1 TMP (NOLOCK)

INNER JOIN dbo.CTR (NOLOCK)...

Rich Yarger (2/9/2011)

---

Mike / Sean -

Thank you both. I guess there is no way to simply remove the column constraint then without having to copy the column/table to...

No worries. Just struck me as funny that we both basically wrote the exact same thing. 😛

ummm that is the same example i already posted. 😀

Sounds like CustomerID should be a parameter to the insert sproc.

It sounds like you are dead set on doing this. If you don't care about the order of columns you can do something like this.

drop table IdentityTest

go

CREATE TABLE [dbo].[IdentityTest](

[ID] [int]...

It sounds like you want to remove the identity property rather than the column itself? This can be done in tsql but like Mike said this sounds like a decision...

Suresh Kumar Madhavaraju (1/31/2011)

---

You should always include an identity key column in your tables designing. Then it doesn't matter with the type of primary key column.

Let's say you want...