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

Popular posts from this blog

sql - invalid in the select list because it is not contained in either an aggregate function -

Angularjs unit testing - ng-disabled not working when adding text to textarea -

How to start daemon on android by adb -