Register for your free account! | Forgot your password?

You last visited: Today at 15:42

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Helpful Queries Volume 1

Discussion on [Release] Helpful Queries Volume 1 within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
Gidzy's Avatar
 
elite*gold: 0
Join Date: Mar 2015
Posts: 402
Received Thanks: 154
Post [Release] Helpful Queries Volume 1

As the titles says some Helpful queries made by me and some other people i found them online and (Mr.X)

I will be posting new queries every couple weeks
P.S : i know some of them are old A.H but this might be helpful for newbie
Download from Attachment
Scan result :
Attached Files
File Type: rar Helpful Queries.rar (14.9 KB, 99 views)
Gidzy is offline  
Thanks
4 Users
Old 12/29/2015, 21:56   #2
 
elite*gold: 2
Join Date: Aug 2011
Posts: 833
Received Thanks: 1,130
Why would you use IDENTITY_INSERT when adding rows to refobjcommon ? or any table ? Thats serious risk for ID overlap

Try using @@IDENTITY in the future..
Timlock is offline  
Old 12/29/2015, 23:43   #3
 
Gidzy's Avatar
 
elite*gold: 0
Join Date: Mar 2015
Posts: 402
Received Thanks: 154
Quote:
Originally Posted by Timlock View Post
Why would you use IDENTITY_INSERT when adding rows to refobjcommon ? or any table ? Thats serious risk for ID overlap

Try using @@IDENTITY in the future..
Some of those queries i just found them online
I don't use that. anyways thanks for caring ^^
Gidzy is offline  
Old 12/29/2015, 23:56   #4
 
xaladim's Avatar
 
elite*gold: 0
Join Date: Feb 2011
Posts: 106
Received Thanks: 3
gj man
xaladim is offline  
Reply

Tags
helpful.quereis


Similar Threads Similar Threads
[RELEASE] VSRO v1.188 improved Log queries
03/16/2015 - SRO PServer Guides & Releases - 14 Replies
_AddLogChar: /** author : syloxx created date : 2015-03-11 description : Log players activities. return value : 0 = There is no error. 1 = The transaction is in an uncommittable state. Rolling back transaction. **/
[Release] 2 small queries
12/18/2014 - SRO PServer Guides & Releases - 17 Replies
Adding total 254 lines in _RefHWANLevel DECLARE @lvl varchar(5), @titlech varchar(100), @titleeu varchar(100) SET @lvl = 7 WHILE (@lvl < 255) BEGIN SET @titlech = 'UIO_SECOND_HWAN_CH_NAME_LEVEL_' + @lvl SET @titleeu = 'UIO_SECOND_HWAN_EU_NAME_LEVEL_' + @lvl
[Release] Useful queries for some people (Part I)
08/31/2013 - SRO PServer Guides & Releases - 14 Replies
If you want certain character's mastery's at a certain level.. Input their name here, and set their skill level you desire. USE GO --by Evo Declare @CharName Varchar (64) Set @CharName = 'BlackBerry'
[Release] Einige SQL Queries
06/30/2012 - Flyff PServer Guides & Releases - 6 Replies
So Release hier mal paar queries die ich aus langeweile mal gemacht hatte. Feedback und http://www.elitepvpers.com/forum/images/elitepvper s/buttons/post_thanks.gif gern gesehen^^ Items finden (per Item-ID bzw. Unique-ID) DECLARE @item VARCHAR(32) SET @item = '21' --------------------------------- -- AB HIER NICHTS MEHR ÄNDERN! --
[ePic-ReLeAsE] Mob Queries ( 359 )
08/14/2009 - CO2 PServer Guides & Releases - 9 Replies
i aint releasing anything anymore,



All times are GMT +2. The time now is 15:42.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.