Recent questions tagged SQL

0 votes

595 views

1 answer

sql - Column name or number of supplied values does not match table definition

In SQL server, I am trying to insert values from one table to another by using the below query: delete from ... same data types. Please help! See Question&Answers more detail:os...

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

0 votes

583 views

1 answer

sql - Database EAV Pros/Cons and Alternatives

I have been looking for a database solution to allow user defined fields and values (allowing an unlimited ... attributes/fields and values? See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

sql server - Getting execute permission to xp_cmdshell

I am seeing an error message when trying to execute xp_cmdshell from within a stored procedure. xp_cmdshell is ... permissions, and what-not. See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql - mysql automatically store record creation timestamp

Is there some way mysql can store timestamp automatically in a record row whenever that it is created. I ... store create timestamp. Thanks See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - How to retrieve JSON data from MySQL?

I have following tables and their relationship. I am storing JSON data in client_services table. Is their any way to retrieve ... -----------+ See Question&Answers more detail:os...

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

0 votes

298 views

1 answer

sql server - TSQL Try / Catch within Transaction or vice versa?

I'm writing a script that will delete records from a number of tables, but before it deletes it must ... must manually commit the transaction. See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql - Split column into multiple rows in Postgres

Suppose I have a table like this: subject | flag ----------------+------ this is a test | 2 subject is ... | 2 Is there an easy way to do this? See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - MySQL INSERT INTO ... VALUES and SELECT

Is there a way to insert pre-set values and values I get from a select-query? For example: INSERT INTO ... to merge this into one statement? See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - Return number of rows affected by UPDATE statements

How can I get the number of rows affected by an UPDATE query in a Stored Procedure (SQL Server 2005), as a ... Table2 Table3 Table4 32 45 0 3 See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Closing connection when using Dapper

Is it necessary to close connection once query is executed explicitly calling Close method or putting the connection ... for future queries? See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

sql - SSIS Package not wanting to fetch metadata of temporary table

I have an SSIS Package, which contains multiple flows. Each flow is responsible for creating a "staging" table ... EndDateTime] [datetime] NULL) See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - Query that ignore the spaces

What's the best way to run a query so that spaces in the fields are ignored? For example, the following queries ... I think this doesn't matter. See Question&Answers more detail:os...

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

0 votes

192 views

1 answer

sql - Name database design notation you prefer and why?

Which notation, methodology and tools for database designing, modeling, diagraming you prefer and why? Which notation ... docs, books, articles. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - Anonymous TABLE or VARRAY type in Oracle

In Oracle, I would sometimes like to create constructs such as these ones SELECT * FROM TABLE(STRINGS('a', 'b', ... at all, the answer is NO See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - formula for computed column based on different table's column

Consider this table: c_const code | nvalue -------------- 1 | 10000 2 | 20000 and another table ... another table's column as an input? See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - How to debug ORA-01775: looping chain of synonyms?

I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging ... , anything would be helpful. See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - Combine two tables for one output

Say I have two tables: KnownHours: ChargeNum CategoryID Month Hours 111111 1 2/1/09 10 111111 1 3/1/09 30 ... the sample data to reflect this. See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - Sort NULL values to the end of a table

Is there a way with PostgreSQL to sort rows with NULL values in fields to the end of the selected ... table ORDER BY somevalue, PUT_NULL_TO_END See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - How to find rows in one table that have no corresponding row in another table

I have a 1:1 relationship between two tables. I want to find all the rows in table A that don't have a ... quickly? What index should I should? See Question&Answers more detail:os...

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

0 votes

237 views

1 answer

sql server 2008 - Select a Column in SQL not in Group By

I have been trying to find some info on how to select a non-aggregate column that is not contained ... ' group by cpe.fmgcms_cpeclaimid See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql - alternatives to REPLACE on a text or ntext datatype

I need to update/replace the data in datatable.column. The table has a field named Content. I'm using the ... be updated with a new solution. See Question&Answers more detail:os...

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

0 votes

201 views

1 answer

sql - What are the principles behind, and benefits of, the "party model"?

The "party model" is a "pattern" for relational database design. At least part of it involves finding commonality ... I'm facing. Thanks. See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql - Return setof record (virtual table) from function

I need a Postgres function to return a virtual table (like in Oracle) with custom content. The table would ... How is this written correctly? See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql - Mysql covering vs composite vs column index

In the following query SELECT col1,col2 FROM table1 WHERE col3='value1' AND col4='value2' If I have 2 ... MYISAM and innodb storage engines ? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null

I am trying to export from my Table data into Excel through T-SQL query. After little research I came up with this ... on a 64-bit SQL Server. See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - updating columns with a sequence number mysql

I have a table with the columns: (this is only an example I have 50K records) Name, Number Joe Null Michael ... SQL for Mysql in one SQL command See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - Why does using an Underscore character in a LIKE filter give me all the results?

I wrote the below SQL query with a LIKE condition: SELECT * FROM Manager WHERE managerid LIKE '_%' AND managername ... ','Sandesh'); Sql-Fiddle See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - How to select the most recent set of dated records from a mysql table

I am storing the response to various rpc calls in a mysql table with the following fields: Table: rpc_responses ... me the most recent response) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags