皇冠hg0088代理网址

Questions tagged [sql-server]

皇冠hg0088代理网址 Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all 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.

Filter by
Sorted by
Tagged with
0
votes
1answer
10 views

Upgrade Database Engine for AWS Hosted MS SQL

I am not great at working with AWS but I have searched for a while and I cannot figure out how to upgrade an existing database in AWS from Microsoft SQL 14.xxx to 15.xxx. I was able to execute a minor ...
0
votes
0answers
17 views

Error while inserting values from table to table

I am trying to insert rows as result of a query to an other table. I am getting this error: The subquery return multiple values. This is not allowed when the subquery follows =,! =, <, <=,>,&...
0
votes
0answers
15 views

SQL Server 2012 to store DATE in dmy format

By default SQL Server database tables are storing dates in "YYYY-MM-DD" (2020-09-24) format. Instead, I want dates to be stored in "DD-MM-YYYY" (24/09/2020) format. Please advise.
0
votes
0answers
8 views

statement.getGeneratedKeys() returns nothing sql server

I have a table and I want to insert a row and return generatedkey (primary key). Here is my pseudo code: int records = jdbcTemplate.getJdbcTemplate().update(connection -> { ...
1
vote
2answers
17 views

SqlDataAdapter optimize foreach

This C# code is tested as working, but looks inefficient to me. How can I avoid all of the overhead in each foreach interation for say a 1,000 rows? SqlConnection con = new SqlConnection(strConn); //...
0
votes
0answers
7 views

Optimizing SQL server performance in Docker container

We are having an issue with a very slow start (and generally poor performance) of dockerized SQL server. Sometimes it takes 5+ minutes for a fresh container to start. We are using SQL server in docker ...
-1
votes
1answer
20 views

SQL Logic issue and renaming of tables

I have 2 problems here i want to check if there's any Record in my table Source_Patient that has the column IsProcessed evaluated to true in the case that Batch.SourceId = 1 , when Batch.SourceId = 2 ...
0
votes
0answers
11 views

How to properly use an Union with IQueryable into an one-to-one relationship with linq2db?

My regular selects works fine. But when I use an UNION, only works if I am not using the relationship. I am using linq2db fluent mapping with SqlServer. Here is the two objects //Product ...
0
votes
1answer
13 views

How to create a generated sequential number in a computed value in a select statement in SQL Server?

I would like to add a sequential number to a number as a computed column in a Select. I tried the below but SomeNumber = 50001 for both rows which means Row_Number seems to get reset to 1 for every ...
0
votes
2answers
21 views

Recursive query to use a date returned in initial query as limit in subsequent query

I have a business need to project when a specific task needs to be done based on the usage of a task. For example, you need to change the oil in your car every 3000 miles. Some days you drive 300 ...
0
votes
1answer
12 views

Inserting multiple result sets of a stored procedure into a temporary table

I have a stored procedure which returns multiple result sets. I am trying to retrieve column value of all results into temp table.is it possible. My stored procedure returns columns like below. I have ...
-1
votes
1answer
29 views

Using CASE expression in condition of Join

Suppose there are 2 table 'Source' and 'Name'. And the records of table are as: Source table Name table My SQL query is: select s.* from source s join name n on s.Market = n.Market and s....
0
votes
0answers
15 views

Convert large SQL Server database to MySQL database

I am trying to migrate a SQL Server database to a MySQL database. I tried doing same using MySQL Workbench but for some driver related reasons, I am unable to have it work for me. I also tried online ...
1
vote
1answer
20 views

SQL UPSERT QUERY W/ Duplicate Rows Made Unique Based Upon 3 Fields (C# VisStudio)

Background is I'm making a SQL connection that takes a .csv file and imports it into a SQL Server database table. The problem I'm running into is, I'm having trouble with the query syntax because ...
0
votes
0answers
15 views

T-SQL - Inserting 3.5M rows increases the transaction log size to max

Following is the query I am using to parse 3.5M rows of JSON data and insert it into another table. DECLARE @id_control bigint DECLARE @batchSize bigint DECLARE @results nvarchar(256) ...

15 30 50 per page
1
2 3 4 5
19506