Recent questions tagged SQL

0 votes

291 views

1 answer

sql - MySQL: Finding rows that don't take part in a relationship

I have two tables: 'movies' and 'users'. There's an n:m relationship between those, describing what movies ... there a better approach to this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

677 views

1 answer

sql - Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint

create table pilot ( emp_num int, pl_license varchar (3), pl_ratings varchar (30), pl_med_type int, pl_med_date date, ... ','12-May-96' ) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

963 views

1 answer

sql server - A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations

What is wrong with this statement? ALTER Function [InvestmentReturn].[getSecurityMinLowForPeriod](@securityid int, @start ... select statement. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

379 views

1 answer

sql - How to quote values for LuaSQL?

LuaSQL, which seems to be the canonical library for most SQL database systems in Lua, doesn't seem to ... write a wrapper for sqlite3_snprintf? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

466 views

1 answer

sql - How can i generate a Date table with fields equals to "Dayofweek", "weekofyear" etc ;and rows equals to date from 2010-01-01 till current_date

How can i generate a Date table with fields like "Dayofweek", "weekofyear" etc ;and rows equals to date from 2010-01-01 ... 03-31 1 31 90 6 14 N See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

428 views

1 answer

sql - Do databases always lock non-existent rows after a query or update?

Given: customer[id BIGINT AUTO_INCREMENT PRIMARY KEY, email VARCHAR(30), count INT] I'd like to execute the ... accept the use of SERIALIZABLE. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

291 views

1 answer

sql - Search across multiple tables and also display table name in resulting rows

How do I structure an SQL statement to run across multiple flat unrelated tables and display the result with the ... t find the column there. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

262 views

1 answer

sql server - Datetime issues with vb.net and MSSQL

I am been creating a desktop form in vb.net in which I used datetime-picker tool. I want a format of ... Exception MsgBox(ex.ToString) End Try See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

313 views

1 answer

sql server 2008 - How to run a program from SQL?

I need to implement a tool that runs programs from SQL Server database when a DB record matches some condition. Is there a way to do it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

335 views

1 answer

sql - What's the most efficient way to normalize text from column into a table?

In T-SQL I have a column with some text in it with a format like the following: [Key1:Value1:Value2:Value3:Value4 ... can do with T-SQL for now. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

335 views

1 answer

sql server - How can I programmatically create a DSN?

I have an Access Form that uses a linked sql server table as a datasource. I will need to distribute this ... direct me in the right direction? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

328 views

1 answer

sql server - T-SQL incrementing counter based on change in a column value

I have sample table like below. The table is sorted by another column that is not shown. I need to increment a counter column ... 3 7 0 4 8 0 4 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

457 views

1 answer

sql server - Group by sql query on comma joined column

My table structure is like below, "Mail" column can contain multiple email joined by comma Data(int) Mail( ... t change the table structure. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

322 views

1 answer

sql server - recursive cte with ranking functions

How to use ranking functions in recursive cte? Here's simple example showing how I'm trying to do: with cte ... ranking? Show me my mistake pls See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

454 views

1 answer

sql - How to create query from parent child hierarchy table

How do I write my query to translate a table with parent / child hierarchy into a table with my hierarchy levels ... level / level above S-1000 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

391 views

1 answer

sql - Storing multiple choice values in database

Say I offer user to check off languages she speaks and store it in a db. Important side note, I will ... I overlooking anything? Thanks, Andrey See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

253 views

1 answer

sql - Query last N related rows per row

I have the following query which fetches the id of the latest N observations for each station: SELECT id FROM ( ... can I speed up the query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

640 views

1 answer

sql server - SQL query to get the employee name and their manager name from the same table

Employee table Employee_id Employee_name Manager_id ------------------------------------- Emp00001 ... the employee name and their manager name? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

265 views

1 answer

sql - Optimize BETWEEN date statement

I need help in optimize a PostgreSQL query which uses the BETWEEN clause with a timestamp field. I have 2 ... How to optimize this query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

372 views

1 answer

sql - set identity on the column

How can I modify table and set identity on PK column using T-SQL? thanks for help See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

403 views

1 answer

sql - MYSQL count of count?

I have a mysql table like: id, visitorid, pageid When a visitor hits the website it stores their visitor id and the ... to do as a MySQL query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

420 views

1 answer

sql server 2008 - Open the link in new window in crystal report

I have crystal report. There is the column containing the hyperlink. I want whenever click that link that page should ... Can I get any help? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

322 views

1 answer

sql - mysql is array in multiple columns

I have a string in the form $string = 'London,Paris,Birmingham' and I want to search multiple columns for ... of doing something like this. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

363 views

1 answer

sql server 2008 - Avoiding IF ELSE due to variable been NULL

I have some code where variable used in the WHERE clause could be nullable. As a result I have to ... Customers WHERE OrderID = @OrderID END See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

469 views

1 answer

sql - Why does my Entity Framework turn '2.87' into just '2' (decimal field)?

I verfied that the correct value '2.87' is coming into the service.. and accord to the EF diagram the type for ... [Level] int NOT NULL ); GO See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

411 views

1 answer

sql - Mysql DateTime group by 15 mins

I have a table that looks like this CREATE TABLE `time_table` ( `id` INT(10) NOT NULL AUTO_INCREMENT, ` ... show the entire period. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

420 views

1 answer

sql - Postgres INTERVAL using value from table

If I want to add 5 days to a date, I can do it using the INTERVAL function: select create_ts + interval ... can I accomplish this in postgresql? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

328 views

1 answer

sql - Hierarchical Data in MySql

I have a table with parent child relation I want help on recursive query Table structure roleId, roleName, parentId 1 Admin ... 2 -- Off User 1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags