I am using a flyway tool to run SQL script. I have requirements where I need to return the SPID during the run time in the flyway. Are there any config paramete
I'm monitoring the slowest queries to my databases and this one can't be indexed: USE [Project] SELECT TOP 10 t.NAME AS TableName, t.object_id, mai
Replicate SQL image here Result error image description here
I'm trying to get the clock in and clock out times to correspond to each other so that I can calculate hours worked/amount of breaks/time worked within working
I have structure data like this, I'm using SQL Server: ID User_ID CheckinTime Date 1 110 "2022-03-25 06:30:29" "2022-03-25" 2 110 "2022-03-25 12:12:31" "2022-
I have structure data like this, I'm using SQL Server: ID User_ID CheckinTime Date 1 110 "2022-03-25 06:30:29" "2022-03-25" 2 110 "2022-03-25 12:12:31" "2022-
I have the following dataframe: data = [['Alex', 182.2],['Bob', 183.2],['Clarke', 188.4], ['Kelly', NA]] df = pd.DataFrame(data, columns = ['Name', 'Height'])
i'm inserting multiple rows into a table using a single insert statement. The table has an auto increment field as the primary key. Like so: INSERT INTO MyTabl
I've got a problem with my order by clause when using a calculated column with an alias as below: This order by works without any problem declare @Mode int = 1
I am trying to list all DEPARTMENT_IDs with PRODUCT_IDs, first where PRODUCT_COST_STATUS = 1 but there are also data with where PRODUCT_COST_STATUS = 0. I prefe
I have created table using datatable with in each row have td with input or select field. with having on multiple pages. The issues is the datatable render 10 r
I need to convert "2022-04-29T07:20:32.727Z" to "2022-04-29 07:20:32". I am quite new to SQL and haven't found the solution.
I have been trying to extract data from the following xml doc using t-sql on sql server 2019. XML: <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9
This resource states that a Azure SQL database may be attached to a database by using the following command: WITH IDENTITY='SHARED ACCESS SIGNATURE', SECRET =
I'm trying to connect a user to my company's postgreSQL Server to access a postgres database via MS Access 2019. Connection should be established via ODCB drive
I have the following My Guitar Shop exercise in my SQL II course and am stumped with the part about getting the results in ascending order through the cursor. A
I want a row in hibernate that only takes ("yes","no"," "), how can I map it? Something like an ENUM type in SQL but mapped in Hibernate
I would like to be able to see the effects of running a Stored Procedure that someone else has written or other SQL code on a production datab
I am working on a C# project with a Microsoft SQL Server database. This is how I have connected the database: DataSet ds_display = new DataSet(); SqlDataAdapte
My goal is to continue in the procedure only with the database selected if it contains a specific table and a specific column. So that I don't get an error mess