Recent questions tagged SQL

0 votes

408 views

1 answer

sql server - How can I display the execution plan for a stored procedure?

I am able to view the Estimated Execution Plan (Management Studio 9.0) for a query without a problem but ... plan on exec myStoredProc 234 See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Is there a way to SELECT and UPDATE rows at the same time?

I'd like to update a set of rows based on a simple criteria and get the list of PKs that were changed. I ... there a better way to do this? See Question&Answers more detail:os...

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

0 votes

359 views

1 answer

sql - Create Table from View

I have a view that I want to create a table from in SQL Enterprise Manager, but I always get an error when I ... it possible to use a top 10? See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - oracle - what statements need to be committed?

What are the list of statements that need to be committed before further action on the table in order to avoid ... list): UPDATE INSERT DELETE See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql server - MSSQL in python 2.7

Is there a module available for connection of MSSQL and python 2.7? I downloaded pymssql but it is for ... /stackoverflow.com/a/25749269/362951 See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - IDENTITY_INSERT is set to OFF - How to turn it ON?

I have a deleted file archive database that stores the ID of the file that was deleted, I want the admin to be ... is set to OFF. Any help? See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql server - How to change a table name using an SQL query?

How can I in change the table name using a query statement? I used the following syntax but I couldn ... table Stu_Table rename to Stu_Table_10 See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - printing a value of a variable in postgresql

I have a postgresql function CREATE OR REPLACE FUNCTION fixMissingFiles() RETURNS VOID AS $$ DECLARE deletedContactId ... to the console? 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 - 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package ... think some other patching is needed See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - How do we implement an IS-A Relationship?

We implement an One-to-Many relationship by adding one Table's PK, as FK to the other Table. We implement a ... , but without the role field. See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql - MySQL: Returning multiple columns from an in-line subquery

I'm creating an SQL statement that will return a month by month summary on sales. The summary will list ... DATE_FORMAT(OrdDate,'%Y%m') DESC See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql - Find stored procedure by name

Is there any way I can find in SQL Server Management Studio stored procedure by name or by part of the ... database context) Thanks for help See Question&Answers more detail:os...

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

0 votes

433 views

1 answer

sql - IF-THEN-ELSE statements in postgresql

I'm looking to write a postgresql query to do the following : if(field1 > 0, field2 / field1 , 0) I've ... else return 0 as field3 thank youu See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - Foreign keys in mongo?

How do I design a scheme such this in MongoDB? I think there are no foreign keys! See Question&Answers more detail:os...

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

0 votes

350 views

1 answer

sql - How to list records with date from the last 10 days?

SELECT Table.date FROM Table WHERE date > current_date - 10; Does this work on PostgreSQL? See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Is it possible to use the SELECT INTO clause with UNION [ALL]?

In SQL Server this inserts 100 records, from the Customers table into tmpFerdeen :- SELECT top(100)* INTO tmpFerdeen ... to add the INTO clause. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql server - Can PHP work with a MS SQL database

I work primarly with PHP & MySQL, but I have a potential client with a MS SQL and ASP setup. Due to some ... on this one? Thanks in advance See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql server - How do I preview a destructive SQL query?

When writing destructive queries (e.g., DELETE or UPDATE) in SQL Server Management Studio I always find myself ... surely? Can anyone help? See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql - Getting the number of rows with a GROUP BY query

I have a query to the effect of SELECT t3.id, a,bunch,of,other,stuff FROM t1, t2, t3 WHERE (associate t1 ... 5, but I think this pretty generic. See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql - MySQL - One To One Relationship?

I'm trying to achieve a "One to one" relationship in a MySQL database. For example, let's say I have a ... options are there to achieve this? See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - Difference between drop table and truncate table?

I have some tables that I build as a part of my report rollup. I don't need them afterwards at all. Someone ... them as it would be faster. See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server 2008 - What does "select 1 from" do?

I read some articles but really didn't understand what does select 1 from do? Someone says "you should use ... what does this statement do? See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql server #region

can i create regions in sql server editor (like #region and #endregion in C#) ? See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - The best way to use a DB table as a job queue (a.k.a batch queue or message queue)

I have a databases table with ~50K rows in it, each row represents a job that need to be done. I have ... can shutdown as everything is done) See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql - Select newest records that have distinct Name column

I did search around and I found this SQL selecting rows by most recent date with two unique columns Which is so close to ... 03 4 B 8 2012-05-01 See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - How do I index a database column

Hopefully, I can get answers for each database server. For an outline of how indexing works check out: How does database indexing work? See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql server - SQL query for today's date minus two months

I want to select all the records in a table where their date of entry is older then 2 months. Any idea how I ... FROM FB WHERE Dte > GETDATE() See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql - How to store MySQL query results in another Table?

How to store results from following query into another table. Considering there is an appropriate table already ... .Resource=types.Resource; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags