正规365体育投注

Dark mode beta

You’ve been asking for dark mode for years.
正规365体育投注 The is finally here.

Change your preferences any time.

Questions tagged [sql-server]

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
0answers
6 views

passing parameters in nested xml in sql server

i have an xml file like below... the xml query with main branch teacherdetails can be a single objects or multiple ones..inside teacherdetails students count is represented in b and student list is ...
0
votes
1answer
21 views

Query to find emails from SELECT FROM VALUES

I'm having a problem with a query that should only bring back a specific result set, however it's returning all values. Essentially what I'm trying to do is update the email column in one table with ...
0
votes
1answer
18 views

MVC - Update Value in Database Table

I have been trying to come up with a solution for quite some time now but they all seem to fail. I have two tables -> AssignedRoles & Incidence. Within the "Assignedroles" there is a "Status" ...
0
votes
0answers
10 views

PySpark - Using Spark Connector for SQL Server

Hope you are all doing well. We are currently exploring options to load SQL Server Tables using PySpark in DataBricks. We have varied sources including files and tables. We are using python as the ...
1
vote
2answers
12 views

TSQL Select Table with columnames derived form fieldName colum (PIVOT, CASE)

I'm struggling with composing a select statement in MS T-SQL that generates a table which column names are representing the value of a source table column (FieldName) and records with values which are ...
0
votes
1answer
21 views

Conversation failed when converting the varchar to INT

I'm creating Store procedure and getting Conversation error "Error: Conversation failed when converting the varchar value '%' to data type int. please any one help me where im doing wrong ALTER ...
0
votes
0answers
12 views

Create multiple ApplicaitonDbContext in ASP.NET Core

In ASP.NET Core application we can use either of database connectivity in ApplicationDbContext, but how will I use both MSSQL Server and MySql in the application.
0
votes
0answers
17 views

Is it possible to use STRING_SPLIT in an ORDER BY clause?

I am trying to order values that are going to be inserted into another table based on their order value from a secondary table. We are migrating old data to a new table with a slightly different ...
0
votes
0answers
14 views

Entity Framework Core DateTime field getting updated to 1/1/0001

I am facing one issue related to Entity Framework Core. I have DateTime field in table as shown below. Table Column - datetime2 (7) & Nullable - False This column is mapped on Entity in asp.net ...
0
votes
1answer
14 views

How to Sort the Financial Year quarters correctly in SQL?

I use the following code to change the date for respective quarter. CASE WHEN MONTH(B.CDate) BETWEEN 1 AND 3 THEN 'Q3 ' + convert(char(4), YEAR(B.CDate) - 0) WHEN MONTH(B.CDate) ...
0
votes
2answers
30 views

Where in case in SQL Server

If @IsPrice=0, ProductPrice=0 will return. If not, ProductPrice > 0 will return. This is what I want, but I could not write the code exactly. declare @Isprice bit=0 select * from [Product] p ...
0
votes
2answers
21 views

How to insert the result in the desired row? SQL Server

I need the result that I got to be inserted in the right row. DECLARE @DiscPrice float; SET @DiscPrice = (SELECT Prod.priceProd - Prod.priceProd / 100 * Prod.disc FROM Prod ...
0
votes
0answers
22 views

Average of Subgroup by GROUP BY in SQL Server

I am working of traffic data. I have following data Table. I want to get the average speed of all vehicles within every one seconds within position of 10 meters. Data time interval is 0.2 second. ...
2
votes
5answers
50 views

Cross apply boolean values in SQL

I had the table below which I need to create a Category column will store the boolean values as a category. I would like to capture the Categories as a single column and I don't mind having duplicate ...
0
votes
0answers
17 views

Multi-Join Query timeout issue

I wasn't able to find this in searching other questions. I am trying to do a series of joins, nothing terribly complex. The problem is that I continue to get the error: "Msg 15884, Level 16, State 1, ...

15 30 50 per page
1
2 3 4 5
18817