Recent questions tagged SQL

0 votes

1.4k views

1 answer

sql - How to pass parameter in HQL query

find below my HQL query Query query = session.createQuery("select u from UserLog u where u.userLogSerialno = " + "( ... !! Thanks in Advance..!! See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Advisory locks or NOWAIT to avoid waiting for locked rows?

In my Rails 4 app, I have this query to a Postgres 9.4 database: @chosen_opportunity = Opportunity.find_by_sql( " ... better suited to my need? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Replace Unicode characters in T-SQL

How do I replace only the last character of the string: select REPLACE('this is the news with a t', ' ... statement, here are the results: See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - ddmmyyyy to sql datetime in SQL

I need to convert a nvarchar value to datetime in T-SQL. The value is in ddmmyyyy format, e.g. 23072009 I ... -of-range value." Any idea Thanks See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Split IPv4 address into 4 numbers in Oracle sql

I'm trying to split a given IPv4 address into four numbers. In SQL Server this query works well for me: select CAST ... can't find it. Any idea? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Get n grouped categories and sum others into one

I have a table with the following structure: Contents ( id name desc tdate categoryid ... ) I need to do ... make the "Others" record optional? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql - Inserting Multiple Rows in Sybase ASE

(Similar question related to SQL Server : SO Link) I know in Sql Server 2008 or above, you can insert ... based on Transact SQL.. Thanks See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - Database Connection Error "file in use"

I am using Visual Studio 2010 C# Express and SQL Server Management Studio with SQL Server 2012 I am getting ... would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Indexed ORDER BY with LIMIT 1

I'm trying to fetch most recent row in a table. I have a simple timestamp created_at which is indexed. When I ... =35696 width=1752) (2 rows) See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - preventing duplicate row insertion in php/mysql

how do you prevent the entry of duplicate records in php mysql? validating input before insertion to the table. i ... an if...else statement? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - How to monitor just t-sql commands in SQL Profiler?

I have a trouble in monitoring t-sql commands, I want to monitor just commands like: select, insert, update or delete. Can anyone help me? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - poor Hibernate select performance comparing to running directly - how debug?

It's driving me crazy. Making hibernate simple select is so slow, comparing to running that query directly ... , ..CHILD_ID and VALID_FROM_DTTM See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Conditional Operator in SQL Where Clause

I'm wishing I could do something like the following in SQl Server 2005 (which I know isnt valid) for my ... WHERE Team.teamID = @teamid end See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - querying and selecting specific column in SQLAlchemy

How do I select specific columns from a query. For example, just the User name and size of a photo from: ... the User.real_name and the size? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - Printing tree with SQL CTE

The schema is as follows: CREATE TABLE [Structure]( [StructureId] [uniqueidentifier] NOT NULL, [SequenceNumber] [int ... in SQL itself. Thanks See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - java + sqlite: how to open database as read-only?

I have a large database that I want to open in read-only mode... I'm using SQLiteJDBC and am not sure what ... as read-only. Can anyone help? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - SQLite: Combine SELECT and DELETE in one statement

I need to run two statements like so: Select amount from db where ID=5 DELETE from db where ID=5 Currently I ... the row before it is deleted. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - Converting a time into 12 hour format in SQL

How can i convert 24 hour formatted time into 12 hour formatted time in SQL server 2008? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - query for substring formation

I want to take the 01 part of a string abcd_01 using SQL. What should be the query for this, where the length ... , I want part after the _. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - What is the correct syntax for using Database.ExecuteSqlCommand with parameters?

I use Entity Framework 4.2 and want to call a stored procedure that has input parameters. I'm using Database. ... Incorrect syntax near '@p1'. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

sql - Dynamic column in SELECT statement postgres

I am quite new to the postgresql. what is the best way to achieve this? SELECT get_columns() FROM ... with column names generated dynamically. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - What does a caret (^) do in a SQL query?

What is the caret (^) doing in the following SQL Server query? SELECT 1^2, 1^3; which gives the results: ... I found the SQUARE() function. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

sql - postgres dblink escape single quote

Related Link: String literals and escape characters in postgresql Here is my error: ERROR: type "e" does not ... thoughts? Postgres version 8.4 See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - Why is this query slow the first time after I start the service?

Ok. Here's what I try to run: USE tempdb; SELECT TOP 1000000 IDENTITY(INT, 1, 1) Number INTO Numbers ... global temp tables does no different. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - "could not find stored procedure"

I am maintaining a classic ASP website that has a SQL Server 2005 backend. For a small piece of new ... on Windows Server 2003 x64). See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Cannot use Alias name in WHERE clause but can in ORDER BY

Why does this SQL not work? The: 6371 * ACos( Cos(RADIANS(Latitude)) * Cos(RADIANS('50.017466977673905')) * ... Distance What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - SQL: Remove duplicates

How do I remove duplicates from a table that is set up in the following way? unique_ID | worker_ID | date | ... type with the most recent entry. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - T-SQL looping through XML data column to derive unique set of paths

I have XML data column which contains question and answer as part of an application process. What I am trying to ... client> </clients> </log> See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags