Hi

Just take Michael Valentine Jones's fine sample and change the from_month to another value or use something like "DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)" to remove everything but the year/month of...

Hi

If you can tell us the platform (java, .net, c++, ???= you are using, I'm pretty sure anybody can show you a direction to go or even a little sample.

Greets

Flo

Hi Pam

INCLUDEd columns should be used if the additional columns are not part of the search criteria. They are especially a benefit when you work with many to many relations:

CREATE...

Hi Jose

Try to get rid of these old "sp_OA" procedures. Since SQL Server 2005 you definitely should use .NET for this kind of task.

If possible, do things like this with...

Hi

This depends on the ANSI-SQL standard which is complied here. It defines that a view's structure must not change until you change the view's DDL.

One way to do this is...

SSIS

If you don't need a real-time synchronization you can use a SSIS job to synchronize the data.

Problem: Not real-time

Handle in Client

If you need a real-time synchronization you might be able...

Hi

Have a look at the CREATE TRIGGER description. You can use an "AFTER DELETE". Within this trigger you can access a virtual table called "deleted" which contains exactly all columns...

Hi,

I don't use SQLXML, I use the .NET framework standard features from System.Data namespace.

Here two different samples:

using (SqlConnection cn = new SqlConnection("Server=.\\Sql2k8;Database=Sandbox;Integrated Security=sspi;"))

{

cn.Open();

XmlDocument dom;

...

Hi

There are different approaches to handle this. I would suggest the OUTPUT clause on SQL Server 2005:

DECLARE @student TABLE

(

Id INT NOT NULL IDENTITY(1,1)

...

Hi Paul!

Nice solution, but mcginn's XML seems to work without attributes. Sadly, SQL Server does not support the name() function (just tried).

@mcginn:

If it is an option to change the input...

Hi

In my opinion, XML support in SQL Server 2005/2008 is way better than 2000. In SQL Server 2000 you first had to create a document handle to work with. In...

SQL Server 2005 Standard Edition can handle any size of databases and it can handle more than 4 GB RAM. We use Standard Edition with 32GB RAM and databases up...

Hi

I'm not sure if you can install Enterprise Edition on XP, but why Enterprise Edition? If you used Express Editions since now, what about Standard Edition? It's way cheaper.

Greets

Flo

Hi

You cannot use nested statements like "INSERT INTO MyTable EXEC myProc", as the error says.

AFAIK there is no way to cheat this behavior. Probably you can transform one or more...

Hi

Here you can find several links posted by Paul White depending on .NET and with Web-Services:

http://www.sqlservercentral.com/Forums/Topic805754-386-1.aspx

And here you can find a little blog which shows how to generally work with...