Recent questions tagged sql

0 votes

350 views

1 answer

sql - Force Oracle to return TOP N rows with SKIP LOCKED

There are a few questions on how to implement a queue-like table (lock specific rows, selecting a certain ... get similar behavior in Oracle? See Question&Answers more detail:os...

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

0 votes

302 views

1 answer

sql server 2008 - How to query xml column in tsql

I have a table, T1, with a XML column, EventXML, on SQL Server 2008. I want to query all the rows where ... get all values for "GDP" Indicator; See Question&Answers more detail:os...

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

0 votes

236 views

1 answer

sql server - Why cast/convert from int returns an asterisk

Someone recently asked me this question and I thought I'd post it on Stack Overflow to get some input. Now ... e.g. historical reasons etc?? See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql server - 'Incorrect SET Options' Error When Building Database Project

We are using Visual Studio and a database project to generate our database. I just made a number of ... STATISTICS_NORECOMPUTE = OFF); GO See Question&Answers more detail:os...

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

0 votes

317 views

1 answer

sql server - no sqljdbc_auth in java.library.path

I have a Java EE Web Application which connects to a SQL Server 2008 instance. I don't have any problem ... no sqljdbc_auth in java.library.path See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql server - Change type of a column with numbers from varchar to int

We have two columns in a database which is currently of type varchar(16). Thing is, it contains numbers and ... the way they did it. See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql server - How do I retrieve decimals when rounding an average in SQL

Here is my SQL statement SELECT ROUND(AVG(column_name), 100) FROM [database].[dbo].[table] The answer I retrieve ... or 3.09. Is this possible? See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - Creating a custom ODBC driver

At my current job, we're looking to implement our own odbc driver to allow many different applications to be able ... , which is written in C. See Question&Answers more detail:os...

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

0 votes

219 views

1 answer

sql server - Using variable in SQL LIKE statement

I've got a sproc (MSSQL 2k5) that will take a variable for a LIKE claus like so: DECLARE @SearchLetter2 ... get the un-commented line working? See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql - Select a column if other column is null

I need to select a field called ProgramID from a table and if the ProgramID is NULL then I need to select ... SELECT statement to do this? See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - How to make a view column NOT NULL

I'm trying to create a view where I want a column to be only true or false. However, it seems that no matter what I ... I want it to be BIT. :-) See Question&Answers more detail:os...

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

0 votes

233 views

1 answer

sql - Mysql strip time component from datetime

I need to do a date comparison in Mysql without taking into account the time component i.e. i need to convert ' ... a proper way of doing this? See Question&Answers more detail:os...

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

0 votes

210 views

1 answer

sql - MySQL optimizing INSERT speed being slowed down because of indices

MySQL Docs say : The size of the table slows down the insertion of indexes by log N, assuming B-tree ... key, totally taking ~165 seconds See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql server - Should I use an inline varchar(max) column or store it in a separate table?

I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you ... the database and achieving nothing? See Question&Answers more detail:os...

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

0 votes

206 views

1 answer

sql - Difference between "and" and "where" in joins

Whats the difference between SELECT DISTINCT field1 FROM table1 cd JOIN table2 ON cd.Company = table2.Name and ... have the same explain output See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - How to find all IDs of children recursively?

I would like to get all IDs from children in a tree with MySQL only. I have a table like this: ID parent_id ... any way how to achieve that? See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql - MySQL is not inserting a backslash

In MySQL, when I try to insert a backslash into my table, it does not accept it and gives me the content ... . See note following the table. See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql - How to define a trigger ON COMMIT in Oracle?

Is there any way in oracle database to define trigger which will be fired synchronously before COMMIT (and ... specified table is changed? See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql - Django prefetch_related with limit

Is there a way to tell prefetch_related to only fetch a limited set of related objects? Lets say I am fetching ... like this in raw SQL? See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

sql - Conversion failed when converting the varchar value 'simple, ' to data type int

I am struggling for a few days with this issue and I can't figure out how can I fix it. I would like to ... me please? I am desperate. Thanks. See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql server - SQLServer vs StateServer for ASP.NET Session State Performance

I'm studying for a MS certification and one of the practice tests I'm doing has a question where the point ... ) and most importantly, why? See Question&Answers more detail:os...

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

0 votes

280 views

1 answer

sql server - How to insert a record with only default values?

If I have an SQL table with all default columns (e.g. identity column + any number of columns all with default ... values! ) What's the trick? See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Is there any point using MySQL "LIMIT 1" when querying on indexed/unique field?

For example, I'm querying on a field I know will be unique and is indexed such as a primary key. Hence I ... time if the field is indexed? See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql - mysql count group by having

I have this table: Movies (ID, Genre) A movie can have multiple genres, so an ID is not specific to a genre, ... instead of a list of count(*)? See Question&Answers more detail:os...

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

0 votes

419 views

1 answer

sql server 2008 - Text was truncated or one or more characters had no match in the target code page When importing from Excel file

I have an excel file with four text columns: one of them is called ShortDescription which has the longest value. I ... no luck. any ideas ??? See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)

I am using SQL Server 2008 R2. It is working fine. But recently, I have changed my hosting server and I came ... How can I prevent this issue ? See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - How do I create a stored procedure that will optionally search columns?

I'm working on an application for work that is going to query our employee database. The end users want the ... level. Can this be done? See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - Repeat Rows N Times According to Column Value

I have following table. Table A: ID ProductFK Quantity Price --------------------------------------------- ... 11 2 1 150 11 2 1 150 12 1 1 120 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags