While Installing SQL Server 2019 Developer Edition, I am getting error - A required file could not be downloaded. This could mean the version of the installer i
I have a legacy classic ASP application running with SQL Server 2012 (also tested with 2016) that I am trying to switch over to using parameterized queries. All
I have two config tables. The structure is as below: Table 1: Client_Config id, name, value, type, description Table 2: App_Config name, value, type, descript
I am using Debezium Spring Boot starter with its supplier: org.springframework.boot:spring-boot-starter-parent:2.4.10 org.springframework.cloud.fn:cdc-debezium-
I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Servi
I have a code not total like normal distribution. How can I change it from Mysql to SQL Server? select latency where pow(e(), - pow((ln(latency) - 8.223) ,2)/2
First Input Box will ask the user to enter employee number Second Input Box (readOnly) - employee name will be display here automatic base on employee number pr
I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business In
I have two SQL tables. Each has an ID with other columns and a Date. Is there a way that I can get the result from these two tables in one query sorted by the
In general we are supposed to pass integer values to our stored procedures and to do so we usually do it with this method command.Parameters.AddWithValue("@para
this is the first time I am developing an android application. I want to bind some data with grid view or list view based employee id provided on the text box.
Edit - I provided the wtk of the poly I had made valid. Updated with the invalid string. Sorry this seems to have turned by mind to mush. I have a python proces
I have a question to the TRUNCATE command. How does TRUNCATE work in background ? I read a text that says TRUNCATE creates a copy from the table and then star
I'm currently working on a .NET application and want to make it as modular as possible. I've already created a basic SELECT procedure, which returns data by che
How can I get the last logged in date for certain user. I googled and stumbled upon this query SELECT name, accdate FROM sys.syslogins But the accdate column
Let's say there is a sequence created on SQL Server: CREATE SEQUENCE dbo.my_seq START WITH 1 INCREMENT BY 1 NO CYCLE; GO And the following Java cod
I am counting 7-day active users using T-SQL. I used the following code: SELECT *, COUNT(DISTINCT [UserID]) OVER ( PARTITION BY [HospitalID],
I am having an issue upgrading our existing 2017 SSIS packages to 2019 . I have updated the target server version in the package settings and we have installed
I wrote a stored procedure in SQL Server that gets passed 4 parameters. I want to check the first parameter @table_name to make sure it uses only whitelist char
I have a table with a varchar column categoryIds. It contains some IDs separated by commas, for example: id categoryIds -------------------- 1 3,