Recent questions tagged SQL

0 votes

302 views

1 answer

sql - How to identify all stored procedures referring a particular table

I created a table on development environment for testing purpose and there are few sp's which are refreing this ... database is sql server 2005. See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql server - Sleep Command in T-SQL?

Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web ... 't actually processing a ton of stuff. See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql - What's the difference between CharField and TextField in Django?

The documentation says that CharField() should be used for smaller strings and TextField() should be used for larger ... makes this the case? See Question&Answers more detail:os...

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

0 votes

157 views

1 answer

sql - iCalendar "Field" list (for database schema based on iCalendar standard)

my application has to deal with calendar information (incl. single occurrence, recurrence, etc.). In order to ... for iCal entries)? Thanks! See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - Run a query with a LIMIT/OFFSET and also get the total number of rows

For pagination purposes, I need a run a query with the LIMIT and OFFSET clauses. But I also need a ... faster than running both individually? See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql server - SQL DROP TABLE foreign key constraint

If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? ... NULL DROP TABLE dbo.[Student] See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql - How to create Temp table with SELECT * INTO tempTable FROM CTE Query

I have a MS SQL CTE query from which I want to create a temporary table. I am not sure how to do it ... a temporary table from this CTE query See Question&Answers more detail:os...

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

0 votes

217 views

1 answer

sql server - SQL to determine minimum sequential days of access?

The following User History table contains one record for every day a given user has accessed a website (in a 24 ... coincidental, of course.. :) See Question&Answers more detail:os...

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

0 votes

277 views

1 answer

sql - UPDATE and REPLACE part of a string

I've got a table with two columns, ID and Value. I want to change a part of some strings in the second ... update anything either. Why is that? See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - What did MongoDB not being ACID compliant before v4 really mean?

I am not a database expert and have no formal computer science background, so bear with me. I want to know the ... use SQL for this, etc.). See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - MSSQL - GROUP_CONCAT

Here is the sample data : IdProduit Localisation Qte_EnMain 4266864286880063006 E2-R40-B-T 13.00000 4266864286880063006 ... GROUP BY a.IdProduit See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql server - Unable to Validate Existing email Id using [Remote] data annotation attribute

I want to validate existence of Email Id in database using [Remote] data Annotation in Model. But when I call a ... { return Json(true); } } See Question&Answers more detail:os...

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

0 votes

220 views

1 answer

sql - How to get value using join table with different values?

I have a product, user and product_click model. In product_click, I have column count where I'm keeping a record, ... it not displaying to me. See Question&Answers more detail:os...

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

0 votes

190 views

1 answer

sql - Pivot on multiple fields and export from Access

I have built an access application for a manufacturing plant and have provided them with a report that lists ... to any suggestions. Thanks! See Question&Answers more detail:os...

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

0 votes

189 views

1 answer

sql - Using Start Date and End date in Access query

Please can someone help me with this Access query that I am trying to create? I have a table with a list of ... to achieve this? Many thanks!! See Question&Answers more detail:os...

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

0 votes

326 views

1 answer

sql - How can I give an alias to a table in Oracle?

Why can't I give an alias to a table in Oracle DB? I tried to write a statement like this one: select count( ... an alias to a table in Oracle? See Question&Answers more detail:os...

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

0 votes

217 views

1 answer

sql - Escaping wildcards in LIKE

How do I escape wildcards (_ and %) when using a SQL LIKE operator in Oracle? I came to a silly issue ... least something that works 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 - Unable to create connectionstring for a remote desktop for a C# application

I want to create a Windows service which will copy data from one database to another database. The source ... should know more/check more? See Question&Answers more detail:os...

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

0 votes

336 views

1 answer

sql - ORDER BY with Inner query, giving ORA-00907 missing right parenthesis

I am trying to test a query and getting the ORA-00907 error. I believe that the error is due ... BY TESTCYCL.TC_TESTCYCL_ID,STEP.ST_STEP_ORDER See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - Where should I start with my OPC-UA client?

I need to create something to read data from a PLC and write it to a SQL database. I mostly work with ... m working with. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql - Select one row per index value with max column value

With a table setup with the following fields: SKU, EVENTSTARTDATE, EVENTENDDATE, PRICE, (...etc...) and housing ... 101201, 110102, 14.99 etc. See Question&Answers more detail:os...

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

0 votes

203 views

1 answer

sql server - Column-name and/or table-name as parameters

Given following snippet (MS SQL): DECLARE UpdateList CURSOR FOR SELECT MyColumn FROM MyTable OPEN UpdateList Nothing ... for any tipps sl3dg3 See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql - mysql hierarchy self-join, retrieve all subcategories

I have table categories that contains following columns: category_id category_name parent_id I need to get list of ... and learning material. See Question&Answers more detail:os...

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

0 votes

245 views

1 answer

sql - Some sort of “different auto-increment indexes” per a primary key values

I have got a table which has an id (primary key with auto increment), uid (key refering to users id for ... anyway, I am curious. Thanks. See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql server - SQL IN query produces strange result

Please see the table structure below: CREATE TABLE Person (id int not null, PID INT NOT NULL, Name VARCHAR(50)) ... 'd does not exist in order. See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql - Truncate timestamp to arbitrary intervals

I want to plot my_values with some lower resolution on the time axis than I have in the database. I use something like ... g., 3 hours, 6 hours? See Question&Answers more detail:os...

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

0 votes

177 views

1 answer

sql server - SQL same unit between two tables needs order numbers in 1 cell

I have 2 tables: SELECT UnitId FROM dbo.tblUnits SELECT UnitId, WorkOrderNumber FROM dbo.tblWorkOrders I need to ... ,10 Any Ideas? Thanks See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql server - Slow query with cfqueryparam searching on indexed column containing hashes

I have the following query that runs in 16ms - 30ms. <cfquery name="local.test1" datasource="imagecdn"> SELECT hash ... have to be the DB level. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags