Register for your free account! | Forgot your password?

Go Back   elitepvpers > Coders Den > Web Development
You last visited: Today at 00:34

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

Advertisement



need help in sql query

Discussion on need help in sql query within the Web Development forum part of the Coders Den category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2014
Posts: 22
Received Thanks: 3
need help in sql query

hi everybody,

i need a sql query that works in mssqlServer

the query is to get a difinite number like

update dbo.1 set id = 0 where dbo.1.number = dbo.2.number

got me?

i need to set value in table 1 in column "id" = 0
where the value in column "number" in table 1 == the value in column "number" in table 2
and i want to inform the query a difinite value of dbo.2.number
warzned is offline  
Old 05/22/2016, 22:40   #2
 
KingDingD0ng's Avatar
 
elite*gold: 11
The Black Market: 103/0/0
Join Date: Jun 2011
Posts: 1,847
Received Thanks: 141
Why are you trying to change the id? If this is your primary key and it's auto incremented, you shouldn't change it at all.

Greetz
KingDingD0ng is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[Release][Query] Query _InvCOS Items WITH _Char Connection
12/29/2015 - SRO PServer Guides & Releases - 1 Replies
Ok, so i needed to write this query for a procedure im working on and not many people know how to connect the pet inventory table to the character table.... so this query will explain how its done... im not going to explain every single detail, like how there is no charcos when pet is despawned / dead... but yea you can probably figure that all out from this query... The code... USE SELECT pet_invo. ,pet_invo. PetSlot
Some Useful query
12/30/2011 - SRO Private Server - 5 Replies
Hello, Let's Start Some useful queries which could help u in edit the tables or databases data more fast and easier , UPDATE dbo._RefObjChar SET DefaultSkill_1=33266 WHERE CodeName128 LIKE '%P2SKILL_INNATE_ASS%' this will update=edit at _RefObjChar table, the DefaultSkill_1 column to value 33266 WHERE=which CodeName123 this column LIKE=much the '%P2SKILL_INNATE_ASS%'=the column data which u need to edit DefaultSkill_1 at it's row well %=accept any more work before P@SKILL and the one...
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's für Alteklinge, Reichsklinge &' Strichdolche Why? Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab ... not more -.- Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's



All times are GMT +1. The time now is 00:34.


Powered by vBulletin®
Copyright ©2000 - 2025, 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 ©2025 elitepvpers All Rights Reserved.