sqlserverdba
asked on
sql delete rows error incorrect syntax
i tried a delete as below.
"delete * from dbname.dbo.tablename"
I got the following error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '*'.
I was not sure what this was about. please help. Thanks
"delete * from dbname.dbo.tablename"
I got the following error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '*'.
I was not sure what this was about. please help. Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the split. Good luck with your project. -Jim
ASKER
Thank you!