How do you know which "CarN" apply to any particular row with NULL?

Just in case you don't know, there is no fixed order of rows in relational databases.

And you cannot...

You order by single column.

But you put into it values from different ones depending on parameter.

SQL Server converts all values in all columns to the same datatype according to its...

You missed a dot.

Here:

FROM ['+@dbFrom+'].[dbo].[KontoKort X]

One day some developer will read a conversation like this and decide it's good to use "thorn" character as a replacement for CR/LF.

He/she will agree it with other side and...

There is no guarantee "thorn" is not or will not be used within the filed for other...

Why should I?

Just build a .NET scrubber for clean up the file into...

Dynamic SQL.

Jeff Moden (10/8/2008)

---

My procedure splits ntext string. Up to 2 GB long.

It's in SQL2k.

Tested...

karthikeyan (10/8/2008)

---

Actually we (mine and my manager) new to this project. My manager has looked some procedure few days back. He is not happy with the procedure case format. He...

Jeff Moden (10/8/2008)

---

Actually, why does this need to be done in a trigger? This sounds like a process specific to a particular proc and should probably on be done...

Guys, I believe it's a good case when simple example would worth more than hours of reading.

Now for OP.

This is how your trigger FOR INSERT should look like:

Update ...

Those examples must be not about SQL Server.

indid = 1 means the index is clustered.

SELECT T1.CandidateID, 'Missing From Table 2'

FROM Table1 T1

WHERE NOT EXISTS (select 1 from Table2 T2 where T1.CandidateID = T2.CandidateID)

UNION ALL

SELECT T2.CandidateID, 'Missing From Table 1'

FROM Table2 T2

WHERE NOT EXISTS (select...

And too small.

SQL Server reads data by pages.

If your whole data set fits one page it will be 1 read, no matter is it 1k or 7k.

And this page will...