python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - sqlcommand

Unable to insert data from the JSON in to the SQL server table

I am trying to create a SSIS package that makes a call to the REST API and insert the responses into the Azure SQL server table. For this I am using the script task and ADO.NET connection manager. The...
test-img

user4912134

c#

sql-server

ssis

sqlcommand

script-task

Votes: 0

Answers: 1

Latest Answer

Your primary issues is an extra comma in the SQL, which is a syntax error. It's probably easier to just pass the whole JSON to SQL Server and shred it using OPENJSON var result = await response.Conten...
test-img

Charlieface

How do I add a Calculated [bit] Data Type field to a SQL Table?

I would like to add a [bit] field that is calculated from a Boolean [int] field SQL Table looks as follow: CREATE TABLE [dbo].[AutoIndexBoolean]( [RowID] [int] NOT NULL, [Boolean] [int] NULL, ...
test-img

Evan

sql-server

sqlcommand

Votes: 0

Answers: 1

Latest Answer

You need to CAST/CONVERT the value returned from the CASE expression. You could likely do this as short as the following: ALTER TABLE dbo.AutoIndexBoolean ADD BooleanBit AS TRY_CONVERT(bit,Boolea...
test-img

Thom A

LINQ select duplicate object values

I have a table: Name | account info| AccountNumber -----| ------------| ------ abc | IT | 3000 bdc | Desk | 2000 sed | Kitchen | 3000 afh | work | 4000 hsfs | home ...
test-img

Jeff

linq

asp.net-core

model-view-controller

sqlcommand

Votes: 0

Answers: 3

Latest Answer

using System; using System.Collections.Generic; public class Ent { public Ent(string a, string b, string c) { name = a; location = b; id = c; } public string na...
test-img

Phillip Ngan

Linq query С# ASP.NET Core

I'm executing a sql script using: SqlCommand command = new SqlCommand(sqlQuery, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if(reader.HasRows) { while(reader.Rea...
test-img

Jeff

linq

asp.net-core

model-view-controller

sqldatareader

sqlcommand

Votes: 0

Answers: 1

Latest Answer

Assuming 1000 is always the base for the reference number, and it will never exceed 1999, then you could do something like: var referenceNumberBase = 1000; if(reader.HasRows) { while(reader.Read())...
test-img

Mateus Schneiders

Posts

Questions

Blogs

Jobs