I need to add a new DNN role in SQL. If I add a new record to the dbo.roles table, it does not seem to create the role in the Security Roles page domain.com/Adm
With new Room, How to highlight SQL Syntax in Dao Interfaces? For example @Query(SELECT * FROM user) is it possible to highlight the words SELECT, FROM with a
I have transaction with several queries. First, a select rows with FOR UPDATE lock: SELECT f.source_id FROM files AS f WHERE f.component_id = $1 AND f.a
I’m attempting to order by a number column in my database which has values 1-999 When I use ORDER_BY registration_no ASC I get…. 1 101 102 10
How to get max_value and min_value Postgres sequence? I created the sequence using this statement create sequence seqtest increment 1 minvalue 0 maxvalue 20;
Is it possible to have fully dynamic SQL Stored procedures? I've read up on dynamic SQL for the past few hours but couldn't find the "fully dynamic" solution th
Is it possible to write a statement that selects a column from a table and converts the results to a string? Ideally I would want to have comma separated value
I am trying to run dynamic queries with a parameter in Azure Data Flow but I continue to get the "Column operands are not allowed in literal expressions" error.
Am using Elasticsearch in nodejs using npm elasticsearch, Here, how can i execute sql queries in elasticsearch? Is there any npm modules or plugin to execut
Good day! I get this error: SQL STATE 37000 [Microsoft][ODBC Microsoft Access Driver] Syntax Error or Access Violation, when trying to run an embedded SQL s
I would like to have the list of stored procedure created in a certain database. I tried db2 "display procedure MyDb.*" But I get error DB21034E The comman
I've followed the JDBC tutorial at: http://docs.oracle.com/javase/tutorial/jdbc/basics/gettingstarted.html, and managed to build and create my own JDBC database
In my queries I'm using TypeORM find option. How can I have IS NULL condition in the where clause?
I am struggling to find a solution for the below issue. date1 = 31-08-2017 12:10:00 I want to cast it as string and need to take date (31-08-2017) alone. Th
So I want to create a select all button in a parameter. The actual parameter has around 200 options because of the size of the database. However, if I want a ge
My SQL Server instance has a linked server to an Eloquence database. I need to select data from one of the tables in the Eloquence database, but I need to do i
I have two tables: Products and Suppliers. SupplierID is a foreign key in products table. I need to make a table that contains country, supplierID, company name
After executing the code below, i get an ORA-25155 error SELECT p.prod_id, prod_name, prod_list_price,quantity_sold,cust_last_name FROM products p NATURAL JOIN
I created a view in SQL Server Management Studio 18 and I am getting the following message: "Commands completed successfully." which I guess means that the view
Trying to convert a date string 03/31/69 to 1969-03-31 standard date format using TO_DATE function. SELECT TO_DATE('03/31/69', 'MM/DD/YY'); Expected value was