I prefer to use COALESCE in all cases. However, up to this, the only major difference I saw was the fact that ISNULL could be used in calculated columns for...

If you look at the script you will find some lines that look like:

sServer = "(local)"

sDatabase= "pubs"

That means that as a sample it makes the assumption that the...

I don't mean to sound like I am getting short with you but I am going to ask this again:

Have you run the attached script?

When you use these objects there...

Give it a try and see what happens. I am sure it makes separate files for triggers. As for date and time stamps, I am not certain what you are...

Are you saying that you ran the posted script and got this behavior, or are you saying that you are trying to do the same thing some other way and...

I couldn't figure out how to remove the previous post. The answer to which is found

http://www.sqlservercentral.com/articles/ADO/article4/516/

However, my post didn't display correctly anyway because of all the angle brackets...

mish_b20 (6/4/2008)

---

Hello ,

In order to see if the tables aren't identical you don't have to make so sophisticated script.

My suggestion to you is like this :

declare @data table(...

declare @junk varchar(20)

declare @dejunk varchar(20)

declare @clean varchar(20)

set @junk = char(160) + char(160) + 'a' + char(160) + char(160) + 'b' + char(160) + char(160) +...

If you want to doit based on what is in the table and have an arbitrary number of columns then I just answered that one in another thread:

http://www.sqlservercentral.com/Forums/FindPost481696.aspx

Sorry, I didn't see the other two pages of response before I posted.

Ok, how about this (and what do I win?):

declare @Dating table

(

Date varchar(25)

)

insert into @Dating

select '01/JAN/2008'

union all

select '02/JAN/2008'

union all

select '03/JAN/2008'

union all

select '04/JAN/2008'

union all

select '05/JAN/2008'

declare @cmd varchar(8000)

declare @comma varchar(1)

declare @num int

set @comma...

How about:

1. If it is patentable apply for a patent write your contract such that it required them to protect your IP and then charge accordingly

2. Sell them the rights...

nithyapoy (4/7/2008)

---

Hi,

i have Table Name Country with field Country_id and Country_Name.

Country_IDCountry_Name

4 US

2 ...

Take a peek at this:

http://www.sqlservercentral.com/scripts/Administration/61813/

Of course the main sproc that you are looking for in the article is

sp_table_validation

It will tell you if they are different but not...

I wrote a nice little tool in vbscript that does exactly what you want (or you can tweak it accordingly). Try here, let me know if I can help further.