Recent questions tagged SQL

0 votes

234 views

1 answer

sql - Appending data to a MySQL database field that already has data in it

I need to "add" data to a field that already contains data without erasing whats currently there. For example ... reload it into the database? See Question&Answers more detail:os...

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

0 votes

203 views

1 answer

sql - Does the order of fields in a WHERE clause affect performance in MySQL?

I have two indexed fields in a table - type and userid (individual indexes, not a composite). types field ... would it change the behavior? See Question&Answers more detail:os...

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

0 votes

489 views

1 answer

sql - Order by descending date - month, day and year

This seems stupid but, I simply need a list of dates to be ordered with the most recent date at top. Using order ... 2009 12/28/2009 and so on. See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

sql server - How can you convert "tinyint" of t-sql to integer in c#?

I have a tinyint column in the database and I wish to convert it to Int32 for an SqlDataReader. How do i ... - SQL Server Data Type Mappings See Question&Answers more detail:os...

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

0 votes

264 views

1 answer

sql - How to detect if a string contains at least a number?

How to detect if a string contains at least a number (digit) in SQL server 2005? See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql - Does sqlite support any kind of IF(condition) statement in a select

Does sqlite support the sql function "if" in the select statement? for example select if( length( a ) > 4 , a , ... .html but I can't see it. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql server 2005 - SQL Query for Parent Child Relationship

I have db table with parent child relationship as: NodeId NodeName ParentId ------------------------------ ... 6. I am using MS SQL Server 2005 See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql - MySQL: How to determine foreign key relationships programmatically?

Similar to this question but for MySQL.... How can I programmatically determine foreign key references in MySQL ... there's something simpler. See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

sql server - How to install freetds in Linux?

I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here. However, when I ... I use that driver/path? See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql server - XPath to fetch SQL XML value

Here is my problem: from the following XML that is within a column, I want to know if the value of a variable ... /components> </box> </xml>' See Question&Answers more detail:os...

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

0 votes

354 views

1 answer

sql - Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?

Which would be a better option for bulk insert into an Oracle database ? A FOR Cursor loop like DECLARE CURSOR ... either one would be better ? See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql server - Cannot install adventureworks 2012 database - Operating system error 5: Access is denied

I am trying to install AdventureWorks 2012 database in sql server 2012. I got the mdf file ... .2100&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql server - Random Weighted Choice in T-SQL

How do you randomly select a table row in T-SQL based on an applied weight for all candidate rows? For ... equivalent to the respective weight. See Question&Answers more detail:os...

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

0 votes

208 views

1 answer

sql - Sorting on the server or on the client?

I had a discussion with a colleague at work, it was about SQL queries and sorting. He has the opinion that ... of a multi-user system? See Question&Answers more detail:os...

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

0 votes

229 views

1 answer

sql - TSQL - Is it possible to define the sort order?

Is it possible to define a sort order for the returned results? I would like the sort order to be 'orange' ' ... be running on SQL Server 2000. See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Previous Monday & previous Sunday's date based on today's date

I need the correct syntax to give me : Previous week's Monday's date based on the current date/time using GETDATE ... Sunday's date = 09/09/2012 See Question&Answers more detail:os...

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

0 votes

233 views

1 answer

sql - Resetting the time part of a timestamp in Java

In Java, given a timestamp, how to reset the time part alone to 00:00:00 so that the timestamp ... AS DATETIME) AS 'DateTimeAtMidnight'; See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql server - SQL Inner Join On Null Values

I have a Join SELECT * FROM Y INNER JOIN X ON ISNULL(X.QID, 0) = ISNULL(y.QID, 0) Isnull in a ... around that doesn't entail modifying the data See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - ORDER BY "ENUM field" in MYSQL

There is a field 'noticeBy' enum('email','mobile','all','auto','nothing') NOT NULL DEFAULT 'auto'. As ... it possible make order by its values? See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql server 2008 - Adding an INDEX to a CTE

Should be a pretty straight forward question. Can I add an INDEX to a Common Table Expression (CTE)? See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - Select from table by knowing only date without time (ORACLE)

I'm trying to retrieve records from table by knowing the date in column contains date and time. Suppose I have ... only date without the time? See Question&Answers more detail:os...

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

0 votes

229 views

1 answer

sql server - Add a row number to result set of a SQL query

I have a simple select statement. I want to add a temporary column which will number the rows in my result set. ... in a simple manner ? thanks. See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql - How to get the difference between two dates rounded to hours

I'll illustrate what I would like to get in the following example: '2010-09-01 03:00:00' - '2010-09-01 00: ... result should be 2.83 and not 2. See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql server 2008 - Auto-increment primary key in SQL tables

Using Sql Express Management Studio 2008 GUI (not with coding), how can I make a primary key auto-incremented? ... -incremented, but how? Cheers See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - Does Order of Fields of Multi-Column Index in MySQL Matter

I know the importance of indexes and how order of joins can change performance. I've done a bunch of ... vs INDEX name (first_name,last_name) See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Search and replace part of string in database

I need to replace all iframe tags, stored as nvarchar in my database. I can find the entries using the following ... "</a> code after iframe See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - How to connect to a MySQL database from an iPhone?

I am trying to connect to a remote mysql database from an iPhone. I have searched many web sites but I did ... with this please send a solution. See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql server - Table Valued Function Killing My Query Performance

I was having a horrible time today trying to get a query to perform the way I would expect. I had to make a ... change to the plan? Stumped.... See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags