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........
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?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 Bro
???
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'.
Erorr
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
Reply With Quote