Incorrect syntax near '*'

[Mario Krsnic]

Hallo zusammen,
I have an app. with SQL-Server. The same page worked fine with Access-DB.
Now I have a problem with this command:

Dim strSQL As String

Dim myConnection As New
SqlConnection("server=mssql07.1und1.de;uid=dbo88888888;pwd=8888888;database=db88888888")

myConnection.Open()

strSQL = "delete * from tbl1 where id =" & n

Dim myCommand As New SqlCommand(strSQL, myConnection)

myCommand.ExecuteNonQuery()

myConnection.Close()

if I try to perform the command I get this message:

Incorrect syntax near '*'

What is the right syntax?
Thank you!
Mario

 

[Guest]

Howdy,

SQL server does not understand * in delete statement.
strSQL = "delete from tbl1 where id =" & n

 

[Mark Rae]

strSQL = "delete * from tbl1 where id =" & n

Remove the asterisk.

 

[Mario Krsnic]

Thank you!

Remove the asterisk.

 

[Juan T. Llibre]

Try the percentage sign ( % ).

strSQL = "delete % from tbl1 where id =" & n

The asterisk ( * ) only works in Access databases.

 

[Juan T. Llibre]

Please ignore this comment:

Try the percentage sign ( % ).

The correct statement is :

strSQL = "delete from tbl1 where id =" & n

The percentage sign works with the LIKE statement.