Recent questions tagged SQL

0 votes

199 views

1 answer

I have a table and want to transpose its rows to columns, similar to a pivot table but without ... corresponding question in this scenario. See Question&Answers more detail:os...

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

0 votes

258 views

1 answer

sql - Aggregating (x,y) coordinate point clouds in PostgreSQL

I have a a PostgreSQL database table with the following simplified structure: Device Id varchar Pos_X (int) Pos_Y ... or SQL in general? See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql server - Sort Bullets in Database

I have a column [datatype:varchar(50)] in database (SQL Server 2008) having Values as shown below: 1 2 1.1. ... . Please help me in this regard. See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - Function for week of the month in mysql

I was looking for a simple function to get the week of the month (rather than the easy week of the year) ... is an easier and cleaner solution? See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Replace all fields in MySQL

I need to replace some chars in the columns of a table, by using the REPLACE command. I know that the REPLACE ... one? Is this possible? Thanks See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

sql server - Convert decimal time to hours and minutes

Been struggling with this and can't seem to find the right answer, although there are plenty of mentions for ... me in the right direction. See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql - Access 2010: Syntax error (missing operator) in query expression

I want to have three tables in my sql query but I get an error message. I have this sql code: SELECT warehouse ... = c.drug_i'. Any help please? See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql server - Will GETUTCDATE() return the same value if used twice in the same statement?

I have a trigger that automatically sets the CreationDate and ModifiedDate of the given entry to the current UTC time ... = GETUTCDATE() ... See Question&Answers more detail:os...

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

0 votes

222 views

1 answer

sql - Does 'Select' always order by primary key?

A basic simple question for all of you DBA. When I do a select, is it always guaranteed that my result will be ... I'm using Oracle as my DB. See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql server - T-SQL: How to use parameters in dynamic SQL?

I have the following dynamic query which is working fine without the WHERE clause, which is expecting ... ' EXEC sp_executesql @sql See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - Division of integers returns 0

I feel like I'm missing something obvious. I am trying to test out the distribution of random(). Here is the ... to what I am doing wrong? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - DATEDIFF function in Oracle

I need to use Oracle but DATEDIFF function doesn't work in Oracle DB. How to write the following code in Oracle? ... '2000-01-02') AS DateDiff; See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql server - T-sql - determine if value is integer

I want to determine if a value is integer (like TryParse in .NET). Unfortunatelly ISNUMERIC does not fit me ... = 'MY_FILTER' Thank you See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - SQLServer IDENTITY Column with text

How would I create an IDENTITY column in SQLServer with text in the column? Example: ABCD-987065 ABCD-987066 ABCD-987067 See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - Using NOLOCK Hint in EF4?

We're evaluating EF4 and my DBA says we must use the NOLOCK hint in all our SELECT statements. So I'm ... topic to read this thread. Thanks. See Question&Answers more detail:os...

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

0 votes

277 views

1 answer

sql server - Split one column into multiple rows

Can anyone tell me how to accomplish this? A column in my table, in some instances, contains comma separated values. ... of their own in Col4. See Question&Answers more detail:os...

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

0 votes

471 views

1 answer

sql - Call stored procedure with table-valued parameter from java

In my application I want to execute query like SELECT * FROM tbl WHERE col IN (@list) where,@list can have ... in table-value parameter case? See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Built-in function to capitalise the first letter of each word

I don't want to create a custom function for that if such function already exists in SQL Server. Input string: ... This Is My String To Convert See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql - How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?

I have this as a result of the query: select cast(to_date(a.start_time,'mm/dd/yyyy hh:mi:ss pm') as timestamp) ... is it that I am doing wrong? See Question&Answers more detail:os...

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

0 votes

376 views

1 answer

sql - Array in IN() clause oracle PLSQL

I am passing String array(plcListchar) to Stored Procedure, i would like to use this String array in IN() clause. ... other logic, it is great. See Question&Answers more detail:os...

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

0 votes

225 views

1 answer

sql - Why do we need GROUP BY with AGGREGATE FUNCTIONS?

I saw an example where there was a list (table) of employees with their respective monthly salaries. I did a sum ... and then add them up ? See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - What is the equivalent PostgreSQL syntax to Oracle's CONNECT BY ... START WITH?

In Oracle, if I have a table defined as CREATE TABLE taxonomy ( key NUMBER(11) NOT NULL CONSTRAINT taxPkey ... How is this done in PostgreSQL? See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

sql - How to convert from varbinary to char/varchar in mysql

I have a field which is varbinary. It has already been populated. Now how do i convert varbinary to varchar so ... use a MySQL version 5.10 See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql - In what order are MySQL JOINs evaluated?

I have the following query: SELECT c.* FROM companies AS c JOIN users AS u USING(companyid) JOIN jobs AS j ... j" Any help would be appreciated! See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - ERROR: functions in index expression must be marked IMMUTABLE in Postgres

I want to create a Multicolumn expression index, but when I create the index, the following message is output: - ... skyid | integer | Indexes: See Question&Answers more detail:os...

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

0 votes

264 views

1 answer

sql server - Pros and Cons of using SqlCommand Prepare in C#?

When i was reading books to learn C# (might be some old Visual Studio 2005 books) I've encountered advice to always ... if it's a string etc? See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - Stored Procedure and Permissions - Is EXECUTE enough?

I have a SQL Server 2008 database where all access to the underlying tables is done through stored ... performed within "sp_Executesql". See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql server - T-SQL trim &nbsp (and other non-alphanumeric characters)

We have some input data that sometimes appears with &nbsp characters on the end. The data comes in from the ... this case numeric) characters? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags