Recent questions tagged SQL

0 votes

388 views

1 answer

sql server - How do I declare and use variables in PL/SQL like I do in T-SQL?

In Sql Server, often times when I'm testing the body of a stored procedure, I copy the body into SSMS, ... text, not in a grid/spreadsheet See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Adding an one-out-of-two not null constraint in postgresql

If I have a table in Postgresql: create table Education ( id integer references Profiles(id), finished YearValue not null ... How do I do this? See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

sql - Performance difference: condition placed at INNER JOIN vs WHERE clause

Say I have a table order as id | clientid | type | amount | itemid | date ---|----------| ... the performance difference is roughly 6 seconds. See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - How to add results of two select commands in same query

I currently have two select commands as per below. What I would like to do is to add the results together in ... output a sum of both results? See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - How can I select records ONLY from yesterday?

I've spent hours searching the web for an answer to this question... Here's what I currently have: select * ... oh where tran_date = sysdate-1 See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql server - Should there be a Transaction for Read Queries?

I've been reading that some devs/dbas recommend using transactions in all database calls, even read-only ... reading within a transaction? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql - How to query for null values in json field type postgresql?

I have a json type field in postgresql. However I can't select rows where specific field is null: Code: ... elem#>'{occupation2}' is null See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - CASE IN statement with multiple values

Is there a way to make a CASE statement with an IN clause? SELECT CASE c.Number IN ('1121231','31242323') ... 2 END AS Test FROM tblClient c See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - What SQLite column name can be/cannot be?

Is there any rule for the SQLite's column name? Can it have characters like '/'? Can it be UTF-8? See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql server - Query to check whether a column is nullable

Query to check whether a column is nullable (null values are allowed in the column or not). It should preferably ... or 1/0 or true/false. See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

sql server - Can I logically reorder columns in a table?

If I'm adding a column to a table in Microsoft SQL Server, can I control where the column is displayed ... scripted from the command line. See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

sql - mysql pivot table date (vertical to horizontal data)

I have been searching for hours without a decent answer. I want to transform this table: Client_id Date ----------- ... 2 2013-02-03 2013-07-15 See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql - MySql auto-incrementing Alpha-numeric primary key?

Is this possible in MySql ?? Can I have an auto-incrementing Primary Key, prefixed with a letter, something like R1234, R1235, R1236... ect ?? See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql - how to pass variable from shell script to sqlplus

I have a shell script that calls file.sql I am looking for a way to pass some parameters to my file.sql. ... .sql? Is there anything like that? See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

sql - Query Excel worksheet in MS-Access VBA (using ADODB recordset)

I'd like to query an Excel worksheet in VBA and specify conditions. The simple query "SELECT * FROM [ ... = adLockOptimistic rs2.Open cmd2 See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Determine varchar content in nvarchar columns

I have a bunch of NVARCHAR columns which I suspect contain perfectly storable data in VARCHAR columns. However I can't ... lost. How do I check? See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Confusion with Oracle CONNECT BY

The query: select level from dual connect by rownum<10; gives numbers from 1 to 9. Another query: SELECT ... is happening behind the scenes? See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql - Find All References to View

I've got various databases, and what to be sure I am removing something (a view in this case) that ... getting the actual procedure name. See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql server 2005 - Query examples in a many-to-many relationship

Wow, it's hard to find a simple explanation to this topic. A simple many-to-many relationship. Three ... you have something lying around? See Question&Answers more detail:os...

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

0 votes

424 views

1 answer

sql server - Verify database changes (version-control)

I have read lots of posts about the importance of database version control. However, I could not find a simple ... is in correct state. Thanks See Question&Answers more detail:os...

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

0 votes

720 views

1 answer

sql server - Do I have use the prefix N in the "insert into" statement for unicode?

Like: insert into table (col) values (N'multilingual unicode strings') I'm using SQL Server 2008 and I already ... as the column data type. See Question&Answers more detail:os...

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

0 votes

489 views

1 answer

sql - doing "points of interest along a route" in google maps

I need to allow travelers to use google maps to plot a route, and then query my database of points of ... .aspx (source: karmatics.com) See Question&Answers more detail:os...

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

0 votes

382 views

1 answer

sql server - How to get sql error in stored procedure

I'm using SQL Server 2005. I created a stored procedure which works most of the time, but I found an ... error text into an output variable? See Question&Answers more detail:os...

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

0 votes

377 views

1 answer

sql - Visiting a directed graph as if it were an undirected one, using a recursive query

I need your help about the visit of a directed graph stored in a database. Consider the following directed ... other "adjacent" node anyway. See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql - Use of xml.modify to insert parameters into specific element of an xml column

I would like to use a stored procedure to insert some values passed in as parameters into elements in the xml of ... the correct way to do this? See Question&Answers more detail:os...

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

0 votes

546 views

1 answer

sql server - How to log in T-SQL

I'm using ADO.NET to access SQL Server 2005 and would like to be able to log from inside the T ... emit messages to DebugView from SysInternals. See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql server - Show empty string when date field is 1/1/1900

I'm querying a database like so: SELECT DISTINCT CASE WHEN CreatedDate = '1900-01-01 00:00:00.000' THEN '' ELSE ... R2. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

sql - What are the down sides of using a composite/compound primary key?

What are the down sides of using a composite/compound primary key? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags