Recent questions tagged sql

0 votes

287 views

1 answer

sql server - Generate unique random numbers using SQL

I have some SQL code which generates random numbers using the following technique: DECLARE @Random1 INT, @Random2 ... have duplicate numbers! See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql server - SQL query for parent-child chain

I have a single table that can refer to one other member in the table as a parent. That parent could also ... just return that row. thank you See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql - Is NATURAL (JOIN) considered harmful in production environment?

I am reading about NATURAL shorthand form for SQL joins and I see some traps: it just takes automatically ... works) in complicated structures See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql server - SET QUOTED IDENTIFIER should be ON when inserting a record

I am stuck in a rather strange problem with SQL Server 2005, which throws "SET QUOTED IDENTIFIER should be ... problem with the values passed? See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql server - Cyrillic encoding in C#

I have a bunch of Cyrillic-like text in a MSSQL database and need to convert it to Cyrillic in C#. So... ... ), Encoding.UTF8.GetBytes(str))); See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - Temporary Table Scope?

I am making use of temporary tables #tempTable in my stored procedure - that I make use to run my ASP.net Reports ... I get into in the future See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql - Table is mutating, trigger/function may not see it (stopping an average grade from dropping below 2.5)

Here's the problem: Create a trigger that prevents any change to the taking relation that would drop the overall ... advice? I'm using Oracle. See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql - Oracle - update join - non key-preserved table

I'm trying to replicate an Ingres "update tbl1 from tbl2" command, which doesn't exactly exist in Oracle. ... I have no uniqueness violations? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql - Group consecutive rows of same value using time spans

Sorry for the vague title (I just don't know how to describe this conundrum) Give the following schedule table for ... no break in the middle. See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql server - SQL Sort Order with Null values last

I have the following test-code: CREATE TABLE #Foo (Foo int) INSERT INTO #Foo SELECT 4 INSERT INTO #Foo SELECT ... that done using Sql 2005 /M See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - normalizing accented characters in MySQL queries

I'd like to be able to do queries that normalize accented characters, so that for example: é, è, ... AUTO_INCREMENT=56790 DEFAULT CHARSET=utf8 See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

sql - Convert bigint to datetime

I want to convert a value from bigint to datetime. For example, I'm reading the HISTORY table of teamcity server ... it to a datetime value? See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

sql - Select random row from a PostgreSQL table with weighted row probabilities

Example input: SELECT * FROM test; id | percent ----+---------- 1 | 50 2 | 35 3 | 15 (3 rows) How would ... {1=5000, 2=3500, 3=1500}. Any ideas? See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql server - Equivalent of MSSQL IDENTITY Column in MySQL

What is the equivalent of MSSQL IDENTITY Columns in MySQL? How would I create this table in MySQL? CREATE TABLE ... VARCHAR(32) NOT NULL ); See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql - Why is 30 the default length for VARCHAR when using CAST?

In SQL server 2005 this query select len(cast('the quick brown fox jumped over the lazy dog' as varchar)) ... query. Questions remains, why 30? See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - How to bulk update sequence ID postgreSQL for all tables

I imported the Postgres SQL file to my server using TablePlus(SQL client), but after I insert new row I got ... to update all sequences at once? See Question&Answers more detail:os...

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

0 votes

212 views

1 answer

sql - PIVOT dynamically, Returned results from JOIN of two tables

What I thought was a fairly simple query seems to be a bit more tricky then what I anticipated. I have ... appreciated, Thank you in advance. See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql server - SQL: Real Transpose

I know about pivot and unpivot. That is not what I want. Pivot and unpivot aggregate data, but that is ... x-y coordinates have been swapped. See Question&Answers more detail:os...

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

0 votes

321 views

1 answer

sql - CONCAT equivalent in MS Access

I'm doing some work in MS Access and I need to append a prefix to a bunch of fields, I know SQL but it ... 't seem to find a simple translation. See Question&Answers more detail:os...

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

0 votes

183 views

1 answer

sql - How to dynamically use TG_TABLE_NAME in PostgreSQL 8.2?

I am trying to write a trigger function in PostgreSQL 8.2 that will dynamically use TG_TABLE_NAME to generate and ... call just one function. See Question&Answers more detail:os...

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

0 votes

230 views

1 answer

sql - Subtract hours from the now() function

We have a machine running 24x7. Every day I report the number of pieces it produced per hour. In our ... change the date manually everyday? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql server - How to execute SSIS package when a file is arrived at folder

The requirement is to execute SSIS package, when a file is arrived at a folder,i do not want to start the ... ,still expect to start the package See Question&Answers more detail:os...

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

0 votes

230 views

1 answer

sql - CREATE TYPE on MySQL

I couln't create a new data type on MySQL. Query is given below CREATE TYPE PERSON AS OBJECT (NAME VARCHAR (30), ... How can I do that on MySQL See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql server - SQL take just the numeric values from a varchar

Say i have a few fields like the following: abd738927 jaksm234234 hfk342 ndma0834 jon99322 Type: varchar. How do I ... to convert, any ideas? See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql - Conversion failed when converting the nvarchar value ... to data type int

I created the procedure listed below: CREATE procedure getdata ( @ID int, @frm varchar(250), @to varchar(250) ) ... data type int Please help. See Question&Answers more detail:os...

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

0 votes

586 views

1 answer

sql - Execute sp_executeSql for select...into #table but Can't Select out Temp Table Data

Was trying to select...into a temp Table #TempTable in sp_Executedsql. Not its successfully inserted or not but there ... working. how fix it? See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - Distributed transaction error?

In stored procedure I am using below statements. But it throwing Distributed transaction error when I ran ... without creating Temp table? See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - Row Rank in a MySQL View

I need to create a view that automatically adds virtual row number in the result. the graph here is totally ... () AS num FROM mytable See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags