How to convert to SQL command value convert to int.

Question

1.60/5 (2 votes)

See more:

I have two tables I use.

1.TABLE => temptablestudent(ıd,name,surname,class)
2.TABLE => student(ıd,name,surname,class)
Explain question
if you have different int you want to translate how many there is and want to add different ones from the temp table to the student table.
and if the tables are the same, when I press the add button, I want to compare and press add button, but not add.

ı use sqlcommand.

var x=select ıd,name,surname from temptablestudent except  ıd,name,surname from student

//how do I find the result value from type int.

if the result returns I say add larger than 0

INSERT INTO student (ıd,name,surname,class)(select select ıd,name,surname from temptablestudent except ıd,name,surname from student)

//If there is the same in the table, I want to not add the add button.in this case how do I write query

What I have tried:

I want to

I'm missing a query.

1. I cannot convert sql command x to int. //how do I find the result value from type int.

2. If the same table tempstudent with the student add button I want to add even bass.
If there is the same in the table, I want to not add the add button.in this case how do I write query

How can I do it.

Posted 31-Jul-19 12:12pm

StudentSC

Updated 1-Aug-19 5:10am

Add a Solution

Comments

MadMyche 31-Jul-19 21:36pm

Add some sample data and what you expect from that data

[no name] 1-Aug-19 0:24am

Sample data:
1 john alex

Expect data:

1 john alex

Sample data2:

1 john alex
2 mary alex

Expect data:(ınsert data)

2 mary alex

So finally student data:

1 john alex
2 mary alex

Wendelius 1-Aug-19 3:13am

Few questions.
1. Is the insert query working as expected and the only problem is to know how many rows were inserted?
2. Are you using plain SQL or using SQL inside some other programming language, like C#?
3. What database you're using, SQL Server, MySql, Oracle, ...?

[no name] 1-Aug-19 15:10pm

I use SQL.And sql language.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2019-08-01T05:10:00

I am going to rephrase your question and add in your comments so that others can follow along

I have 2 tables Student and TempStudent with identical schemas

SQL

CREATE TABLE dbo.Student (
  ID      int,
  Name    nvarchar(32),
  Surname nvarchar(32)
) ON [PRIMARY]

How do I transfer the rows from the second table (TempStudent) into the first (Student) when the record does not exist?

Sample Data #1
Student table is empty, and TempStudent table has one row:

SQL

TRUNCATE TABLE Student;
INSERT TempStudent(ID, [Name], Surname)
VALUES  (1, 'John', 'Alex)

I need the query to transfer this row

Sample Data #2
Student table should now have row#1 in it, and we have added a row to TempStudent

SQL

INSERT TempStudent(ID, [Name], Surname)
VALUES  (2, 'Mary', 'Alex)

Again, I need the query to transfer this new row to Student, but only the new row

The solution is quite simple:

SQL

INSERT Student(ID, [Name], Surname)
SELECT ID, [Name], Surname
FROM   TempStudent
WHERE  ID NOT IN (SELECT ID FROM Student)