2020欧洲杯手机版注册

A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
-2
votes
0answers
17 views

How to get number of rows from SQL Server? [duplicate]

I am performing query which returns 2 rows in SQL Server Management studio. I am performing the same query on php file and trying to get number of rows with sqlsrv_num_rows() but unfortunately it ...
-4
votes
2answers
48 views

SQL Query to calculate the hours between two dates grouped by days

I need to write an SQL query for the following scenario.I am having start date as 2020-01-10 13:00:00.347 and end date as 2020-01-12 02:00:00.347, so I need data grouped as Day Hours-...
-1
votes
0answers
17 views

Split the concatenated comma values in a particular position using SSRS matrix report

The below image contains concatenated values dynamically so i need to split dynamically in a particular position like 4th or 5th or other positions because in future values values are keep on adding ...
0
votes
1answer
24 views

db.Exec() not returning correct RowsAffected() value in golang for SQL Server

I have written a Golang code to update the records in a table. In this, I have used db.Exec(query) function to execute the query and get the result back. I also want to check the no of rows affected ...
0
votes
0answers
23 views

Unable to connect to SQL Server database (error 25) in PowerBI

I've tried to connect to a SQL Server database (to get data) via DirectQuery and got an Error 25: Connection String is not valid.But when I tried to import data from that server, it was ...
0
votes
1answer
29 views

Update existing table by migration

I have a database created by "database first" approach. But now I want to update records in the specific table by "code first" approach, by migrations. I can insert records by using EntityTypeBuilder....
-1
votes
1answer
50 views

Cannot perform an aggregate function on an expression containing an aggregate or a subquery in T-SQL

I am working/studying on sakila database and I am trying to convert to T-SQL and use with SQL Server. I am having some issues converting a view from MySql to T-SQL.I have checked most of the ...
0
votes
1answer
38 views

SQL Server: Match Two Tables and Get Value

I have Two Tables like below. Now I just Need to search and match of Table A with Table B and identify the exact match record set from Table B. Like: Search the Name, Age and Sex values of Table A ...
0
votes
1answer
12 views

Only One table in Sql-server 2008R2 Database working slow while accessing with ADODB ODBC connection

Only One table in Sql-server 2008R2 Database working slow while accessing with ADODB ODBC connection. Table has properly defined clustered primary key. The only thing is table has 60 columns and 50000 ...
0
votes
2answers
31 views

Merging two tables in query

I have two tables in SQL Server 2008 R2. One is called customer and data in the table is like this:The second table is called Operators and data looks like this:The result should combine data from ...
0
votes
1answer
44 views

How to use DBContext to save data permanently in my local sql DB?

I'm trying to understand why my data is not saved in my local SQL db when my app is closed.I'm running a simple console application, which is connected to an SQL server.Here is my connection string:...
0
votes
1answer
25 views

How can I use FOR JSON to build JSON in this format?

I'd like to use FOR JSON to build a data payload for an HTTP Post call. My Source table can be recreated with this snippet:drop table if exists #jsonData;drop table if exists #jsonColumns;select ...
0
votes
1answer
31 views

How to call c# .exe LOCALLY from SSMS script?

I want to plot various columns from my DBs.There does not appear to be a simple way to do this from SSMS, so I have created a small c# app that takes a table name and column name and does the ...
0
votes
0answers
14 views

Display name on the basis of user sign in on Tableau

I want to display name on Tableau dashboard on the basis of sign in. Is it possible if Sam logins then it should say Hello Sam, or if Mark logins with his id, it should sayHi Mark.Is that possible?...
0
votes
0answers
9 views

i am trying to connect to mssql server with loopback buti got an error connection fails

error like:Connection fails: ConnectionError: Failed to connect to localhost:1433 - Could not connect (sequence)It will be retried for the next request.her is the datasource file{ "db": { "...

15 30 50 per page