2020欧洲杯时间表

Dark mode beta

You’ve been asking for dark mode for years.
The is finally here.

Change your preferences2020欧洲杯时间表 any time.

Questions tagged [sql-server]

2020欧洲杯时间表 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
14 views

Trigger insert date failed when run job with SSIS packet

I created a trigger to add date when insert record. I worked fine when I inserted several records. However, it will not add date when I ran job with SSIS packet (over 20000 records). I'm not sure ...
-1
votes
2answers
17 views

Previous Year record in sql server

How do we get the previous year values in the current row. example id year amount 1001 2001 2400 1002 2003 3600 1003 2005 2300 1002 2004 1600 Desired Output id ...
2
votes
2answers
29 views

Using the LIKE operator and “greater than” in a Case When expression

This is for a section in a unit test that I'm writing. I am trying to say pass if any row in a column contains a certain string. So in words, what I want is "if the number of row that contain astring ...
1
vote
0answers
19 views

Removing properties and inheriting them instead - code first approach

So, I have been developing a .NET Core Web API application for sports results, teams, competitions, matches... You get the point. Now, what I did not think of when creating entities is that I will ...
0
votes
1answer
11 views

How to filter rows based on value of XML atrribute name in SQL

I have table Web.Log with column Properties which contains following content <properties> ... <property key="ActivityId" /> <property key="UserName">John Doe</property> &...
0
votes
1answer
10 views

Join on 2 different conditions based on CASE expression

I want to write an update query which joins 2 tables based on different Case conditions Update Table1 Set ID = Case when T1.value1 < 0 then T2.ID ------Join on value1 between T2.valueTo ...
-1
votes
1answer
32 views

Insert data into SQL Server using file txt

I want to insert data from a .txt file into SQL Server database, but I have a problem: it only insert the first line from my file, it doesn't insert the second and the next line. How can I solve this?...
0
votes
2answers
25 views

How to show missing records

I have two tables like below in SQL Server 2017: Table X XID Name 1 A 1 B 1 C 2 A 2 B 3 C Table Y YID Name 1 A 2 B 3 C 4 D I want to show the missing [Y].[Name] for each X data. Expected ...
0
votes
0answers
28 views

SQL Duplicate value1 Max value2 [closed]

I am quite new to SQL and my question is very similar to the problem posted in here. However, my Username and Date are in two different databases. Also, I'd like for the output I would like Date to be ...
0
votes
0answers
26 views

Incorrect syntax near (last line)

I'm working on a stored procedure, and when I converted it back from a query to a stored procedure, it's complaining about "incorrect syntax near 0", or wherever the last line is if I comment things ...
1
vote
1answer
22 views

Combining row values from multiple tables into one result cell

I'm looking to create a report of sorts and am having a hard time wrapping my head around how this portion could be done with a single select in SQL (my experience is limited to a database course and ...
0
votes
0answers
16 views

Cannot create an API controller with actions using Entity Framework for SQL Server database view

I am developing a Web API using ASP.NET Core 3.1.2 with Visual Studio 2019 v16.5.2. My problem is when I try to create a controller for a database view model class, I get this message after ...
0
votes
1answer
26 views

Return unique row only - TSQL

I have a customer table and order tables. In customer table we have 'Family link' column which is a given ID to each customer. e.g. familyLink: A121, if this customer has a family member in the table ...
0
votes
0answers
9 views

Upgrading an SSIS package that uses and encrypted password from 2008 to 2012

I was tasked to upgrade some old SSIS packages from 2008 to 2012 and I have never done that before. Most are upgraded automatically by the Visual Studio upgrade wizard, but one is failing and I ...
0
votes
0answers
25 views

Entity Framework Core autosaves objects in Blazor

I might be not getting how some stuff work in Blazor, but here's what my issue is: whenever I want to edit an object for example People object, I select it in @page "/people" from a table, then I'm ...

15 30 50 per page
1
2 3 4 5
18780