Recent questions tagged SQL

0 votes

549 views

1 answer

sql server - Can scalar functions be applied before filtering when executing a SQL Statement?

I suppose I have always naively assumed that scalar functions in the select part of a SQL query will only get ... when" construct in the select? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

sql - Difference between a inline function and a view

I am a newbie in using functions and it appears to me that an inline function is very similar to a ... UPDATE statements within a function? See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

sql - Free space in MySQL after deleting tables & columns?

I have a database of around 20GB. I need to delete 5 tables & drop a few columns in some other 3 tables. ... how to go about this. THanks. See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

sql - How to use OUTPUT to capture new and old ID?

For example let say I have, create table product ( ID INT IDENTITY(1,1) NOT NULL, Name VARCHAR(10) ) insert ... ://sqlfiddle.com/#!3/a27b2/1 See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

sql server - SQL script to change all table references in all stored procedures

I have created a new database with copies of existing tables but changed the names of these tables, is ... tables in all stored procedures? See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

sql - MYSQL auto_increment_increment

I would like to auto_increment two different tables in a single mysql database, the first by multiples of 1 and ... best way to replicate this See Question&Answers more detail:os...

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

0 votes

899 views

1 answer

sql server - SSIS package fails with error "If 64-bit driver not installed, run in 32-bit mode"

I am receiving the following error when trying to run the package from the Integration Services catalog in SSMS ... mode. Error code: 0x00000000 See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

sql - The multi-part identifier could not be bound

trying this select tblPersonalInfo.companyname, tblJobBudget.title,tblJobBudget.lastmodifiedby, tblJobAdv.advtitle, tblJobAdv. ... be bound. See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

sql server - How to create CLR stored procedure with Nvarchar(max) parameter?

Is it possible to create CLR stored procedure in SQL Server CLR project having input parameterof type nvarchar(max)? ... have it NVarchar(max)? See Question&Answers more detail:os...

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

0 votes

871 views

1 answer

sql - SELECT single row from child table for each row in parent table

I am trying to get only one row from child table for each parent row with child fields included, I have been ... DEFAULT '', address TEXT ); See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

sql - Add new column without table lock?

In my project having 23 million records and around 6 fields has been indexed of that table. Earlier I tested to ... Postgres with ika db model. See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

sql - How to convert number to words - ORACLE

I have written a very simple query which result a value 500, i need to convert this value like following:- old ... new value = FIVE HUNDERED/= See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

sql server - XQUERY - How to use the sql:variable in 'value()' function?

The query below is trying to select a child node of a given Node. How do I use a variable instead of hard coding the ... ("@Node")]') as X(N) See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

sql - LEFT JOIN vs. multiple SELECT statements

I am working on someone else's PHP code and seeing this pattern over and over: (pseudocode) result = SELECT blah1 ... ? Or am I just nitpicking? See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

sql - MySQL: select first element of a comma-separated list

Unfortunately, I have a field column which contains values like 4 12,3 8,5,6,7 I'm going to write a ... does not provide a "split" function? See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

sql - how to get load time in milliseconds or microseconds in mysql

I' ve searched and searched, but I wasn't able to find an easy way to get this: Query OK, 50000 rows ... microseconds. How can I achieve it? See Question&Answers more detail:os...

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

0 votes

639 views

1 answer

sql - How to remove a prefix name from every table name in a mysql database

I have a joomla mysql database with a table name prefix of "jos_" on all of my table names. But I would like ... the exact sql query I can use? See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

sql - Return value from MySQL stored procedure

So I've finally decided to get around to learning how to use stored procedures, and although I do have them ... . or something like that... See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

sql - How can I make a stored procedure return a "dataset" using a parameter I pass?

I'm very new to Stored Procedures. Say I have a IDCategory (int) and I pass that to a stored procedure. In ... Image. How could I achieve this? See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql - Update with self-join

I want to update a table to indicate that some rows are parents of others, so I added a "parentid" column to the ... the end of the "SET" line. See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

sql - Different value counts on same column

I am new to Oracle. I have an Oracle table with three columns: serialno, item_category and item_status. In the third ... 3 table 12 6 3 3 See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

sql - What is the most elegant way to store timestamp with nanosec in postgresql?

Unfortunately the postgresql timestamp type only can store timestamps with microsec precision but i need the nanosec ... timestamp in bigint? See Question&Answers more detail:os...

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

0 votes

604 views

1 answer

sql - Oracle query to find all occurrences of a charcter in a string

I have to write an Oracle query in toad to find all the occurrences of a character in a string. For ... that pos is an invalid identifier. See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql - MSSQL cast( [varcharColumn] to int) in SELECT gets executed before WHERE clause filters out bad values

Assume the following schema and query: Please look past the glaring design issues with having values in a varchar ... for all of the responses! See Question&Answers more detail:os...

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

0 votes

690 views

1 answer

sql - FOR XML PATH and string concatenation

I am trying to create a value that concatenates both hard coded strings and strings created using FOR XML PATH. ... it return an empty string. See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

sql - Select last N# of columns of a table from MySQL

I have tables with more than 35 columns, the first 20 columns are fixed and the column number is different in each ... = 'table1' ) FROM table1; See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

sql - Convert varchar to time

I have tried the links available here for similar questions before but it does not work. So I am posting my ... .nnnnnnn] Can you please help? See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

sql - Postgres 9.4 jsonb array as table

I have a json array with around 1000 elements of the structure "oid: aaa, instance:bbb, value:ccc". {"_id": 37637070 ... '0' and value1 <> '1'; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags