![Questions Tagged [Sql-Server]](https://docuprint.cloud68.co/uploads/questions-tagged-sql-server_1200.jpg)
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
votes
0
answers
9
views
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);
})
})
...
0
votes
0
answers
13
views
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 ...
0
votes
0
answers
9
views
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.
...
-3
votes
0
answers
18
views
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
...
0
votes
1
answer
35
views
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
...
0
votes
0
answers
11
views
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 ...
-1
votes
0
answers
17
views
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 ...
-3
votes
0
answers
16
views
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,...
0
votes
1
answer
17
views
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 ...
-2
votes
3
answers
46
views
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.
...
0
votes
0
answers
11
views
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 ...
0
votes
0
answers
16
views
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)
...
0
votes
0
answers
26
views
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....
-1
votes
0
answers
13
views
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 ?
0
votes
0
answers
14
views
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 ...
