Saving Text with special character into SQL Express table

Hi, fellows!

When I need to save a text into a SQL Express table I use the character ' to encote the text. (ex: 'myText' )

How to procedure when the text has already the character ' ? (ex: how to enconte the text Color's car ) ?

Many thanks to any kind of help!

Using a INSERT / UPDATE Script you will have to double quote it:

INSERT INTO SomeTable(SomeColumn)
VALUES('Jens''s')

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Many thanks, Jens!

SAN question

Hi,
are there any special considerations from the database point of view if one is working on a SAN. I wouldn't expect so but thought I'd ask as I'll be in this situation soon.
TIA,
Fred
Once installed and configured SAN should be pretty much transparent to SQL.
Getting the optimum configuration (assignment of logical volumes to physical
devices; RAID levels; placement of data and log; etc) is the most important
consideration. Unfortunately there aren't many general rules for SANs
because every manufacturer's system is different. Talk to the vendor and
listen to their recommendations for running SQLServer on their hardware.
Then test out their suggestions.
David Portas
SQL Server MVP

SAN question

Hi,
are there any special considerations from the database point of view if one
is working on a SAN. I wouldn't expect so but thought I'd ask as I'll be in
this situation soon.
TIA,
FredOnce installed and configured SAN should be pretty much transparent to SQL.
Getting the optimum configuration (assignment of logical volumes to physical
devices; RAID levels; placement of data and log; etc) is the most important
consideration. Unfortunately there aren't many general rules for SANs
because every manufacturer's system is different. Talk to the vendor and
listen to their recommendations for running SQLServer on their hardware.
Then test out their suggestions.
David Portas
SQL Server MVP
--

SAN question

Hi
are there any special considerations from the database point of view if one is working on a SAN. I wouldn't expect so but thought I'd ask as I'll be in this situation soon
TIA
FredOnce installed and configured SAN should be pretty much transparent to SQL.
Getting the optimum configuration (assignment of logical volumes to physical
devices; RAID levels; placement of data and log; etc) is the most important
consideration. Unfortunately there aren't many general rules for SANs
because every manufacturer's system is different. Talk to the vendor and
listen to their recommendations for running SQLServer on their hardware.
Then test out their suggestions.
--
David Portas
SQL Server MVP
--