Search: openrowset

More Results

Sort by: Relevance | Date

  • Using the OPENROWSET function in SQL Server

    Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access. Tip   |   SearchSQLServer.com

  • Basic SQL Server security best practices

    Editor's note: This article is the fourth and final in an ongoing series on SQL Server security. Be sure to check out parts... Feature   |   SearchSQLServer.com

  • Why SQL Server security matters: A case study

    Editor's note: This is the first of a four-part series on SQL Server security. Please check back next week for the next chapter.

    Database backups are stolen. Viruses attack servers. The database has unauthorized changes.... Series   |   SearchSQLServer.com

  • Six SQL bulk copy command gotchas

    The bulk copy tool (BCP) is one of SQL Server’s mainstay command-line tools -- a very handy and somewhat underrated way to import and export massive amounts of data... Tip   |   SearchSQLServer.com

  • Top 10 SQL Server tips of 2009

    Before you say goodbye to 2009, take a look at the top-rated SQL Server tips of the year, with pointers on using functions like OPENROWSET and FILESTREAM, information on password cracking tools, and advice on a few DBA tasks that... Misc   |   SearchSQLServer.com

  • Processing XML files with SQL Server functions

    Since the release of SQL Server 2000, processing XML data has been a topic of discussion among database administrators. It is often used when a front-end application passes an XML document to a stored procedure within an input parameter.... Tip   |   SearchSQLServer.com

  • Date, time and number data types in SQL Server

    SQL Server supports two T-SQL data types for storing date and time:

  • datetime
  • smalldatetime

    The main difference between these two data types is in the amount of space they occupy. datetime... Tutorial   |   SearchSQLServer.com

  • Port scanning for SQL Server services

    Book Excerpt   |   SearchSQLServer.com

  • Query works fine in Query Analyzer, but error via ASP

    I'm having a problem executing a query on SQL Server 2000 via ASP. My problem is simple: I am able to execute the query within Query Analyzer without any problems, but when the same statement is executed via the ASP code I... Ask the Expert   |   SearchSQLServer.com

  • Connecting Access and SQL Server 2000

    How do I connect Microsoft Access to SQL Server 2000?

    You just have to link the server where the database resides, and with correct permissions, you'll have access to the entire database. Run the Query Analyzer... Ask the Expert   |   SearchSQLServer.com

Search Again: