You can imbed single quotes using an additional quote in the string. Your example would work like this:
insert...
select 'Gary''s Garage'
For quotes at the end of a string, you will need to add an additional quote. If you wanted "The ball is Chris'" (it is the best example i can...
I have a DTS task that uses an Active X controller step to determine if the entire routine should be executed based on the existence of records to be processed. If there are no records to be processed, the controller step sets all subsequent steps to completed and sets ExecResult to successful...
Sorry. I did over simplify a bit. The validation table will actually contain the table and field name of the validation table for each parm to be validated (ie. the validation table will contain the name of the productcode parm, the table name of the Product table and the field name of the...
I have a need to validate certain input parameters on a stored procedure. The situation is this:
The stored procedure performs an order insert. As such, it contains a number of input parameters. Some of these require data validation prior to inserting the order. The validation info is...
StLouie, thanks for the response. I don't actually get any errors whe I connect. Infact, all appears fine. It is when I attempt to access shares across the VPN, I just can't. It tells me that the network path was not found. The curious thing is that my Win2K laptop works fine. I have checked...
I have been reading these posts and am still having trouble using Extranet. I have two machines(a laptop and a desktop) at home. I am also using a cable modem. I do not have a router, so I just swap the line to switch between the machines. The laptop connects fine and has access to corp shares...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.