Recent questions tagged SQL

0 votes

365 views

1 answer

sql - Select the first 3 rows of each table in a database

I have a database with 69 tables and I want to select only the first three records of each table. I can do it ... ';' FROM sys.tables EXEC(@sql) See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

sql - Create Temp Table with Range of Numbers

I have a table that has rows with the start and end numbers of a range e.g. key startID endID 1 500 ... is much appreciated. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - SSRS - Keep a table the same width when hiding columns dynamically?

Greetings. I have a SSRS 2005 report that shows prices of things. For some customers, I hide a column from the ... a workaround for me. Thanks! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - connect SQL to apache nifi

I'm new to nifi and i want to connect SQL server database to nifi and create a data flow with the ... this clearly. Thanks in Advance sam See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql - Select Parent and Children With MySQL

I know this question comes up often, but today I can't find the answer I'm looking for. I have a table ... with unions before, or inner joins. See Question&Answers more detail:os...

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

0 votes

462 views

1 answer

sql - How to calculate Running Multiplication

I have two tables WAC table ID wac_inc item -- ----------------- ---- 1 2.310000000000000 A 2 1 ... suggest me the better way of doing it. See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

sql - How do I Get a WPF DataGrid to Save Changes Back to the DataBase?

How do I get a WPF DataGrid to save changes back to the database? I've data-bound my DataGrid control to a ... anyone know what I'm missing? See Question&Answers more detail:os...

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

0 votes

405 views

1 answer

sql - Create Unqiue case-insensitive constraint on two varchar fields

In Oracle 10g, how do I add a unique case-insensitive constraint on two varchar fields? For example, given the ... "Smith" "John", "Swensen" See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql - Update query if statement for Oracle

I need to update newly created column in my oracle table. To do so I need to use existing values in row ... END IF; Any suggestions on syntax? See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

sql - get 2 days ago query in mysql

So for getting last 24 hours query I use something like this SELECT COUNT(*) AS cnt FROM `mytable` WHERE timestamp >= ... ) and 23 ian (00:00am) See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql - Enable Full-Text Search on View with Inner Join

I'm running Sql Server 2008 R2 and I need to enable Full-Text search on a view with a inner join. My ... ) OrderNo(nvarchar(50), not null) See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

sql - Superkey vs. Candidate key

What difference between Super and Candidate key in ERDB? See Question&Answers more detail:os...

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

0 votes

600 views

1 answer

sql - What is the equivalent of REGEXP_SUBSTR in mysql?

I want to extract a word from a string column of a table. description ======================== ... t want to maintain a normalized shadow table. See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

sql server - How to create ordinal numbers (i.e. "1st" "2nd", etc.) in SQL

I recently responded to this question in the SSRS-2008 tag that required changing the day number in a date ... their place in ordinal numbers. See Question&Answers more detail:os...

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

0 votes

489 views

1 answer

sql - GATHER_PLAN_STATISTICS does does not generate basic plan statistics

all, I am learning to tune query now, when I ran the following: select /*+ gather_plan_statistics */ * from ... have missed? Thanks so much. See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

sql - default value of GUID in for a column in mysql

I want a column to default to a GUID, so if I am doing an insert and I don't explicitly set the value, I ... GUID value. how can I do this? See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql server - A reliable way to verify T-SQL stored procedures

We're upgrading from SQL Server 2005 to 2008. Almost every database in the 2005 instance is set to 2000 ... off. SET PARSEONLY OFF GO See Question&Answers more detail:os...

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

0 votes

546 views

1 answer

sql - MySQL error: Unknown column in 'where clause'

I have a table called bank with three columns: uid, nick, balance. I am trying to create a query that will ... what I am doing wrong here? See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql server - What is wrong with my Try Catch in T-SQL?

I am using SQL Server 2008 and when I run this Statement in Management studio the Select statement in the Catch ... handled and the other not? See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql - Are mysql multiple inserts within a Single query atomic?

I'm doing multiple inserts in a single query: INSERT INTO table (c1, c2) VALUES (1,2), (2,3), (3, ... of the values will be inserted/updated? See Question&Answers more detail:os...

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

0 votes

583 views

1 answer

sql - Many-to-many relationship: use associative table or delimited values in a column?

Update 2009.04.24 The main point of my question is not developer confusion and what to do about it. The point ... in a single column? Thanks. See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql - mysql count the sum of all rows

I have a mysql table that has a number of rows, and in each row a field called "value", the field value will ... the "value" fields. any idea? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql server - How to read a file's contents into an SQL variable

Could someone tell me how to read a file's contents into an MS SQL variable using T-SQL? See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

sql - SET CONSTRAINTS ALL DEFERRED not working as expected

In a PostgreSQL 9.3 database, if I define tables a and b as follows: CREATE TABLE a(i integer); ALTER TABLE a ... is not present in table "a". See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

sql - Deleting a row with a self-referencing foreign key

I have a MySQL table whose definition is as follows: CREATE TABLE `guestbook` ( `Id` int(10) unsigned NOT ... or dropping the entire table? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

sql - PostgreSQL: fill NULL values in timeserie query with previous value

I have a database with time related information. I want a list with values for every minute. Like this: 12:00: ... = results.day) ORDER BY date See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql server - What is the difference between an Oracle and Microsoft schema?

I am working on an enterprise project. Some members of the team have an Oracle background and some have a ... Server schema is a namespace. See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

sql - How to replace null values with a text?

I need to display Employee last_name and their commission amount from employees table in Oracle SQL, but the ... with "No Commission". See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags