Recent questions tagged SQL

0 votes

656 views

1 answer

sql - Why isn't Postgres using the index?

I have a table with an integer column called account_id. I have an index on that column. But seems Postgres doesn ... idea why that would be? See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

sql - Passing array of a composite type to stored procedure

I'm probably doing something wrong with forming the literal. Suppose I have a simple stored procedure like this ... Thanks for any suggestions. See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

sql - PostgreSQL count number of times substring occurs in text

I'm writing a PostgreSQL function to count the number of times a particular text substring occurs in another piece ... in advance for your help. See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

sql server - Run Python Script from MSSQL

I want to Run or Execute a Python Script from MSSQL 2008. I have a server with python, and what i want is ... support Have a really nice day! See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

sql - Select rows until a total amount is met in a column (mysql)

I have seen this issue in SF, but me being a noob I just can't get my fried brain around them. So ... table for supplier info. Qty - double See Question&Answers more detail:os...

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

0 votes

747 views

1 answer

sql server - Scope_Identity() returning incorrect value fixed?

I've been searching hi and low for an answer to this and figured I would turn to the stackoverflow community. I have ... a yes or no to this. See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

sql server - Implicit conversions and rounding

Just come across an interesting one: declare @test as int set @test = 47 select @test * 4.333 returns 203.651 ... doesn't seem intuitive to me. See Question&Answers more detail:os...

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

0 votes

552 views

1 answer

sql server - Where to set a UTC datetime value in n-tier application: Presentation Layer, Domain, or Database?

This seems like it should be an obvious question, but I have had some issues finding a good answer. I am ... a Nutshell, O'Riely books. See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

sql - Join tables on nearest date in the past, in MySQL

I have a sqlite query that I'm trying to write. I have two tables: TableA (sales): id sales date TableB (goals): ... t figure out how to do it.. See Question&Answers more detail:os...

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

0 votes

727 views

1 answer

sql server - ON is part of syntax

Is it possible to write inner join or outer join without specfying the condition? Is ON condition is part of the syntax of join condition? See Question&Answers more detail:os...

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

0 votes

640 views

1 answer

sql - "Instead of" Triggers in mysql

I have a customer. CREATE TABLE `customer` ( `cNic` VARCHAR(50) NOT NULL DEFAULT '', `cName` VARCHAR(100) NULL ... a way to do this in mysql. See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

sql - ORACLE How to use spool with dynamic spool location

Ok, so i'm a complete newb with oracle. Now that that's out of the way; I think you can get an ... change that &colname Thanks for your help. See Question&Answers more detail:os...

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

0 votes

867 views

1 answer

sql - MySQL: Unable to use SIGNAL in Trigger

I am trying to generate an error message using the MySQL trigger. Below is my code: DELIMITER $$ CREATE ... version dependent. Any advice? See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql server - What causes a TypeLoadException on Migrate.exe for EF6?

I'm trying to run EF's migrate.exe from the command line as part of our build process. This is my actual ... This is on a SQL Server database. See Question&Answers more detail:os...

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

0 votes

584 views

1 answer

sql server - Sql Function Issue "The last statement included within a function must be a return statement"

In the below SQL function I have to return value based on condition but it throws a error. "The last statement included ... 23:59:59')) END END See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

sql - PostgreSQL use value from previous row if missing

I have a following query: WITH t as ( SELECT date_trunc('hour', time_series) as trunc FROM generate_series(' ... accomplish this. Any advice? See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

sql - CASCADE Delete in many-to-many self-reference table

Table DISPLAY_TAB below is a self-reference table that can contain both parent and child tabs. A parent tab ... tables should be deleted. See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

sql - How to prevent SSIS from writing column names to the flat file output?

I am getting the output in flat file as shown below. How do I avoid column names from being written to the flat file output? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

sql server - Query to find list of *all* SSRS DataSets across *all* SSRS reports on ReportServer instance

I'd like to generate a list of all SSRS reports and their corresponding DataSets (not Data Sources) and their ... dropdown list in parameters). See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

sql - VS2010 Macro/Add In for "Run" and "Run On" commands in Visual Studio 2010

Much to annoyance of many developers Microsoft have removed the "Run" and "Run On" commands in Visual ... and replicates this functionality? See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

sql - Generating Rows Based on Column Value

One of my tables in my database contains rows with requisition numbers and other related info. I am trying to ... based on the Quantity value. See Question&Answers more detail:os...

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

0 votes

637 views

1 answer

sql server - How to stop EF4.1 Code-First to create Culstered index for the entity PK

With the following simple entity class, EF4.1 Code-First will create Clustered Index for the PK UserId column ... goals. Thanks in advance See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

sql - Oracle equivalent of ROWLOCK, UPDLOCK, READPAST query hints

In SQL Server I used the following hints inside queries: rowlock (row level locking) updlock (prevents dirty reads ... -query hints for Oracle? See Question&Answers more detail:os...

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

0 votes

612 views

1 answer

sql - What's the best way to delete all data from a table?

I have a SQLite table with 6 million rows. Doing a DELETE FROM TABLE is quite slow; Dropping the table and ... way to delete all data quickly? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

sql - Allow non ascii characters in MySQL database

Recently a record was inserted into my mysql database containing russian letters. The database couldn't display ... languages on my website? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

sql - Convert HEX value to CHAR on DB2

In connection with data replication from SQL Server to DB2 I have the following question: On DB2 I have a ... used in the CONVERT statement. See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

sql server - Create geography polyline from points in T-SQL

I have a table schema that looks like this: CREATE TABLE [dbo].[LongAndLats]( [Longitude] [decimal](9, ... a geography polyline using TSQL? See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

sql - How to make a column invisible in an ssrs matrix

I have an ssrs matrix , the design of which looks like this : The sql query used in the above dataset looks like ... me know if it is possible. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags