sql Questions
5
Solved
In a hypothetical scenario, I am an user with no table creation privileges. I want to know if a column in a table has UNIQUE CONSTRAINT. Is it possible to look it up in the DICTIONARY? How would I ...
3
I want to realize a fulltext search in postgresql combined with a kind of fuzzy search. For my testarea I followed up this article: https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-...
Prevailing asked 8/9, 2017 at 17:59
3
I'm looking to populate a column in a table with a value for every hour between two dates.
Example:
01-01-2020 00:00:00 to 01-01-2026 00:00:00
should produce this result:
01-01-2020 00:00:00
01-01...
Paradisiacal asked 30/8, 2024 at 12:56
5
Solved
The Problem
I have a query that returns 17 records. When I use MyBatis with a map that has an <association> it returns 6 records. Note that this doesn't happen with my other maps, I have man...
Isolated asked 25/4, 2013 at 19:23
4
Solved
I am using Visual Studio 2008 and SQL Server 2008 Express.
How can I change the name of the view? I can change tables' names, but I can't change the view name.
Any suggestion?
Dyanne asked 10/9, 2009 at 0:10
4
Solved
I need to determine the available space on the drive where my database lives.
I know about the xp_fixeddrives procedure but how do I get the info for the specific drive where my database resides?
Humorist asked 11/2, 2010 at 8:27
2
Solved
When using a Database Initializer for Entity Framework 6 that creates a database when none exists with an Azure SQL server connection the Database created is created using the vCore pricing model. ...
Beira asked 30/10, 2019 at 15:33
4
Solved
When I scan my database, it shows one of the result like VA1143 'dbo' user should not be used for normal service operation in A Vulnerability Assessment scan
They have suggested to "Create users ...
Streamy asked 5/5, 2020 at 10:53
3
Solved
I'm getting a ORA-01790: expression must have same datatype as corresponding expression error message. Below is the sql I'm using. Is the CASE statement causing this issue? I'm new to sql and this ...
2
I'm trying to find the preference settings to have the output clear every time my statement or set of statements are executed. I would prefer this option instead of right clicking and clearing the ...
Bekha asked 24/8, 2014 at 4:42
6
Solved
I have an attachments table that stores the size of the document in Bytes.
I'm needing to display a result set of all documents in either KB or MB. In KB if the document is less than 1MB or in MB ...
Rental asked 9/2, 2017 at 0:4
4
Solved
I have a windows batch file that does this:
for %%s in (*.sql) do call
It loops through all the sql script in a folder.
In the folder the file names are like:
s4.06.01.sql
s4.07.01.sql
s4.08.01....
Lobworm asked 31/8, 2010 at 6:22
3
Solved
declare @minDateTime as datetime;
declare @maxDateTime as datetime;
set @minDateTime = '2014-01-13 02:00:00';
set @maxDateTime = '2014-12-31 14:00:00';
I am looking to create a select statement ...
Weft asked 27/11, 2014 at 0:59
2
I am having a trouble with using GROUP_CONCAT in MySQL
My tables g0 as follows:
ID Age Sex
-------------
1 16 Male
2 18 Female
3 16 Male
4 18 Female
5 16 Male
But I need the table to look like
...
Purlieu asked 20/12, 2015 at 7:8
7
Solved
Please can someone post a SQL function to convert easting/northing to longitude/latitude. I know it's incredibly complicated but I haven't found anyone who has documented it in T-SQL.
This javasc...
3
I'm trying to create dynamic SQL pulls in R. I'm using dplyr to create the pulls. However, I haven't found a way to properly convert a string to expression with dplyr.
For example, the following co...
Firstly asked 29/8, 2024 at 17:20
3
Solved
I have two identical tables:
A : id1, id2, qty, unit
B: id1, id2, qty, unit
The set of (id1,id2) is identifying each row and it can appear only once in each table.
I have 140 rows in table A an...
Truax asked 6/1, 2016 at 6:48
3
Given a string '100+200', how do I evaluate it?
I want to get 300 on output.
Engrail asked 20/6, 2014 at 22:48
2
Solved
I have a django app that uses MySQL as the database backend. It's been running for a few days now, and I'm up to ID 5000 in some tables already.
I'm concerned about what will happen when I overfl...
5
Solved
I have a database field name call Code and I am trying to select it using a variable name like this below:
Declare @var1 = [Code]
(SELECT @var1
FROM [VoucherType]
WHERE [DeletedBy] IS NULL
AND...
Coatee asked 10/12, 2011 at 5:33
7
Solved
Here's a simplified example of what I'm talking about:
Table: students exam_results
_____________ ____________________________________
| id | name | | id | student_id | score | date |
|----+------...
Romanticist asked 7/12, 2009 at 23:22
9
Given a set of database records that record the date when an object enters a particular state, I would like to produce a query that shows how many objects are in each state on any particular date. ...
Serene asked 11/11, 2014 at 19:4
3
I just set default timestamp format as
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF'
When I insert the data into the table the timestamp inserted as,
0014-08-11 04:45:24.000...
Patti asked 11/8, 2014 at 14:20
7
Solved
I'm performing a regular expression match on a column of type character varying(256) in PostgreSQL 8.3.3. The column currently has no indices. I'd like to improve the performance of this query if I...
Saadi asked 30/3, 2009 at 20:56
3
Solved
We have a lot of DBUsers in our database. We have to clean up all those users from the database. When I tried to drop the user from the DB it failed due to the following error
Msg 15138, Level 1...
Hocker asked 7/2, 2011 at 12:31
© 2022 - 2025 — McMap. All rights reserved.