SQL Server

Query locking

Hi, ALL, I am trying to run the following query thru SQLPrepare/SQLBind/SQLExecute sequence: INSERT INTO abcattbl WITH( TABLOCK ) SELECT ?, ?, (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = ? AND s.name =…

Query locking

Hi, ALL, I'm trying to execute following query with SQLExecute(): INSERT INTO abcattbl WITH( TABLOCK ) SELECT ?, ?, (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = ? AND s.name = ?), '', 8, 400, 'N', 0,…

unable to install my sql from windows 11, i get Exit code (Decimal): -20618936606Error

unable to install my sql from windows 11, i get Exit code (Decimal): -20618936606Error

Unable to install SQL server

Unable to install SQL server

SSIS package failed to run

Fail to run the package from agent job. It said unexpected error. But when i run it in VS project it works.

System can’t find the specified path error

hello, I’m trying to install SQL Server 2022 to my PC several times now and it always have the same issue, that the installation cannot be made because “the system can’t find the specified path” Is there a way to complete the installation?

What is MARS commection

Hi, ALL, I thought that MARS connection is for the following scenario: SELECT field1 FROM table1 WHERE SELECT field2 FROM table2 WHERE table2.field1 = table1.field1_value As you can see there are 2 open statements for which MARS is a solution, Apparently…

How can I convert from SQL Server ORDER BY [Date] ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW to LinQ Query?

I have a SQL query and want to convert it to LINQ. It would be great if some experienced people could help. CREATE TABLE [dbo].[tbl_payment]( [Id] [int] IDENTITY(1,1) NOT NULL, [Companyid] [int] NULL, [Date] [datetime] NULL, [PaymentAmount]…

How to resolve data update issues with Microsoft SQL Server 2012 in an SAP application?

I am unable to update data on my SAP application due to an error related to Microsoft SQL Server 2012.

how to Run SQL server Standard edition on Docker with license key

I went to run SQL Server standard edition on docker-compose. I have applied the license on the compose environment variable but in query, it shows that LicenceType is disabled. SELECT SERVERPROPERTY('LicenseType') as Licensetype, …

Getting different SQL exceptions in SQL server Vs Java client application.

Hello Team, I am getting the following error in my client application and it is failing to connect to the database - On the 2019 SQL server- "The login packet used to open the connection is structurally invalid; the connection has been closed.…

SQL SERVER INSTALLATION

I TRIED TO INSTALL SQL SERVER BUT I FACE THIS ISSUE Detail.txt

SQL Query Date between not filtering properly

I am querying using my SQL table and trying to form simple date between query. when i am querying, i am not getting properly correct rows. My SQL Column is : DOJ (Datatype is datetime) and sample data is…

SSRS Report Server Connection refused

Hello, i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services…

SSIS Ole DB Source Editor - Error: No Column Information Returned by SQL Command

The Ole DB Source Editor was functioning correctly with the Data Access Mode set to SQL command, using a query that included a parameter. Sample Query: SELECT * FROM view_CUSTOMER_DATA WHERE ACTIVE = 'Y' and LAST_SHOPPING_DATE = ? A parameter with a…

SSIS Ole DB Source Editor - Error: No Column Information Returned by SQL Command

The Ole DB Source Editor was functioning correctly with the Data Access Mode set to SQL command, using a query that included a parameter. Sample Query: SELECT * FROM view_CUSTOMER_DATA WHERE ACTIVE = 'Y' and LAST_SHOPPING_DATE = ? A parameter with a…

SPID -5 blocking everything.

SS 2022 CU 13 Greetings. Last weekend we moved to a new SQL server, and last night didnt go so well. When I logged in this morning we had LOTS of blocking from spid -5. I can't find much info on this but did find this link that shares this detail: In…

Declare variable error

Receive this error when running the code below. Don't know how to resolve it. Command1.CommandText = "UPDATE names2 " & "SET trn_date1 = @trn_date1, " & "trn_date2 =…

SQL Server

SQL Server

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

14,407 questions

Sign in to follow

VB

VB

An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.

2,777 questions

Sign in to follow