|
The following Proc works in sql 2005/2008 , when we are testing sql server 2012 SSMS gives syntax error . How to fix this one
(comments are locked)
|
|
The following Proc works in sql 2005/2008 , when we are testing sql server 2012 SSMS gives syntax error . How to fix this one
(comments are locked)
|
Once you sign in you will be able to subscribe for any updates here
By RSS:Topics:
asked: Aug 29 '12 at 01:08 AM
Seen: 262 times
Last Updated: Aug 29 '12 at 10:44 AM
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.
Could you supply us with the error message? That normally gives a good indication of what is going wrong.
I know this is the issue but I would look this up. http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/
I don't see why you are creating objects with the underscore character. I'd see that as a risk, regardless of how the script executes.
BTW, I used this script on a test server here and it works without error
Yeah, I just tested it as far as I could and it parses fine. So there's something up. More information needed.