AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sql server insert12/4/2023 ![]() So, getting to my question you mentioned I would be able to use VB and ADO to do the conversion for me. I say that because in instances like this it is very hard to predict and can be dependent on coding convention. It was quit fun to write and I think it will cover the almost all instances. Well, I have my function working that will validate string parameters in a SQL statement. ![]() For example, if you use Access, ASP VB etc in combination with ADO, you can use Stored Procedures and Command objects which will take care of the conversion. ![]() This will insert the name O'Larry's into the database.Īlternatively, you can use your technology to do the escaping for you automatically. Code: INSERT INTO Users (Name) VALUES ('O''Larry''s')
0 Comments
Read More
Leave a Reply. |