Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tripplesix369
Starting Member
1 Post |
 Posted - 2008-11-20 : 16:40:16
|
| Im trying to Enter a message that displays like this: HOLIDAY EXCHANGE POLICY:This is the INSERT function I used.INSERT INTO receipt.dbo.rcpt_footer([trantype], [tranmsg], [seqnmbr], [text])VALUES (0,2,1, 'HOLIDAY EXCHANGE POLICY;')I've tried several ways but no luck, can someone help me out. How can I enter text followed by a semicolon.Thanks in advanced!!! |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-11-20 : 23:25:22
|
| What's the error you are getting? |
 |
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-11-20 : 23:53:14
|
| Its working properly, I test samples as below:CREATE TABLE TEST (TranType INT ,Tranmsg INT ,Seqnmbr INT,Text VARCHAR(50))INSERT INTO TEST ([trantype], [tranmsg], [seqnmbr], [text]) VALUES (0,2,1, 'HOLIDAY EXCHANGE POLICY;')TranType Tranmsg Seqnmbr Text-------- ------- ------- ------------------------0 2 1 HOLIDAY EXCHANGE POLICY;What's the actual error at your end?==================================================== you realize you've made a mistake, take immediate steps to correct it. |
|
|
|
|
|
|
|
|
How can I enter a semicolon (;) into a table