1.
What are the main differences between Access and SQL Server? Dec 5, 2007 ... So here are some sample queries; note that the SQL Server queries ..... Access: SELECT UCASE(column) -- SQL Server: SELECT UPPER(column) ...
2.
What are reserved Access, ODBC and SQL Server keywords? Jul 18, 2004 ... What are reserved Access, ODBC and SQL Server keywords? The following table documents reserved keywords that should not be used as names for ...
3.
How do I determine if a table exists in a SQL Server database? How do I determine if a table exists in a SQL Server database? ... SELECT 'tablename exists.' ELSE SELECT 'tablename does not exist.' ...
4.
How do I monitor SQL Server performance? How do I monitor SQL Server performance? There are some Microsoft tools that can help monitor your database performance: Microsoft Operations Manager (MOM) ...
5.
Can I make SQL Server format dates and times for me? What they'd like to see is the ability to tell SQL Server to format a date with long date and time, or in MM/DD/YYYY format, instead of having to memorize ...
6.
How do I load text or csv file data into SQL Server? If you need to load data into SQL Server (e.g. from log files, csv files, ... making it easy to import files in comma-separated values (CSV), Tab-separated ...
7.
Why should I consider using an auxiliary numbers table? Mar 12, 2005 ... Besides, there are many other reasons for using a numbers table. ... However, a numbers table can help us generate this range as a set, ...
8.
How do I use GETDATE() within a User-Defined Function (UDF)? Apr 12, 2005 ... How do I use GETDATE() within a User-Defined Function (UDF)? SQL Server 2000 added the support for user-defined functions, but there are a ...
9.
Why do I get script errors in Enterprise Manager's 'taskpad' view? Sep 12, 2005 ... Why do I get script errors in Enterprise Manager's 'taskpad' view? ... How do I get rid of Named Pipes / DBNMPNTW errors? ...
10.
Why is tempdb full, and how can I prevent this from happening? Sep 12, 2005 ... SQL Server allocates a database called tempdb, primarily for worktable / #temp ... Restarting SQL Server will re-create tempdb from scratch, ...
|