Search Results

Search found 3 results on 1 pages for 'tyguy840'.

Page 1/1 | 1 

• Problem with Access 2003 linking tables with SQL Server 2008 using ODBC

  - by tyguy840

  I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message. " 'Pk_dbo.Batch_Claims' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not to long. " Pk_dbo.Batch_Claims is the key value I see when looking at the table through SSMS. I have used Access for awhile but am somewhat new to SQL Server and connections using ODBC. Any help would be appreciated. Thanks

  Read the article

• Create Table by Copying Structure of Existing Table

  - by tyguy840

  I am trying to create a new table by copying an existing table in SQL Server 2008 using Management Studio. The existing table contains no data. I am using the following code but am receiving an error for Incorrect Syntax near AS. I am not sure what is wrong here. I am a SQL newb and any help would be appreciated. Thanks. CREATE TABLE Drop_Centers_Detail AS (Select * From Centers_Detail)

  Read the article

• Create SQL 'LIKE' Statment that looks for specific Patterns of numbers and letters

  - by tyguy840

  Is it possible to use LIKE in a SQL query to look for patterns of numbers and letters. I need to locate all records where the specific field data has the pattern (2 Numbers,1 hyphen, 3 Letters) ## - AAA I am using SSMS with SQL Server 2008. Any help would be appreciated. THANKS.

  Read the article

1