1. Query across servers in Microsoft SQL Server 2005

    If your organization/project has data repositories spread across more than one database server, chances are that you will eventually want to pull data from more than one server instance in a single query. If you want to perform these cross-server queries without setting up a persistent Linked Server configuration …

    read more
  2. Prepared SQL statements in VB.NET

    Thousands of websites have been hit lately by the rash of SQL injections being perpetrated en-masse. Most languages (current versions, at least) have a procedure for separating parameters from the query they augment in an effort to prevent SQL injection, and VB.NET is no different.

    Assuming you have stored …

    read more
  3. Page 1 / 1