SQL Syntax question
Hello hopefully someone will know this. When I try to import an sql file (corresponding to the Login control in chapter 4) to a host sql server 2005 database, the tool I am using is claiming that the sql file contains a syntax error
Incorrect syntax near 'END'.
I admit I know nothing about sql syntax, but I saw these strange things in the syntax could they be errors? What concerns me is the apostrof following the END. Most 'END' don't have an apostrof but some do. Could this be an error?
-------- sample 1 ---------
-------- sample 2 ---------
INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)
-------- sample 3 ---------