how to insert this value? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to insert this value?

Author

Topic

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2009-04-22 : 04:49:01

please help me to make insert statement below will working

insert into tblPayer(ID,Nme)
values(34,'mas'od')

Nme=mas'od got problem

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-22 : 04:50:29

insert into tblPayer(ID,Nme)
values(34,'mas''od')

E 12°55'05.63"
N 56°04'39.26"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-22 : 05:05:37

Also refer why you need to double it http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx

Madhivanan

Failing to plan is Planning to fail

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2009-04-22 : 07:09:28

TQVM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-22 : 07:22:44

quote:
Originally posted by Delinda

TQVM

Is that "Thank You Very Much"?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources