How to add a new Query on your database Items_Gear?

I did't understand for add new query darabase items gear
I need you tutorial!

Quote:

---

I did't understand for add new query darabase items gear
I need you tutorial!

---

this have to became

Quote:

---

HELLO !I did't understand for add new query darabase items gear
PLEASE If someone can explaine me how can i do THANK YOU so much !

---

Start Microsoft SQL server
Open WarZ Database
Open Item Gear Table
Right click on it
New Query as -> insert into

Quote:

---

SET IDENTITY_INSERT [dbo].[Items_Gear] ON
GO
INSERT INTO [Items_Gear] (Database column) VALUES (all the value you have to put into the Items_Gear);
GO

---

Thanks! atidoti,I bad ENG!

It can't to add new Query

Quote:

---

Msg 2627, Level 14, State 1, Line 1Violation of PRIMARY KEY constraint 'PK__Items_Ge__727E83EB6BAEFA67'. Cannot insert duplicate key in object 'dbo.Items_Gear'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK__Items_Ge__727E83EB6BAEFA67'. Cannot insert duplicate key in object 'dbo.Items_Gear'.
The statement has been terminated.


(1 row(s) affected)

---

Quote:

---

Originally Posted by Namo SweetDream

It can't to add new Query

Msg 2627, Level 14, State 1, Line 1Violation of PRIMARY KEY constraint 'PK__Items_Ge__727E83EB6BAEFA67'. Cannot insert duplicate key in object 'dbo.Items_Gear'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK__Items_Ge__727E83EB6BAEFA67'. Cannot insert duplicate key in object 'dbo.Items_Gear'.
The statement has been terminated.


(1 row(s) affected)

---

Yes is normal.

Quote:

---

Violation of PRIMARY KEY -- Cannot insert duplicate key

---

Thanks atidote i get it!