Special Character Insert int SQL Server

Question

Hi. my problem is, how to insert into the special characters like I ' m ('),. please tell me. and how to create CRUD program Angularjs + SQL server + IIS using sublime text?

Ravi Kiran Chanduri · Answer

Hello Rupesh, For your first Question , to insert single quotation (') you have to use it 2 times. For example : we have to insert name Kevin o'brien for this , Query will be as follows Insert into Tab1( name ,age) values ( 'kevin o' 'brien' ,35) For your second question , You would like to call SQL from Angular Js ? Well, it is not possible to call sql server from Angular js as it is a client side scripting language. To Achieve this, you have to use server side scripting like c# coding or You can use Node js too. To code Angular js with Sublime text editor , here is the link https://dzone.com/articles/input-typequottextquot-busted

Rupesh N · Answer

Ravi Kiran Chanduri, Thanks for reply. i am asking insert application. in backend . means design asp.net to create 3 textboxs 1st textbox = name 2nd textbox=email 3 rd textbox (multiline) = discription. in backend insert into table name values('"+textbox1.text+"','"+textbox2.text+"','"+textbox3.text+"'). how to insert special charecters in 3rd textbox ?

Special Character Insert int SQL Server

Answers (2)