Recent questions tagged Sql

0 votes

589 views

1 answer

sql - How to store more than 255 char in MySQL database?

I only get set the text field in MySQL to 255, if I want to store a data longer than 255 chars, what can I do? See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql - How can I reset an MySQL AutoIncrement using a MAX value from another table?

I know this won't work. I tried it in various forms and failed all times. What is the simplest way to achieve the ... ); -> This fails :( Why? See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql server - SQL Row_Number() function in Where Clause without ORDER BY?

I found a bunch of questions on this topic with nice solutions but none of them actually deal with what to ... suggest a workaround for this? See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - MySQL: Order by field size/length

Here is a table structure (e.g. test): Field Name Data Type id BIGINT (20) title varchar(25) Description Text See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - How to compare two tables column by column in oracle

I have two similar tables in oracle in two different databases. For example : my table name is EMPLOYEE and ... tables that are not matching. See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql server - Generate script of All the indexes in a database

I want to generate a script of all the indexes in a database(Create Index). I don't want the index ... for Clustered and Non Clustered Indexes. See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - Is it possible to create a column with a UNIX_TIMESTAMP default in MySQL?

I'm trying to do this, but it seems like MySQL isn't allowing me. Is there a solution to this issue or ... on using epoch time in the database. See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - MySQL Select rows on first occurrence of each unique value

Let's say you have the following table (the column of interest here is cid): +-----+-------+-------+-------+------ ... ---------+--------------+ See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql server - What effect does HOLDLOCK have on UPDLOCK?

I have seen many examples of the HOLDLOCK hint being used in combination with UPDLOCK (like this). However Microsoft's ... the query, if at all? See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - Select where count of one field is greater than one

I want to do something like this: SELECT * FROM db.table WHERE COUNT(someField) > 1 How can I achieve this in MySql? See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql - Using COALESCE to handle NULL values in PostgreSQL

I have the following query SELECT DISTINCT pt.incentive_marketing, pt.incentive_channel, pt.incentive_advertising FROM ... with blank values See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

sql server - What do the different RAISERROR severity levels mean?

My best google result was this: below 11 are warnings, not errors 11-16 are available for use above 16 are ... and how they should be used? See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - How do I convert a database row into a struct

Let's say I have a struct: type User struct { Name string Id int Score int } And a database table with the same ... not sure it's the best one. See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql - Postgres Query of an Array using LIKE

I am querying a database in Postgres using psql. I have used the following query to search a field called tags ... LIKE with an array of text? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql server - SSIS How to get part of a string by separator

I need an SSIS expression to get the left part of a string before the separator, and then put the new string in ... , or at least in SQL Server See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - UPDATE with ORDER BY

Need to "tie" UPDATE with ORDER BY. I'm trying to use cursors, but get the error: cursor "cursupd" doesn' ... "sequence" = 2 already exists. See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql server - How to get column values in one comma separated value

I have a table which contains rows like below ID User Department 1 User1 Admin 2 User1 Accounts 3 User2 ... Finance 3 User3 Sales, Finance See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql server - Can Microsoft store three-valued fields in a single bit?

I'm completely ignorant of SQL/databases, but I was chatting with a friend who does a lot of database work ... what's really going on here? See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql server - SQL - order by list order

I have the following query that returns rows based on a comma seperated list Select * from Table where RecordID ... with SQL? Thanks in advance See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server 2008 - Issues with SQL comparison and null values

I have an update query that updates a field in one table when the value does not match a field in another ... query in order to prevent this? See Question&Answers more detail:os...

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

0 votes

751 views

1 answer

sql - Why does referencing a SQLite rowid cause foreign key mismatch?

SQLite version 3.7.9 2011-11-01 00:52:41 sqlite> PRAGMA foreign_keys = 1; sqlite> CREATE TABLE foo(name); ... that foo.rowid is one column. See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Exists / not exists: 'select 1' vs 'select field'

Which one of the two would perform better(I was recently accused of not being careful with my code because I ... subquery is a Boolean value. See Question&Answers more detail:os...

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

0 votes

327 views

1 answer

sql server - Update a single row with t-sql

I want to update a row in my date base. The problem is, through a mistake on my part, I have two identical ... run the update on just one row? See Question&Answers more detail:os...

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

0 votes

3.2k views

1 answer

sql - Incorrect parameter count in the call to native function 'DATEDIFF'

I get the error from this line SELECT table.field FROM table WHERE table.month = 'october' AND DATEDIFF(day, ... ? If so how? Using MariaDB See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

sql server - I can't add Microsoft.SqlServer.Management.Common to my ASP.NET MVC Application

I am trying to add a reference to the above assembly but it does not appear in my ASP.NET MVC .NET 4 ... know how to reference this Assembly? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Using subquery in a Check statement in Oracle

So I was trying to work this out but it seems that the last line (the check) doesn't allow sub ... Remove the subquery from the statement. See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - using Object_id() function with #tables

I want to ensure if a temporary table exists in my database or not. I tried to use OBJECT_ID() function but ... How can I resolve this problem? See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Keep order from 'IN' clause

Is it possible to keep order from a 'IN' conditional clause? I found this question on SO but in his example ... to keep order of the clause. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags