Recent questions tagged SQL

0 votes

233 views

1 answer

sql - Creating new database from a backup of another Database on the same server?

I am trying to create a new database from an old backup of database on the same server. When using SQL ... ? Thanks, all help appreciated. See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql server - Simple DateTime sql query

How do I query DateTime database field within a certain range? I am using SQL SERVER 2005 Error code below ... Incorrect syntax near '12'." See Question&Answers more detail:os...

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

0 votes

221 views

1 answer

sql - Is it better to create an index before filling a table with data, or after the data is in place?

I have a table of about 100M rows that I am going to copy to alter, adding an index. I'm not so concerned ... data first and then add the index? See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql - Get mySQL MONTH() to use leading zeros?

How do I specify to mySQL's MONTH() function to return '08' instead of 8 in this query? I'd like the sort ... ) GROUP BY date ORDER BY date ASC See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - fastest way to export blobs from table into individual files

What is the fastest way to export files (blobs) stored in a SQL Server table into a file on the hard drive? ... Studio will run out of memory. See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql server - Alter column, add default constraint

I have a table and one of the columns is "Date" of type datetime. We decided to add a default constraint to ... a better name for the column) See Question&Answers more detail:os...

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

0 votes

255 views

1 answer

sql server - How to migrate a PostgreSQL database into a SQLServer one?

I have a PostgreSQL database that I want to move to SQL Server -- both schema and data. I am poor so I don' ... of trick that does what I want? See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql - Get execution time of PostgreSQL query

DECLARE @StartTime datetime,@EndTime datetime SELECT @StartTime=GETDATE() select distinct born_on.name from born_on ... ,@EndTime datetime See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

sql server - The report definition has an invalid target namespace rsInvalidReportDefinition

I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the ... this doesn't work either. See Question&Answers more detail:os...

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

0 votes

232 views

1 answer

sql - Rails 4 Accessing Join Table Attributes

I have a has_many through join table setup for a recipe app where Ingredient and Meal connect through MealIngredient. ... advance for any help! See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql - Query to find n?? max value of a column

I want to find 2nd, 3rd, ... nth maximum value of a column. See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Convert output of MySQL query to utf8

I have a table in my database and I want run a query like SELECT column1, column2 FROM my_table WHERE my_condition; ... such task? What is that? See Question&Answers more detail:os...

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

0 votes

550 views

1 answer

sql server - Differences Between Drivers for ODBC Drivers

I was setting up the System DSN (64 bit) for my database in SQL server 2016 with Windows 10 64 bit ... difference between them? Thanks, Jason See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - PostgreSQL query to count/group by day and display days with no data

I need to create a PostgreSQL query that returns a day the number of objects found for that day It's ... giant PostgreSQL book soon ;) See Question&Answers more detail:os...

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

0 votes

302 views

1 answer

sql - Stored Procedures Vs. Views

I have used both but what I am not clear is when I should prefer one over the other. I mean I know stored ... I prefer one over the other ? See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

sql - What is the fastest way to truncate timestamps to 5 minutes in Postgres?

Postgres can round (truncate) timestamps using the date_trunc function, like this: date_trunc('hour', val) date_trunc ... that I've overlooked. See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - Add row to query result using select

Is it possible to extend query results with literals like this? select name from users union select name from ('JASON'); ... ', or (25,'Betty'). See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - Getting new IDs after insert

I'm inserting a bunch of new rows into a table which is defined as follows: CREATE TABLE [sometable]( [id] [ ... () Is there a better pattern? See Question&Answers more detail:os...

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

0 votes

513 views

1 answer

sql - Rails: Get next / previous record

My app has Photos that belong to Users. In a photo#show view I'd like to show "More from this user", ... for multiple next / previous photos? See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql - How to select last 6 months from news table using MySQL

I am trying to select the last 6 months of entries in a table, I have a column called datetime and this ... which method should I use? Thanks See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql server - Disable Transaction Log

Oracle has SQL commands that one can issue so that a transaction does not get logged. Is there something ... them on developer machines. See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - List stored functions that reference a table in PostgreSQL

Just a quick and simple question: in PostgreSQL, how do you list the names of all stored functions/stored ... table in the same manner? See Question&Answers more detail:os...

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

0 votes

428 views

1 answer

sql - Generate a random number in the range 1 - 10

Since my approach for a test query which I worked on in this question did not work out, I'm trying something ... only numbers between 1 and 10? See Question&Answers more detail:os...

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

0 votes

557 views

1 answer

sql server - How to get difference of days/months/years (datediff) between two dates?

I am looking for a way to implement the SQLServer-function datediff in PostgreSQL. That is, this function returns ... idea about the other two? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql server - Declare variable in table valued function

How can I declare a variable in a table valued function? (like in my title) See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql - MySQL auto-store datetime for each row

In MySQL, I'm sick of adding the columns dt_created and dt_modified (which are date time stamps for creation and ... and let me retrieve it? See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - Postgresql extract last row for each id

Suppose I've next data id date another_info 1 2014-02-01 kjkj 1 2014-03-11 ajskj 1 2014-05-13 kgfd 2 2014- ... -12 fdsA How could I manage that? See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql - Copy table structure into new table

Is there a way to copy the structure of a table into a new table, without data, including all keys and constraints? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags