How to use subquery in Insert statement in SQL Server

jamess

SOLVED CLOSED ACTIVE ANSWERED
User: jamess
Posted: on Sep 25, 2014 05:38 AM
Forum: SQL Server
Answer: 2
Views: 3304

I'm trying to insert customer ID(CustID) from customer table to sales table instead of customer name. can i use something like this:

Dim cmd As New SqlCommand("Insert INTO Sales(Net,VAT,TaxBase,Change)" _
          & " (Select CustID from Customer where FirstName='fuge)Values(@Net,@VAT,@TaxBase,@Change @CustID)", con)

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 6

Reply
ANSWER
User: Azim
Replied: on Sep 26, 2014 01:49 AM
Report

You need to use VARCHAR (50) Data type. Problem is that you have defined Table Column data type as text null so you need to change it to VARCHAR (no of characters) data type.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to use subquery in Insert statement in SQL Server

Company

Explore

Follow us

Contact Us