Questions tagged [sql-server]

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.

-1
votes
1answer
19 views

Parsing string with multiple delimiters into columns

I want to split strings into columns. My columns should be: 'account_id, resource_type and resource_name'. I have a JSON file source that I have been trying to parse via ADF data flow. That hasn't ...
0
votes
0answers
26 views

Why does SSMS insert a ' TOP (100) PERCENT' into the view that I am trying to write and warn me that ORDER BY may not work?

I am trying to create a SQL View in SSMS. I am using Views because they are easier to invoke from Power BI than Stored Procedures (especially when no parameters are needed). I start by writing and ...
-1
votes
0answers
32 views

How to get average of multiple variables

Table name: products, column names: rice_price, sugar_price I would like to get the average of both columns separately. For example; SELECT AVG(rice_price) avg_rice, AVG(sugar_price) avg_sugar ...
0
votes
0answers
7 views

SQL Server oddity with full-text indexing and case sensitivity and numbers

This problem may be unique to our server, but I can't tell from the symptoms where the issue may lie. I have a field (searchtitle) in a table (fsItems) that has a full-text index turned ON. For the ...
0
votes
0answers
17 views

SQL AG flip. SQL 2019 cu14 SQL server Error <"interop.cpp">, line=125 Failed Assertion = 'nullptr != error' ,

Has anyone else has seen this, Or knows anything else i should look for. I'm getting an error on our sql server, the error will happen, then about 50% of the time the SQL cluster service will fail. ...
-3
votes
0answers
29 views

Is it bad to have app and DB on same server? [closed]

I have a Blazor Server app which uses a SQL Server 2016 Express database. Both database and app are on the same server. Everything works well and has been for some time - along with a few other Asp ....
-2
votes
0answers
18 views

API for mobile application flutter [closed]

I need to connect to SQL Server and create API's for mobile application (Flutter). My plan is to connect nodejs with mssql as middelware and communicate data with fire base. Can you please what other ...
0
votes
0answers
9 views

SQL Server Availability group

SQL Server availability group backup preferences. We have 3 nodes for our AG. I would like to take full and differential backups on primary, Log backups on secondary. When I configured "any ...
0
votes
0answers
21 views

Azure DB - Mssql - PHP mssql_fetch_assoc timing out question

Did a database migration to Azure. This bit of code seems to be timing out and not sure why. If i manually run the query on Sqlserver returns about 5200 results, runtime about 1 seconds. No query ...
0
votes
0answers
28 views

asp.NET intranet site: if I try to run multiple reports, one after the other, I get SQL permissions error on stored procedure

I inherited an old asp.NET site. This site uses windows authentication and has several reports. each report makes a separate call to different stored procedures on the SQL server. If I go to the ...
0
votes
0answers
36 views

What is the best way to implement a SQL Nested Cursor

Please can someone show me the best way to implement a Nested Cursor with the dataset provided? As you will see there is already one Cursor that looks for the value listed in #TMP_CODE1, if there is a ...
0
votes
0answers
16 views

NUL - ASCII Character Inserted during T-SQL Execution by Spring Boot

I had to use some T-sQL features in SQL Server to encrypt / decrypt certain columns in my database. And when I do NUL ASCII values gets in to the data that sits in the database As a first step, I am ...
0
votes
0answers
22 views

Error Executing Database Query. The conversion of the varchar value '10298866175' overflowed an int column

I'm getting this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The conversion of the varchar value '10298866175' overflowed an int column. The FileSize field ...
1
vote
2answers
29 views

Is there a way to pass in a variable into a stored procedure when using dynamic SQL?

DECLARE @DBNAME nvarchar(200) = 'MY_DB_NAME', @STOREDPROC nvarchar(200) = 'dbo.Friends_SelectById', @Id int = 2 EXEC [dbo].[Test_WithID_Proc] @DBNAME, ...
-1
votes
0answers
23 views

Use both month and day in where clause

I am looking to specify month end dates in my where clause and so far what I have is this. The problem is the clock time is also being taken into account when I only want it to focus on month and day. ...

15 30 50 per page
1
2 3 4 5
20932