Recent questions tagged SQL

0 votes

805 views

1 answer

sql - How to make Microsoft BCP export empty string instead of a NUL char?

I was working trying to get this bcp tool to work in a particular way. The -c switch is supposed to export using ... file. How do you do that? See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql - How do I order by parent then child?

I am trying to write my SQL Server 2008 query in such a way that I can just loop through my output ... ParentID, Feature FROM Features ORDER BY See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

sql server - SQL massive performance difference using SELECT TOP x even when x is much higher than selected rows

I'm selecting some rows from a table valued function but have found an inexplicable massive performance difference ... like this? Thanks See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

sql - How to do "select current_timestamp" in hsqldb?

Oracle: select systimestamp from dual MySQL: select current_timestamp SQL Server: select current_timestamp PostgreSQL: select ... .8.0.10 See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql server - What is the point of COLLATIONS for nvarchar (Unicode) columns?

IVe read a lot about this. Still some questions : Im not talking about case sensitive here... If I have ... columns ? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

sql - mysql circular dependency in foreign key constraints

Given the schema: What I need is having every user_identities.belongs_to reference an users.id. At the ... maintain referential integrity)? See Question&Answers more detail:os...

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

0 votes

461 views

1 answer

sql - Use a LIKE clause in part of an INNER JOIN

Can/Should I use a LIKE criteria as part of an INNER JOIN when building a stored procedure/query? I'm not sure ... anything else I need to do? See Question&Answers more detail:os...

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

0 votes

527 views

1 answer

sql server - Preserve SQL Indexes While Altering Column Datatype

I have a smalldatetime column that I need to alter to be a datetime column. This is something that will be part of ... so, how can this be done? See Question&Answers more detail:os...

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

0 votes

793 views

1 answer

sql server - Get last Friday's Date unless today is Friday using T-SQL

I'm trying to get the correct SQL code to obtain last Friday's date. A few days ago, I thought I had my code ... (WEEK, 0, GETDATE()), 0)) See Question&Answers more detail:os...

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

0 votes

544 views

1 answer

sql - How can you expand a "condensed" PostgreSQL row into separate columns?

I have a function which returns a table. If you run SELECT * FROM some_function(12345) the result is: ... expand" such a condensed row? See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

sql server - saving the FOR XML AUTO results to variable in SQL

select @[email protected]('*') for xml raw,type Above statement will generate following alert: Msg 6819, ... in a ASSIGNMENT statement. See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

sql - Unable to open BCP host data-file

Below is an example of the BCP Statement. I'm not accustomed to using BCP so your help and candor is ... each column other that documentdate. See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

sql - Composite primary key

I am working on the design of a database that will be used to store data that originates from a number of ... case? Which would you prefer? See Question&Answers more detail:os...

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

0 votes

770 views

1 answer

sql - Find the length of the longest row in a column in oracle

Does anybody know if there is a way to find what the length of the longest row in a column in Oracle? ... for me in SQL developer. Thanks. See Question&Answers more detail:os...

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

0 votes

633 views

1 answer

sql - How to count number of records per day?

I have a table in a with the following structure: CustID --- DateAdded --- 396 2012-02-09 396 2012-02-09 396 ... per day for the last 7 days? See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

sql server - SQL Azure V12 BACPAC import error: "The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version '3.3'"

Until a very few days ago I was able to import a V12 BACPAC from Azure to my local server with SQL Server ... this error. Please help! Thanks See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql server - How to reference one CTE twice?

I have a very fat common table expression which includes row numbers so that I can return a paged result set. I ... the entire 20+ line CTE? See Question&Answers more detail:os...

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

0 votes

482 views

1 answer

sql server - What's the best practice of naming stored procedure for t-sql?

I have worked with several big databases and the names of stored procedures were very different: SP_PrefixXXX PrefixYyyXxx ... in a proper way? See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql server - select TOP (all)

declare @t int set @t = 10 if (o = 'mmm') set @t = -1 select top(@t) * from table What if I want ... 1, that causing TOP to result all elements. See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

sql - Modify materialized view query

I need to modify Materialized view query . Is is possible to do the same without droping and recreating it. See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

sql - Special characters displaying incorrectly after BULK INSERT

I'm using BULK INSERT to import a CSV file. One of the columns in the CSV file contains some values that contain ... ,', ROWTERMINATOR = ' ' ); See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

sql server - check to see if cast is possible

I have the following code to cast nvarchar to integer: cast(@value as int) However I have no control of the ... is possible before doing a cast? See Question&Answers more detail:os...

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

0 votes

527 views

1 answer

sql server - Diff between Top 1 1 and Select 1 in SQL Select Query

I have a general doubt in sql. What is actually "Top 1 1" will do ? What is the meaning of the below query ... "SELECT 1" in sql server query ? See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

sql server - Right pad a string with variable number of spaces

I have a customer table that I want to use to populate a parameter box in SSRS 2008. The cust_num is the value ... to make it cleaner if I can. See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

sql - LEFT INNER JOIN vs. LEFT OUTER JOIN - Why does the OUTER take longer?

We have the query below. Using a LEFT OUTER join takes 9 seconds to execute. Changing the LEFT OUTER to an LEFT ... AND a.SubAssembly = '400' See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql - Checking whether an item does not exist in another table

My tables are set up something like this: table name: process fields: name, id_string table name: value_seach fields: ... How do I do this? See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

sql - Calculate the difference between results of two count(*) queries based on 2 tables in PostgreSQL

I want to calculate the difference between the results of 2 count(*)-type SELECT queries executed on 2 separate ... val2-val1; Thanks in advance See Question&Answers more detail:os...

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

0 votes

542 views

1 answer

sql - MySQL CAST as DATE

I'm trying to understand what casting a value to the DATE type in MySQL does. Here are some things I have tried: ... ) and CAST(expr AS TIME). See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags