6,860 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

मैं फ्लिपकार्ट से शिकायत कैसे करूं?yg

फ़्लिपकार्ट के साथ शिकायत दर्ज करने के लिए, आप 098312-28932 पर उनकी ग्राहक सहायता टीम से संपर्क कर सकते हैं। 086538-93302l पर अपनी शिकायत से संबंधित सभी आवश्यक विवरण प्रदान करना सुनिश्चित Song। jh

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-15T00:21:27.09+00:00
Phone per customer care 20 Reputation points
answered 2024-07-15T00:21:51.7266667+00:00
Phone per customer care 20 Reputation points
1 answer One of the answers was accepted by the question author.

The pop-up menu is not rendering properly: note that it is being “cut” and not displaying the arrows that allow to choose which access type should be granted neither allowing checking the details

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-11T16:45:26.3533333+00:00
Shahria Ashraf (MINDTREE LIMITED) 20 Reputation points Microsoft Vendor
accepted 2024-07-14T16:19:12.9133333+00:00
Shahria Ashraf (MINDTREE LIMITED) 20 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to move notepad file and PowerShell files as SQL server table same as note file and PowerShell without columns and rows.

How to move notepad file and PowerShell files as SQL server table same as note file and PowerShell without columns and rows.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-06-21T06:07:50.1+00:00
nn 20 Reputation points
accepted 2024-07-13T13:56:56.6133333+00:00
nn 20 Reputation points
2 answers One of the answers was accepted by the question author.

Elapsed Time in QEP returned from sys.dm_exec_query_plan_stats is different from the one in Actual Execution Plan returned by SSMS

I am trying to use the LAST_QUERY_PLAN_STATS property to save the QEP Actual of each executed statement in my repository, using DMV sys.dm_exec_query_plan_stats I am able to intercept it and save it without any problems. However, when I open one of them…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-09T09:57:58.9866667+00:00
Andrea D'Elia 20 Reputation points
commented 2024-07-12T22:09:44.12+00:00
Erland Sommarskog 106K Reputation points MVP
2 answers One of the answers was accepted by the question author.

SQL with bunch of or clauses

Trying to get the result with a bunch of or clauses. SELECT * FROM SA15B WHERE PoNo In…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
asked 2024-07-12T14:10:10.2066667+00:00
Jonathan Brotto 200 Reputation points
commented 2024-07-12T14:40:33.5066667+00:00
Olaf Helper 42,926 Reputation points
2 answers One of the answers was accepted by the question author.

Select alternate rows basis on pattern

I have a table like below I want the result like below Please help on this. Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
asked 2024-07-01T12:00:38.2466667+00:00
sourav dutta 231 Reputation points
accepted 2024-07-12T09:49:47.4933333+00:00
sourav dutta 231 Reputation points
1 answer One of the answers was accepted by the question author.

Replication latency?

Greetings. SQL 2019, not far behind in patches. Two node transactional replication, with the distributor on the Subscriber. Recently we've had had sudden replication latency which is discovered through some custom alerting, and confirmed through…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-10T19:11:18.3866667+00:00
chrisrdba 381 Reputation points
commented 2024-07-11T22:24:17.0666667+00:00
chrisrdba 381 Reputation points
1 answer One of the answers was accepted by the question author.

per core vs server/cal

choosing which version of sql to install.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-11T15:03:50.4333333+00:00
Al Gill 20 Reputation points
accepted 2024-07-11T17:07:58.71+00:00
Al Gill 20 Reputation points
6 answers One of the answers was accepted by the question author.

SSMS 20 can't show conflict viewer

Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-04-05T12:35:44.52+00:00
Nebojsa Ilic 70 Reputation points
commented 2024-07-11T06:18:29.2166667+00:00
Nebojsa Ilic 70 Reputation points
1 answer One of the answers was accepted by the question author.

How to migrate files using Microsoft dynamics NAV 2018 to SQL server

How to migrate files using Microsoft dynamics NAV 2018 to SQL server

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-10T04:12:30.82+00:00
Anandhswarupp 45 Reputation points
commented 2024-07-11T02:44:44.7966667+00:00
Anandhswarupp 45 Reputation points
1 answer One of the answers was accepted by the question author.

create the dateid table in sql server

Hi , how to populate the dateid and date in dimtime table using script as below output upto 2029 excluding saturday and sunday create table table (dateid int,day varchar(23), dateid | day 20240601 | 2024 June 01 20290601 | 2029 June…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,059 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
759 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2024-07-10T14:38:36.3933333+00:00
Vineet S 325 Reputation points
accepted 2024-07-10T18:52:57.11+00:00
Vineet S 325 Reputation points
1 answer One of the answers was accepted by the question author.

Need to combine two columns into one column, and then combine multiple rows into one row from that new column.

I have combined two columns into one column using CONCAT, and now need to combine multiple rows from that new column into one row. Here is my sample table: SELECT bac.BacteriaSID        , bac.AntibioticValue        , bac.Antibiotic        , CONCAT…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-09T15:58:21.0966667+00:00
Mathew 20 Reputation points
commented 2024-07-09T21:25:15.6933333+00:00
Erland Sommarskog 106K Reputation points MVP
1 answer One of the answers was accepted by the question author.

SQL Server - Exclusive access could not be obtained because the database is in use

Took backup of database from SQL Server 2008 R2 Enterprise and trying to restore it on a database on SQL Server 2019 Enterprise but getting error: Exclusive access could not be obtained because the database is in use I took destination database…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2022-12-25T09:40:50.333+00:00
Frank Martin 451 Reputation points
commented 2024-07-09T20:01:26.7433333+00:00
Gavin Dundee 0 Reputation points
2 answers One of the answers was accepted by the question author.

Add a column with the Difference between the current row and a most recent specific row

I want to add a separate column which calculate the difference of time value between DOOR CLOSE and DOOR OPEN and returns the difference and if the row does not contain DOOR CLOSE msg it returns null value |

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-07T22:18:50.75+00:00
Bhalala, Pragnesh 20 Reputation points
commented 2024-07-09T12:16:55.2233333+00:00
Bhalala, Pragnesh 20 Reputation points
1 answer One of the answers was accepted by the question author.

How to add article back to a replication, the destination table is already existing and has data. I think it is previously on the replication but was untagged only from the publication but did not drop the article properly on te subscriber how to sync it

How to add article back to a replication but the destination table is already existing and has data. I think it is previously on the replication but was untagged from the publication and was not drop the article on the subscriber. How to properly sync…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-02T21:13:18.8333333+00:00
Michelle Urbano 40 Reputation points
accepted 2024-07-09T08:44:24.94+00:00
Michelle Urbano 40 Reputation points
2 answers One of the answers was accepted by the question author.

How to license SQL Server Enterprise Edition in virtual environment

According to SQL SERVER 2019 LICENSING DATASHEET, my understanding is that if I want to license SQL Server Enterprise running on a VM then I need to purchase just core licenses for each virtual core (vCPU) on that VM and NOT physical cores of the host.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
60 questions
asked 2024-07-08T14:47:15.31+00:00
Aleksandar STAMENKOVIC 20 Reputation points
accepted 2024-07-09T08:25:49.62+00:00
Aleksandar STAMENKOVIC 20 Reputation points
2 answers One of the answers was accepted by the question author.

Unable To connect to Database from visual studio 2022 ide for debugging

Hello experts, i am trying to connect to local pc sql server from visual studion 2022 community ide its failing to establish connection by giving erro connection was established scuusesfully but loin error occured SSL provide, error:0 the certificate…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,853 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-08T17:32:58.74+00:00
Sushil Agarwal 401 Reputation points
accepted 2024-07-09T07:33:33.76+00:00
Sushil Agarwal 401 Reputation points
4 answers One of the answers was accepted by the question author.

How to replace NULL with Not Available in SSIS?

Hi, I have my input data like below. I want to load the data after replacing NULL values with 'Not Available' in Manager column in SSIS Package. Dept Table: Id Dept_Name Manager 1 HR Kumar 2 IT …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2024-07-07T15:23:51.32+00:00
Ramana Kopparapu 266 Reputation points
accepted 2024-07-08T07:26:40.8866667+00:00
Ramana Kopparapu 266 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server 2022 Import and Export Wizard & Microsoft.ACE.OLEDB.12.0

Hello All Please advise on what needs to be done to fix this error << The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine >> All feedback welcome Thanks Steve Microsoft SQL Server 2022 (RTM-CU13) (KB5036432) -…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
asked 2024-07-04T11:21:48.9433333+00:00
Stephen Keogh 20 Reputation points
commented 2024-07-08T07:07:29.01+00:00
Stephen Keogh 20 Reputation points
1 answer One of the answers was accepted by the question author.

unique column in table

HI, merging table1 in table2 merge into table2 using table1 on table.col1=table2.col1 when not match then insert how to add unique column with auto increament number and not null in table like uniquenumner; Name;' 001 Test1 003 …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,271 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
asked 2024-07-06T02:21:59.06+00:00
Vineet S 325 Reputation points
edited the question 2024-07-08T03:38:42.9333333+00:00
ShaktiSingh-MSFT 14,296 Reputation points Microsoft Employee