Access and SQL server update

[Bonzol]

Hey there,, I know when updating,, Access can be differnt from SQL
server

this works in access from a vb.net 1.1 prog


SQL = "Update Clients SET UnameID= '" + updatevalue + "' WHERE ID = " +

checkValue + ""


Can anyone just quickly tell me what i have to change for it to work in

SQL server 2005?


Thanx..

 

[Stephany Young]

Nothing, but you don't need the + "" at the end for either.

 

[Cor Ligthert [MVP]]

Bonzol,

As this is VB it would be nicer to use the concationation character &
instead of the + character, with option strict of the latter can give very
strange results.

Cor

 

[Rad [Visual C# MVP]]

It will work as is, but you are exposing yourself to SQL injection
attacks as well as errors when someone passes a value like o'malley.

Try and use parameterized SQL as much as possible

 

[aaron.kempf]

I call bullshit on your shit

just because you're a retard C# dude it doesn't mean that we all want
to add unnnecessary complexity to all of our apps

go and **** yourself; C# fag

-Aaron

 

[aaron.kempf]

and for the record.. THERE IS NO RAD IN C#

lick a monkey dick bitch

You'll be obsolete also when Microsoft renames VB to VB#


-Aaron