Hi all,

we can pass an ADO.NET DataTable from the FRONT END application to a stored procedure which takes a TABLE TYPE as an argument.

I am putting up a sample application which...

The examples were created with SQL Server 2008. SQL Server 2005 does not support MERGE. It is available only with SQL Server 2008

You can download SQL server 2008 (KATMAI) at...

Just tried this and it works:

ON

(d.OrderNumber = o.OrderNumber AND

From my testing, i found that the triggers are always fired in the following order.

1. insert

2. update

3. delete

I am not sure if we can always assume this order.

Here is an example:

WHEN

SOURCE NOT MATCHED THEN

    --DELETE

    UPDATE

Agreed with you, Leo.

Hi Rob,

The focus of this article was to present the MERGE keyword and hence I started from where we stopped in a previous article.

There is another article scheduled, which introduces...

Hi noggin,

I had found 3 points that I must add to the above article after playing with a few real-life assignments.

1. Find the total number of records affected by the current filters
2. Support...

Hi all,

again, the source code listing does not show up well in IE. The lines are wrapped at places where they are not supposed to be.

The code shows up...

There is an execellent article by Robyn Page and Phil Factor at http://www.simple-talk.com/sql/t-sql-programming/rss-newsfeed-workbench/

The above article shows how to read a disk file using OPENROWSET + BULK

You are correct. The whole XML Workshop focuses on SQL Server 2005 only. That was the reason why I did not mention it.

The rest of the articles in the...

dinesh,

I did not notice your message until this morning (when i get into this page accidently), because this article is not yet published. It is scheduled and will be out...

Hi all,

I see that the source code listing does not wrap lines correctly in IE7. If you happened to find the same, you could try with firefox.

thanks

Jacob

Thank you Mr.Leach and Mr.Fritchey for your comments. What I like best with SQLServerCentral is the large number of DB experts who share their thoughts and experiences in the discussion...

In the worst case, i can help you out by setting up a meeting at http://www.gotomeeting.com 🙂