Ok in MSAccess I can send an SQL string to a server I'm connected to and as I understand it that string can contain anything.<BR><BR>Basically it would behave as if I was connected to the server ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...