SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,951 questions
0 answers
SQL Server 2022 Kurulum Hatası
SQL Server 2022 Detail.txt Summary_DESKTOP-UN0800B_20240602_203435.txt Summary.txt Exit Code (Decimal): -2068052377 Error Description: Geçersiz komut satırı bağımsız değişkeni (Invalid command line argumant)
asked 2024-06-02T17:55:45.07+00:00
Kadir Veysel SAYAR
0
Reputation points
edited the question 2024-06-02T18:00:30.0166667+00:00
Kadir Veysel SAYAR
0
Reputation points
3 answers
i have few snapshot transactions, now i need to put nolock/read uncommit for perticular table
hi, I have few snapshot transactions , now my admin has informed me that put no lock in all tables in snapshot transactions, as it was blocking locking deadlocking with others. so I suggested to put read uncommited instead of snapshot when u are…
asked 2024-05-20T07:11:58.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
0
Reputation points
commented 2024-05-31T20:47:35.6666667+00:00
Erland Sommarskog
102.6K
Reputation points
2 answers
One of the answers was accepted by the question author.
Benefits and disadvantages of WITH (NOLOCK)
Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.
asked 2024-05-30T15:12:46.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
100
Reputation points
answered 2024-05-30T21:20:01.3066667+00:00
Erland Sommarskog
102.6K
Reputation points
1 answer
delimited split gives null for some items
hi all, I am using a function to split a string into multiple rows. The function is available here: https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function What I am trying to figure out is how to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one
4 answers
Conversion failed when converting the varchar value to data type int in a JOIN
So we have a SQL Server Stored Procedure that has a JOIN using a data column that is defined in the "To Be" Joined Table as INT. The data column in our joining criteria is defined as a data type NVARCHAR(100). So the SQL Server Stored Procedure…
asked 2020-08-29T13:45:37.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
221
Reputation points
answered 2024-05-28T08:57:41.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tamer Al-Debsi
0
Reputation points
1 answer
SSMS not flagging basic errors after IIF statement
DMF_SSMS_SQL_IIF_Err.pdf I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then…
asked 2024-05-20T15:07:50.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 88%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
AdamG Devl
0
Reputation points
commented 2024-05-24T16:02:35.9133333+00:00
AdamG Devl
0
Reputation points
7 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,248 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,730 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.
12,951 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,567 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
125
Reputation points
commented 2024-05-23T19:53:28.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,211
Reputation points
0 answers
Trying to Bulk Insert SSN data into an always Encrypted column and is not working. Any guidance please.
I am having trouble Bulk inserting the SSN data from a simple SQL table to a table where I have an always encrypted column. I am not getting any right solution after googling around. Please share if anyone has done similar kind of work. Thanks, SK.
asked 2024-05-22T18:37:24.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjay Kumar
0
Reputation points
commented 2024-05-23T06:00:27.9133333+00:00
CosmogHong-MSFT
24,026
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Querying with Filename and Filepath Functions in Synapse Serverless
Hello, I have been reading about using filename() and filepath() in t-sql statements with synapse serverless sql: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files#functions Wondering if for the following statement:…
asked 2024-05-21T17:38:30.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
65
Reputation points
answered 2024-05-21T20:52:17.8666667+00:00
Karl Gardner
65
Reputation points
2 answers
One of the answers was accepted by the question author.
Can't figure out why The select list for the INSERT statement contains fewer items than the insert list
Hi everyone, I want to create a stored procedure that will create a table and return value, but I got this message: Msg 120, Level 15, State 1, Procedure sp_Month01_FYCalendar, Line 36 [Batch Start Line 9] The select list for the INSERT…
asked 2022-11-11T22:32:34.147+00:00
Claude Larocque
666
Reputation points
commented 2024-05-20T12:38:59.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Paul Yardley
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server - Question marks inserted with Hebrew collation
SQL Server 2019, Developer edition, Windows 10. The client is SSMS 18. When database is created with Hebrew collation, for example, Hebrew_CI_AI, there is no problem, Hebrew strings are inserted and being read as they are. When database is created…
asked 2021-06-22T16:29:10.737+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Natalie Sh
26
Reputation points
commented 2024-05-19T08:01:18.8333333+00:00
Erland Sommarskog
102.6K
Reputation points
1 answer
One of the answers was accepted by the question author.
Exception problem
Hi, I've got issue due to this line below. reader = cmd.ExecuteReader(); Can it be owing to no record returned?
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,951 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,423 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,567 questions
asked 2024-05-10T08:22:21.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,586
Reputation points
accepted 2024-05-16T09:48:36.94+00:00
Peter_1985
2,586
Reputation points
2 answers
One of the answers was accepted by the question author.
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
asked 2024-04-19T19:37:38.3733333+00:00
Jonathan Brotto
100
Reputation points
accepted 2024-05-13T14:34:58.0033333+00:00
Jonathan Brotto
100
Reputation points
1 answer
query taking long time to match
Hi Team, how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it query attached
asked 2024-05-10T13:40:44.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
205
Reputation points
commented 2024-05-13T02:39:20.27+00:00
CosmogHong-MSFT
24,026
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Help with SQL
Hi Experts, Need help in creating calculated columns as below. My Data: Expected Result of two calculated columns: Calculated Column 1 = Previous calculated value in Calculated Column 1 * Rate Calculated Column 2 = RecentMinRent * current…
asked 2024-05-11T17:16:52.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 28.000000000000004%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shyam Sreeramula
21
Reputation points
commented 2024-05-13T02:29:19.6766667+00:00
Shyam Sreeramula
21
Reputation points
6 answers
One of the answers was accepted by the question author.
remove values from string
Hi Expert, how will i remove all the characters from values in sql Create table test1 (id string, details string) insert into test1 values('20kjk','3ddf') Regards
asked 2022-08-17T10:50:23.187+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,406
Reputation points
answered 2024-05-11T10:29:32.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 74%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Ebrahim Bazarjani
5
Reputation points
0 answers
COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma
We are trying to COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma "," from potentially two data sources. So like...123 Main St., Apt. 101 The first part is easy enough... CONCAT ( COALESCE ( LTRIM (RTRIM…
asked 2024-05-09T18:55:45.0266667+00:00
Bobby P
221
Reputation points
commented 2024-05-10T01:28:42.8933333+00:00
CosmogHong-MSFT
24,026
Reputation points Microsoft Vendor
1 answer
Parsing First, Last, Middle Initial and suffix from full name
I am trying to extract first last middle initial and suffix from a name field and there's no set pattern please see the pattern of the in my table LOPEZ ROQUE, CARMELINA ORTEGA, GISELLE A A RUSSELL JR, WILLIE C NUNEZ, LILIANA I have looked online and…
asked 2024-04-01T01:59:34.55+00:00
Ali Ahad
91
Reputation points
answered 2024-05-10T00:59:34.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
58,441
Reputation points
2 answers
The transaction log for database is full due to 'REPLICATION'
Hi! I have a SQL 2019 database that is a member of 3 node always on availability group. It is also the subscriber being populated from a DB2 database. The log keeps filling up and I am unable to shrink or backup.. I get the message: The transaction log…
asked 2022-04-25T08:33:47.077+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZO%3C/text%3E%3C/svg%3E)
zoe Ohara
286
Reputation points
commented 2024-05-07T09:12:45.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 74%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi Sethi
0
Reputation points