For more information about the site, see the
Combining two updates in one SQL statement
Executing an Oracle stored procedure in Oracle from SQL Server
Looking for I/O stats
Exporting a production DB and importing it into new development server
Translating a specific Oracle SELECT statement
Query database from VB app or SQL Server?
Certifications for Access and SQL Server
A better way to search
Problems inserting dates
Is SQL Server 2000 NUMA-aware?
Getting the error: D:MSSQL7Binnisqlw.exe is not valid
Exporting a list of images in a document
Returning a value from a stored procedure to an ASP Web page
Backing up a single table, not the database?
Determining the physical space occupied by database tables
Using a string list as a parameter in a stored procedure
Moving objects to the correct filegroup
Lock problems and slow performance
Resetting automumber fields to begin at 1
Getting information about stored procedures
Converting Access database to SQL Server
Limiting the ranges of columns returned
Query to find cities, including nearby locations
Removing duplicate records
MOD() function in SQL 7.0
Date format in SQL Server
Differences between SQL server 7 and 2000
Data from Fortran programs to SQL Server?
Validating online backups
Creating a view to retrieve data from more than one database
Displaying all of one person's phone numbers in one column
Is there a way to shrink the transaction log?
Best method to copy a database with all of its properties without data
Is it possible to execute a stored procedure in Oracle from SQL Server 6.5?
Adding data into SQL Server 7 from Visual Basic
Any equivalent to Oracle's ROWNUM?
Errors running 16- and 32-bit programs
Full text queries in SQL Server 6.5
@@identity problem on converted SQL code
Error with SQL Server driver: Shared memory; connection open
Best way to add login names and passwords to user info table
Incrementing record id without using identity
Suddenly can't view databases from Enterprise Manager
Changing interface to point from MS Access to SQL Server
System stored procedure to determine current database users
Generating a Word doc containing database info
Calling a stored procedure from a stored procedure in COBOL
What does SELECT PLATFORM() do?
Access vs. SQL Server: performance and migration issues
Triggering an update on one server from another
Help with tools to create database diagram
Order of WHERE predicates and performance
Problem getting recordset in VB from a stored procedure
What is the difference between these two queries?
Data's physical location managed like in Oracle?
Restoring a database backed up on SP1 to SP3
Importing/exporting to SAP
Can DISTINCT be used on only one field in a query?
Time data being converted unintentionally
Updating a table with a text file
Downloading SQL Server 2000 Personal Edition
Cost comparison of client servers and non-distributed systems
Not getting a result set when executing a stored procedure
Scheduling jobs to run on alternate Saturdays
SQL Server vs. Visual FoxPro
Problem with connection between IIS Web server and SQL Server
Tools for a seamless export from Oracle to SQL Server
Executing distributed queries
Sorting vs. indexing
Preventing specific hosts from connecting to SQL Server
SQL Server 7.0's interpretation of dates
Using arrays in stored procedures
Table partition support
Copying the _WA_sys indexes/statistics
Preparing for the 70-029 exam
Restoring the database only using the mdf file
Replicating and backing up logs without overwriting previous ones
Deleting the SQL Server icon
Resources for upgrading from 6.5 to 7.0
Identifying exact lock escalation and the criteria used to determine it
Future for triggers
Returning values with more than two digits to the right of the decimal point
Database not completing restore process, remaining in loading mode
Retrieving data via an HTML document through IIS
BCP utility explained
Localserver dependent on Internet connection
Microsoft SQL Learning Edition?
Checking for NULL records in all columns in Access
Creating a view between servers
Query to show duplicate customers only once
Comparing Microsoft SQL Server to Oracle
SQL Server's limitations
Moving from Access to SQL Server
Connecting Access and SQL Server 2000
Renaming instance after upgrade
Placing and retrieving comments on tables and columns
Creating installation program to create new database
Creating standby servers