Recent questions tagged SQL

0 votes

403 views

1 answer

sql - Oracle REPLACE() function isn't handling carriage-returns & line-feeds

We've a table with a varchar2(100) column, that occasionally contains carriage-return & line-feeds. We should ... Upgrading is not an option. See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - default a column with empty string

Is there a way, via a SQL statement, to ensure a column's default value is an empty string '' instead of NULL? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql server - Automatically print SSRS report?

Is there a way to automatically print a SQL Server Reporting services (2005) report? EDIT: We needed to print a ... method suggested by Paul G. See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql server 2005 - Checking for time range overlap, the watchman problem [SQL]

I am running into a road block on a larger problem. As part of a large query I need to solve a "night ... of time ranges that must be checked. See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

sql server - Getting a Return Value in C# asp.net from a stored procedure (syntax issue)

I am having issues trying to get the syntax correct for my C# 2008 asp.net code. I need to get a return ... get the syntax correct. Any ideas? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - combining results of two select statements

I'm using T-SQL with ASP.NET, and c# and i'm pretty new to SQL. I was wondering how i could ... would be much appreciated. Thanks in advance See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql server 2008 - Entity Framework 4 Code First - Prevent DB Drop/Create

I've written an ASP.Net MVC 3 application using the Code First paradigm whereby when I make a change ... to the DbModelBuilder conventions. See Question&Answers more detail:os...

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

0 votes

483 views

1 answer

sql - Unable to write to a chmod 777 database file on SQlite3 via php 5.3.0

I'm trying to insert data into my SQlite3 database (this works via the command line). I gave the data1.db file 777 ... ; I'm running PHP 5.3.0 See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql server 2005 - T-SQL: Cannot pass concatenated string as argument to stored procedure

Scenario: Need to pass n arguments to a stored procedure. One of the arguments is of type varchar(x). ... were declared properly as varchar. See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

sql - Insert into from CTE

WITH DTL AS (SELECT CMPI_CODE, CMN_CDTY_MTRL, CMI_WT_FACTOR, CMI_CNTRCT_RATE, 'PL', PRESENT_PRICE, TRM_CODE, ROUND( ... : missing SELECT keyword See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

sql - Using backquote/backticks for mysql queries

I have building MYSQL queries with backticks. For example, SELECT `title` FROM `table` WHERE (`id` = 3) as opposed ... , etc. What do you think? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - Google BigQuery CASE function

I'm trying to run a query like what's answered here, SQL Selecting multiple sums? SELECT SUM(CASE WHEN order_date ... queries I want to run. See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql server - Correct method of deleting over 2100 rows (by ID) with Dapper

I am trying to use Dapper support my data access for my server app. My server app has another application that ... need to be very very fast. See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql server ce - How do I select the first row per group in an SQL Query?

I've got this SQL query: SELECT Foo, Bar, SUM(Values) AS Sum FROM SomeTable GROUP BY Foo, Bar ORDER BY Foo DESC, ... 44 0 2 How do I do that? See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql - How to escape ampersand in TOAD?

When I try to insert a value which has '&' in TOAD I get a prompt for a substitution variable. So when I ... that will help me run the script? See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql server 2008 - How to get first record out of each group from the result retrieved by using group by command

Suppose if my Input is: ID GroupID Qty 1 1 100 2 1 200 3 1 300 4 2 98 5 2 198 6 3 175 7 3 275 8 3 ... how to do it with SQL Server T-SQL query? See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - INSERT into table without specifying Column names

I have INVOICE TABLE I want to insert value by not specifying column names using SQL Server, I have tried this but it ... ,1,KEYBOARD,1,15,5,75) See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - How do I concatenate strings in Entity Framework Query?

How do I concatenate strings in Entity Framework 4 I have a data from a column and I want to save as a ... Is there any solution to this? See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

sql - How can I search by emoji in MySQL using utf8mb4?

Please help me understand how multibyte characters like emoji's are handled in MySQL utf8mb4 fields. See ... test queries return successfully? See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql - how to convert date to a format `mm/dd/yyyy`

I'm having a sql table with date column named CREATED_TS which holds the dates in different format eg. as ... Any help will be appreciated. See Question&Answers more detail:os...

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

0 votes

231 views

1 answer

sql - Recovery after wrong MySQL update query?

I made a wrong update query in my table. I forgot to make an id field in the WHERE clause. So that updated all my ... I didn't have a backup.... See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

sql - Subtract month and day mysql

I need to subtract 1 month and 4 days with mysql, I saw the command DATE_ADD (NOW (), - 1 MONTH) perfect for 1 month ... 31 + 4, 30 + 4, etc. See Question&Answers more detail:os...

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

0 votes

302 views

1 answer

sql - using input from a text file for WHERE clause

I have list of names of employees in a text file. Instead of searching each name one by one, I want to ... the SQL command for it? Thanks. See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql - Oracle database is hanging infinitly in UPDATE queries

suddenly my update queries are not executing . i can make select queries but when i try to update records the ... sql plus and nothing happens. See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql - Resetting Row number according to record data change

I have got the set of data as follow name date x 2014-01-01 x 2014-01-02 y 2014-01-03 x 2014-01-04 and I'm ... -03 1 x 2014-01-04 3 Please help. See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql server - How to get the bounding coordinates for a US postal(zip) code?

Is there a service/API that will take a postal/zip code and return the bounding(perimeter) coordinates so I can ... defines the US zip code. See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - Join two spreadsheets on a common column in Excel or OpenOffice

I have two CSV files with a common column and I want to "Join" the tables together on the common column ... "OpenOffice.org Calc" Suggestions? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - How to group by a Calculated Field

I need to group by a Calculated field ins SQL Server 2005/2008. I have the following sql: select dateadd(day ... it possible ? Thanks in advance See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags