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,
CREATE PROCEDURE SPCheckDirectoryExists ( @chkdirectory as nvarchar(4000) ) AS SET NOCOUNT ON BEGIN DECLARE @folder_exists as int DECLA
I use standard driver com.microsoft.sqlserver.jdbc.SQLServerDriver to connect to a MSSQL server. I run my program in Eclipse and encounter error: Failed to obta
I want to generate an ER diagram of an SQL database using Microsoft SQL Server Management Studio (SMSS). However, I don’t know how to. I found this techni
I have got a problem with database queries, when I try to run them from my groovy script. Sometimes, but very often, I've got an error: com.microsoft.sqlserve
I have following queries: DECLARE @application_number CHAR(8)= '37832904'; SELECT la.LEASE_NUMBER AS lease_number, la.[LEASE_APPLICATION] AS applicatio