Hello Ragezone World
----------------------
Can Anyone Share how to add items to Npc Manual Way.
Because The Most Query Dosn't Working
Help Me.
And Thank You.
Best Regards........
Printable View
Hello Ragezone World
----------------------
Can Anyone Share how to add items to Npc Manual Way.
Because The Most Query Dosn't Working
Help Me.
And Thank You.
Best Regards........
Are you sure about that? i added 50+ items without any error in db/client?Quote:
Originally Posted by Avira
Also i'm supporting this query
http://forum.ragezone.com/f722/add-i...-query-895322/
Means if you get some error about query you can contact with me for this problem get fixed.
Regards
RevoLand
Your E-mail BroQuote:
Originally Posted by RevoLand
???
Msg 139, Level 15, State 1, Line 0Quote:
Originally Posted by RevoLand
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Line 61
Must declare the scalar variable "@SkipScrapOfPackageItem".
Msg 137, Level 15, State 1, Line 66
Must declare the scalar variable "@SkipPackageItem".
Msg 137, Level 15, State 1, Line 71
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 76
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 1, Line 78
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 1, Line 82
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 119
Must declare the scalar variable "@SkipPackageItem".
Msg 137, Level 15, State 2, Line 132
Must declare the scalar variable "@SkipScrapOfPackageItem".
Msg 137, Level 15, State 2, Line 143
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 154
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 156, Level 15, State 1, Line 165
Incorrect syntax near the keyword 'ELSE'.
ErorrQuote:
Originally Posted by RevoLand
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Line 61
Must declare the scalar variable "@SkipScrapOfPackageItem".
Msg 137, Level 15, State 1, Line 66
Must declare the scalar variable "@SkipPackageItem".
Msg 137, Level 15, State 1, Line 71
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 76
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 1, Line 78
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 1, Line 82
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 119
Must declare the scalar variable "@SkipPackageItem".
Msg 137, Level 15, State 2, Line 132
Must declare the scalar variable "@SkipScrapOfPackageItem".
Msg 137, Level 15, State 2, Line 143
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 137, Level 15, State 2, Line 154
Must declare the scalar variable "@SkipPricePolicyOfItem".
Msg 156, Level 15, State 1, Line 165
Incorrect syntax near the keyword 'ELSE'.
Hmm, query written on sql server 2012, this explains everything :(:
ok Can you write on 2005