I would like to insert a value with an apostrophe into a character field. I keep on getting "commande text not set for command object". Is there a character that I can put before and after the string to show that the system should take the exact value and not look at the ...

I'm trying to write a query that will be used in a stored
proc to grab data from a table on a different server.
So I have SVR1 trying to get data from SVR2, so I'm trying
to use this query:

I need to strip all characters that are not a number from a string
variable in a sql procedure. There is not clear pattern to the
character the user can input.
Example input for the phone field

Could someone please tell me how to fix the following
error? This error is appearing on several tables for 2
weeks now. I already ran a complete hardware diagnostics
on the server and it is cleaned. Please help, I am

How can i create and attach a database with out using
enterprise managaer in mssql7.

I have a varchar field in a table that could contain values such as 123,
345, ABC, or CDF
I want to do a select statement on the table to return records where this
field could be number (123, 345) and exclude those that are not (ABC, CDF).

I need help in generating a query that will give me all
my DB tables and associated columns.
Thanks

Think that you have this string "1-345-456", is it
possible to check what is number in this string and how
can i remove those who isn´t a number
Thank you for helping me

Hi, All,
I need a single result set that just returns today's date
plus 6 more days.  I want to do this without a cursor.  
Any ideas?  

Below is my query where I want to see duplicate rows, but I don't
SELECT  dbo.tblItemOrder.Itemnumber, dbo.cp_IV00101.ITEMDESC, dbo.tblItemOrder.Quantit
FROM         dbo.tblItemOrder INNER JOI
                     dbo.cp_IV00101 ON dbo.tblItemOrder.Itemnumber = dbo.cp_IV00101 ...

Just wondering if someone can help me whith some data I am
trying to seperate out, the examples are shown as below
Clarice Apartment - 2 bedroom Apartment
The Beech - 4 bedroom Detached

Is there a limit on no of columns in a table. How it will affect the performance of a query. What is the optimum max no of columns a table can contain
Pls give your expert advice .

Can anyone tell me if there's a query command that will
return information about a table's properties, such as
field names, field data types, field lengths, index names,
etc?

Big problem here that is getting me frustrated
i have  TABLE A and TABEL B
TABLE A              TABLE B
ID        DATA       ID (FK to TABLE A)  DATA

I am trying to design a trigger that upon record INSERT checks the number of pallets ordere
and ensures that no record has more than 26 pallets, as this is the maximum tha
will fit onto a trailer. Some how dividing 26 into the number of pallets copying all lines with les
than 26 ...