Recent questions tagged SQL

0 votes

324 views

1 answer

sql - Find the byte size of a row in PostgreSQL

Assuming I have a table in PostgreSQL, how can I find the exact byte size used by the system in order to save ... the case TOAST is being used). See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

sql - How to update with inner join in Oracle

Could someone please verify whether inner join is valid with UPDATE statment in PL SQL? e.g. Update table t set t. ... id=c.id where d.key=1 See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - How to get a count even if there are no results corresponding mysql?

I am formalating a query to give the number of reports submitted over the last year ordered by date. I get the ... | 0 | Is that possible? See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql - PHP Mysql joins across databases

Lets say I have two separate databases, X and Y, on the same physical server. All of my queries currently ... Thank you all for your responses. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - syntax error when using row_number in sqlite3

I want to remove duplicate through row_number function based on How to get get Unique Records based on multiple ... Anything will be appreciate. See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

sql - oracle 12c - select string after last occurrence of a character

I have below string: ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence So I want to select Sentence since it is the string ... can I do this? See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Select columns with particular column names in PostgreSQL

I want to write a simple query to select a number of columns in PostgreSQL. However, I keep getting errors - ... column like '%2010%' Any ideas? See Question&Answers more detail:os...

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

0 votes

378 views

1 answer

sql - Join a count query on generate_series() and retrieve Null values as '0'

I want to count ID's per month using generate_series(). This query works in PostgreSQL 9.1: SELECT (to_char(serie,'yyyy- ... -03-12 21:58:53') ; See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql server - Entity Framework Code First - Change Table Column Collation

I'm using Entity Framework CTP5 and Code First. I need to change the Collation for a specific column in ... a specific column collation? BarDev See Question&Answers more detail:os...

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

0 votes

546 views

1 answer

sql server - Manually rename tabs in SSMS

I'm always getting confused as to which tab is which in SQL Server Management Studio 2008 R2. I don't find ... way I can manually rename them? See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - PostgreSQL: Create table if not exists AS

I'm using PostgreSQL and am an SQL beginner. I'm trying to create a table from a query, and if I run: CREATE ... " Is there any way to do this? See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - MySQL Counting Distinct Values on Multiple Columns

I wrote a script that runs each time a user logs into a computer in our domain. This script makes a record ... looping some php? (booooo!) See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

sql - Search for a particular string in Oracle clob column

How to get a particular string from a clob column? I have data as below which is stored in clob column ... help is highly appreciable. Regards See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql server - T-SQL Conditional WHERE Clause

Found a couple of similar questions here on this, but couldn't figure out how to apply to my scenario. My ... . What's the correct syntax? See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

sql - Oracle "ORA-01008: not all variables bound" Error w/ Parameters

This is the first time I've dealt with Oracle, and I'm having a hard time understanding why I'm receiving ... receiving doesn't even make sense See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql server - find sql table name with a particular column

Is their any other way or sql query to find the database table names with a particular column than shown below ... WHERE COLUMN_NAME = 'NameID' See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - TSQL: Call a stored procedure from another stored procedure and read the result

I have a stored procedure that, ending with a SELECT, returns a recordset. I can call it within anoher ... get the returning recordset? Thanks See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

sql server - SSIS Connection Manager Not Storing SQL Password

I used to have a dts that had a sql server authentication connection. Basically, the userid password is stored ... have given a good resolution. See Question&Answers more detail:os...

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

0 votes

770 views

1 answer

sql - ORA-01843 not a valid month- Comparing Dates

I have a problem when try to select data from a table filtering by date. For example: ... NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - Deleting part of a string in MYSQL

I want to delete part of a string found in a particular field. For example, the entry in the field could be ... ('fieldname','APS', 1) See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

sql server - SQL performance: Is there any performance hit using NVarchar(MAX) instead of NVarChar(200)

I am wondering if there is any disadvantage on defining a column of type nvarchar(max) instead of giving it a ( ... on the size limit? Thanks! See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

sql server - How to save select query results within temporary table?

I need to save select query output into temporary table. Then I need to make another select query against this ... make this on SQL Server. See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql server - Script all stored procedures in Management Studio 2005

In Enterprise Manager you could script all SPs in a database through the right click menu, is there a way to do it in Management Studio? See Question&Answers more detail:os...

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

0 votes

449 views

1 answer

sql server - Return value from exec(@sql)

I want get the value from Exec(@sql) and assign to @Rowcount(int) Here is my query: 'SET @RowCount = (select ... char)+' and '+@condition+')' See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - MySQL COUNT with LIMIT

What I want to do is SUM a column, but also COUNT the number of rows it is summing, with a limit of no ... assuming it's not actually a bug? See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql - exec failed because the name not a valid identifier?

I have a query I need run it as a dynamic query to output a meaningful column name. As an example, if I run ... Is it because of the full join? See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - Finding free slots in a booking system

In my question about searching for date ranges I tried simplifying the problem and inadvertently posed a different ... algorithm looks like. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - Can I convert a bunch of boolean columns to a single bitmap in PostgreSQL?

I'd like to convert a query such as: SELECT BoolA, BoolB, BoolC, BoolD FROM MyTable; Into a bitmask, where the ... there an easy way to do this? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags