SQL insert statement with carriage return or line feed -
i have question on sql insert statement. looking way insert string carriage return or line feed.
for example,
if run code:
insert table (description) values ('this description' , 'updated description.')
but not possible in sql there error.
if there string like:
this description. updated description.
how insert carriage return , line feed remains?
is there ways it? or need replaced system identifiable character?
thanks help.
to insert string asking for, do:
insert table (description) values ('this description. updated description.');
if have disregard example , guess asking, (depending on rdbms-provider, guess mssql):
insert table (description) values ('this description.' || chr(13)|| chr(10) || 'updated description.');
Comments
Post a Comment