Recent questions tagged SQL

0 votes

633 views

1 answer

sql server - SQL to return list of years since a specific year

I need a list of years as a recordset starting with 2004 to current year (in desc order), without writing a ... : 2009 2008 2007 2006 2005 2004 See Question&Answers more detail:os...

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

0 votes

584 views

1 answer

sql - Convert a string to a date in Access

I'm migrating data between tables in Access 2003. In the old table, the date was stored as a text field in ... results. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

sql - Array combinations without repetition

I would like to make combinations out from an int[] {2,4,6,7,8,10,13,15,16,18} should give ... only solution without using custom functions? See Question&Answers more detail:os...

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

0 votes

784 views

1 answer

sql server - Why/when/how is whole clustered index scan chosen rather than full table scan?

IMO, please correct me... the leaf of clustered index contains the real table row, so full clustered index, ... .devx.com/dbzone/Article/29530 See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

sql - Caculate point 50 miles away (North, 45% NE, 45% SW)

In PostGIS, Is there a way to calculate another point 50 miles away in different directions? Given a point, ('New ... do it. not hard code it. See Question&Answers more detail:os...

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

0 votes

888 views

1 answer

sql - How to generate/autoincrement guid on insert without triggers and manual inserts in mysql?

Im revisiting my database and noticed I had some primary keys that were of type INT. This wasn't unique ... was hoping something has changed? See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

sql server - WinRT System.Data - Connect to SQL

Just want to make sure I am not missing something. There does not appear to be a WinRT System.Data. What I ... in a App Store compliant manner. See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql server - Find Mondays between 2 dates

I need to display dates of all Mondays in the given date range. For example, if my start date is 01/05/2015 ... 25/05/2015 How is it possible? See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql - Distance between two coordinates, how can I simplify this and/or use a different technique?

I need to write a query which allows me to find all locations within a range (Miles) from a provided location ... now which is an improvement. See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

sql - Use accent senstive primary key in MySQL

Desired result : Have an accent sensitive primary key in MySQL. I have a table of unique words, so I use ... both returns the same row: demande See Question&Answers more detail:os...

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

0 votes

471 views

1 answer

sql server - My VARCHAR(MAX) field is capping itself at 4000; what gives?

I have a table in one of my databases which is a queue of emails. Emails to certain addresses get accumulated into ... E.ROWID = R.ROWID END See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

sql server - T-SQL get number of working days between 2 dates

I want to calculate the number of working days between 2 given dates. For example if I want to calculate the working ... an easy way to do this. See Question&Answers more detail:os...

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

0 votes

581 views

1 answer

sql - Getting a Dynamically-Generated Pivot-Table into a Temp Table

I've seen this, so I know how to create a pivot table with a dynamically generated set of fields. My problem now ... SQL. Is there a better way? See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

sql - Identity-like column but based on Group By criteria

In my SQL Server 2012 database, I'm creating a "Tasks" table that will have a compound primary key composed of ... work. Thanks all in advance. See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

sql - Is there a way to insert an auto-incremental primary id with a prefix in mysql database?

I'm trying to insert a data as a primary ID that has one alphanumerical value and two numerical value in MySQL ... there any way to do this? See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql server - How to store passwords in database securely?

I have read that one way to store passowrds in a database is by the following way. To have a database ... information of the user? Thanks. See Question&Answers more detail:os...

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

0 votes

497 views

1 answer

sql server - PHP MS SQL Unix Driver - Microsoft or FreeTDS

I am running a LAMP server but now need to connect to MS SQL (client request). I have heard Microsoft has a ... of course). I am running PHP5. See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

sql server - How can we view the encrypted stored procedure's body in SSMS?

I created a new stored procedure WITH ENCRYPTION statement, now I want to view its body. What is the solution? See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

sql - Split comma separated string table row into separate rows using TSQL

Say I have a query that returns the following ID SomeValue 1 a,b,c,d 2 e,f,g Id like to return this as ... shoudl the SQL look to achieve this? See Question&Answers more detail:os...

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

0 votes

970 views

1 answer

sql server - how to skip a bad row in ssis flat file source

I am reading in a 17-column CSV file into a database. once in a while the file has a "less then 17-column ... fails. How to ignore those rows? See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

sql - Preserve parent-child relationships when copying hierarchical data

We have a table representing a tree of values associated with an entity (call it a project), where the ... I quickly abandoned that route! See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql - Pass extra parameter to PostgreSQL aggregate final function

Is the only way to pass an extra parameter to the final function of a PostgreSQL aggregate to create ... COMPUTE_METHOD') FROM blablabla Thanks See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql server - SQL convert number to string representation of any base (binary, hexadecimal, ..., tricontahexadecimal)

How to convert a number to it string representation for a desired numeric base using SQL, for example convert 45 to ... base form 2 to 36. See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

sql - group_concat in Informix

Looking for a query in Informix's SQL that will simulate MySQL's group_concat function. What MySQL's group_concat ... use a stored procedure? See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql server - How to SELECT * but without "Column names must be unique in each view"

I need to encapsulate a set of tables JOINs that we freqently make use of on a vendor's database server. We reuse ... (i.e. the ID ones) Thanks See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql server - How to get all errors of all SSIS packages in a solution

In Visual Studio 2015 I have a solution with 3 dozens dtsx in the SSIS Packages Folder. I re-build the solution ... open all dtsx one by one? See Question&Answers more detail:os...

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

0 votes

933 views

1 answer

sql - How to replace non-numeric characters in MySQL?

I want to replace all non-numerical characters in a VARCHAR field in MySQL, because is a phone table and while ... () calls, Thanks in advance See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

sql - Msg 8672, Level 16, State 1, Line 1 The MERGE statement attempted to UPDATE or DELETE the same row more than once

Am trying to perform a update/insert ... i get the error :(Msg 8672, Level 16, State 1, Line 1 The ... RowType,tmp.RowStatus,'N',GETDATE()); See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags