Ask Question

Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all Microsoft SQL Server editions including Compact, Express, Azure, Fast-track, APS (formerly PDW) and Azure SQL DW. Do not use this tag for other types of DBMS (MySQL, PostgreSQL, Oracle, etc.). Do not use this tag for issues on software and mobile development, unless it is directly related to the database.

319,644 questions 2

-2votes0answers9views

I have a problem while creating post req using mssql nodejs empty values ​are sent to SQL Server tables

router.route('/orders').post((request, response) => { let order = { ...request.body } dboperations.addOrder(order).then(data => { response.status(201).json(data); }) }) ... user avatar Mahmoud Adel

  • 1
0votes0answers13views

SQL Execution Plan Assistance

Good day... I have a stored procedure running on an Azure SQL Database that is taking 50 minutes to complete. The DTU's max out to 100% while the SP runs, but I do not want to add DTU's to my ... user avatar Garry B

  • 209
0votes0answers9views

SQL Failover Cluster - 'SQL Server' service terminating because of 'fatal exception c06d007e' [migrated]

I have an SQL Failover cluster (2016) with 2 VMs. The 'SQL Server' service was down when seen from 'Failover Cluster Manager'. On checking the Event Viewer logs, the SQL Server showed below error. ... user avatar Karthikeyan Narayanan

  • 1
-3votes0answers18views

Conditionally aggregate rows in SQL Server

Consider the table below: master location locob tb expdep year m1 A 88 85 74.8 2018 m1 B 117 85 99.45 2018 m1 C 110 85 93.5 2018 m1 D 20 85 17 2018 m1 E 127 85 107.95 2018 m1 F 1653 85 1405.05 ... user avatar Question

  • 9
0votes1answer35views

DELETE from table1 the matching rows that are in table2 (no primary key in table1)

Table1: StudentId (nvarchar(50)) Score (int) abc 56 def 34 abc 95 Table2: MemberId (nvarchar(50), no duplicates) ComputerId (nvarchar(50)) ClassId (int) abc abc9119e-91d1-4205-8efe-ee87b7baa71 ... user avatar Zuzi Mufu

  • 53
0votes0answers11views

How to update a large SQL Table column using values from a Pandas dataframe? [duplicate]

I have the following table from a SQL Server database, which contains 2 million rows: primary key column1 First Null Second Null ... Null Last Null My task is to update column1 using values from ... user avatar Matthew

  • 1
-1votes0answers17views

Could someone provide feedback on our current database design based on our planned future projects? [closed]

My team and I are new to database design and are looking for some feedback on how we have built our tables and how we should build them in the future. We have multiple vendor master pricing tables ... user avatar ChesChang34

  • 1
-3votes0answers16views

SQL Query to Filter out data [closed]

I have a data file from which data needs to be filtered. The data feed have a column and which have value with a mix of numbers and alphabets. I need a query in such a way that if the third value is 1,... user avatar Deeksha

  • 1
0votes1answer17views

Python SQL Server Insert statement works for int values but not for varchars/strings [duplicate]

I have created the below Python Tkinter application to insert values from text entry boxes into a SQL Server table. The program runs and insert number values into the SQL table but fails when trying ... user avatar ABCDave

  • 1
-2votes3answers46views

how to extract all digit in nvarchar variable in ms sql

I wanna extract all digit in nvarchar variable and store them in a table or pre-declare variable. example: declare @natioanlCode nvarchar(10) = '0083441141'; and the target result may be like this. ... user avatar Muhamad Khojastefard

  • 11
0votes0answers11views

SSIS Package hanging when validating Excel

We are in the middle of upgrading from SQL Server 2012 to 2019. We have an issue with any of our packages that write to Excel files. Basically what happens is that occasionally it will hang ... user avatar RobbZ

  • 1,360
0votes0answers16views

How to get Response Text from HTTP Get Request in SQL code? [duplicate]

I made a function for sending http get requests USE [some-db] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[SendHttpGetRequest](@url VARCHAR(300)) RETURNS VARCHAR(MAX) ... user avatar Slava Podolskiy

  • 145
0votes0answers26views

How to add an error message if the name entered is not in the table

def search_by_name(self): query = """SELECT * FROM Books WHERE book_name = ?""" self.Name = input("Enter The Book Name:") cursor.execute(query, self.... user avatar Mazen Hamed

  • 1
-1votes0answers13views

How to connect flutter App to SQL Server? [duplicate]

I am creating a flutter app and I have to link the app with a SQL Server database. I can't use firebase because it's no SQL. Do you have any solution ? user avatar Meliodas

  • 1
0votes0answers14views

Is there a way to query MSSQL from BigQuery?

I am looking for a way to query our MSSQL Databases from BigQuery. We have datasets on MSSQL and BigQuery. I need to merge some data. And I want to do it without moving data from MSSQL to BQ. I just ... user avatar Melih

  • 5

153050per page

1 2 3 4 5 … 21310