Recent questions tagged sql

0 votes

608 views

1 answer

sql - The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

I have a problem when trying to add a foreign key to my tblDomare table; what am I doing wrong here? CREATE ... "dbo.tblBana", column 'BanNR'. See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql - NOT DEFERRABLE versus DEFERRABLE INITIALLY IMMEDIATE

I read this about the SQL keyword DEFERRABLE in Database Systems - The Complete Book. The latter [NOT ... after each individual statement. See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?

In PostgreSQL I have a table with a varchar column. The data is supposed to be integers and I need it in ... error during the cast in postgres? See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT

I'm looking at the AdventureWorks sample database for SQL Server 2008, and I see in their creation scripts that ... first way versus the second? See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

sql server - nvarchar(max) vs NText

What are the advantages and disadvantages of using the nvarchar(max) vs. NText data types in SQL Server? I don' ... for those data-types later. See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql - MySQL Multiple Joins in one query?

I have the following query: SELECT dashboard_data.headline, dashboard_data.message, dashboard_messages.image_id FROM ... my query? See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql - How do I change db schema to dbo

I imported a bunch of tables from an old sql server (2000) to my 2008 database. All the imported ... .MovieData Desired result: dbo.MovieData See Question&Answers more detail:os...

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

0 votes

216 views

1 answer

sql - Relational Data Model for Double-Entry Accounting

Assume there is a bank, a large shop, etc, that wants the accounting to be done correctly, for both internal ... and with each other (transfer). See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

sql - How can I select rows with most recent timestamp for each key value?

I have a table of sensor data. Each row has a sensor id, a timestamp, and other fields. I want to ... correct way to approach this problem? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - How do you interpret a query's explain plan?

When attempting to understand how a SQL statement is executing, it is sometimes recommended to look at the explain plan. ... that's not right." See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - Database Naming Conventions by Microsoft?

I found Naming Guidelines from MSDN, but is it any guideline for MSSQL database from Microsoft? See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql server - The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'

I'm having problems executing a function. Here's what I did: Create a function using SQL Server Management Studio. ... 'zzzzzzz', schema 'dbo'. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql server - How to find slowest queries

Using Sql Server 2005 Profiler, what events, columns, and filters do you trace to find your slowest queries and ... 10 for sake of argument. See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql - Two single-column indexes vs one two-column index in MySQL?

I'm faced with the following and I'm not sure what's best practice. Consider the following table (which will ... be sufficient / the same? See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - How to find a table having a specific column in postgresql

I'm using PostgreSQL 9.1. I have the column name of a table. Is it possible to find the table(s) that has/have this column? If so, how? See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

sql - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I have installed MySQL server and trying to connect to it, but getting the error: Can't connect to local MySQL ... help me with this problem? See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - How to retrieve the current value of an oracle sequence without increment it?

Is there an SQL instruction to retrieve the value of a sequence that does not increment it. Thanks. EDIT AND CONCLUSION ... ever want to do it. See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - Search an Oracle database for tables with specific column names?

We have a large Oracle database with many tables. Is there a way I can query or search to find if there ... tables I need to search through. See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql - Optimistic locking in MySQL

I can't find any details on optimistic locking in MySQL. I read that starting a transaction keep updates on ... default behavior? Thanks guys. See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table? See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql server - Difference between database and schema

What's the difference between a Database and a Schema in SQL Server? Both are the containers of tables and ... when the Database is deleted? See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql server - How to export all data from table to an insertable sql format?

I have a Table (call it A_table) in a database (call it A_db) in Microsoft SQL Server Management Studio, and ... any other option to do that? See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - Postgres and Indexes on Foreign Keys and Primary Keys

Does Postgres automatically put indexes on Foreign Keys and Primary Keys? How can I tell? Is there a command that ... all indexes on a table? See Question&Answers more detail:os...

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

0 votes

600 views

1 answer

sql - What is the difference between a stored procedure and a view?

I am confused about a few points: What is the difference between a stored procedure and a view? When should I use ... points, if there are any. See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - MySQL OPTIMIZE all tables?

MySQL has an OPTIMIZE TABLE command which can be used to reclaim unused space in a MySQL install. Is there a ... d have to script up yourself? See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql - Is it possible to see the structure of mulitple table with a single "desc".

Is it possible to see the structure of multiple table with a single "desc". i have created following table ... Is it possible in anyway? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Return number from Oracle Select statement after parsing date

I want to write a Oracle SQL select statement that tells if it could parse a date string in the given ... itself. Please help. Thanks Dileep See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql - I need to pass column names using variable in select statement in Store Procedure but i cannot use dynamic query

Here is my SQL query below. I want to select values from the column names given as variables. ... FROM [HR_EmployeeProvisions] EPV See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags