Recent questions tagged SQL

0 votes

442 views

1 answer

sql server - Create view across multiple databases

I have two databases; 1 is a live database for daily data input and the other is an archival DB for older ... ON Data.Tran_id = Tran.Tran_Id GO See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql - Sane/fast method to pass variable parameter lists to SqlServer2008 stored procedure

A fairly comprehensive query of the brain has turned up a thousand and one ways to pass variable length parameter ... this question as a dupe See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

sql - Error detection from Powershell Invoke-Sqlcmd not always working?

The database is updated by executing a list of queries that are located in a folder. I need to be able to ... $err exit } Remove-Item $tempfile See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - Grouping records hour by hour or day by day and filling gaps with zero or null in mysql

I have written a query that counts records hour by hour: select TO_CHAR(copied_timestamp, 'YYYY-MM-DD HH24'),count( ... BY. Here is the link See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

sql server - How do I BULK INSERT with additional column showing filename?

I'm still getting used to SQL, so before I get to using stored procedure, I would like to understand how ... simple question. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql server - SQL - Stored Procedure with Select Statement using IN (@Variable_CommaDelimitedListOfIDS)

I am creating a stored procedure to which I want to pass as variable a comma delimited list of Ids. I ... I convert the comma delimited list? See Question&Answers more detail:os...

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

0 votes

292 views

1 answer

sql - XML Oracle : Multiple Child Node extract

I have an xml code : <begin> <entry> <lastname>gordon</lastname> <NumberList> <number>100</number> < ... Indonesia Any help would be appreciate. See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - MySql scoping problem with correlated subqueries

I'm having this Mysql query, It works: SELECT nom ,prenom ,(SELECT GROUP_CONCAT(category_en) FROM (SELECT DISTINCT ... work! Can anyone help? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - Select multiple tables when one table is empty in MySQL

I'm trying to do SELECT * FROM a, b However, it doesn't return anything if one of the tables is empty. How ... even if the other one is empty? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql server 2008 - How do I optimize Upsert (Update and Insert) operation within SSIS package?

I am not a DBA but I do work for a small company as the IT person. I have to replicate a database from ... can give anything that's asked for. See Question&Answers more detail:os...

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

0 votes

236 views

1 answer

sql - Why is selecting from stored procedure not supported in relational databases?

It is well known that you cannot perform a SELECT from a stored procedure in either Oracle or SQL Server ( ... two SQL Server stored procedures? See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

sql - How to write a function in the H2 database without using Java

This question is reference to question "How to create stored procedure using H2 database?" (continuation of ... appreciated. Regards Arun See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql server - SQL query for finding rows with special characters only

I am working with SQL Server 2005. I need to find out only those rows for which there is a special character ... ) Alphabtes 2) Digits 3) Space See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

sql - Django ORM - Get latest record for group

Imagine we have the Django ORM model Meetup with the following definition: class Meetup(models.Model): language = ... MySQL as my backend. See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql server - Finding someone's age in SQL

In a SQL Server database, I record people's date of birth. Is there an straight-forward method of working out ... 01 January 2008') returns 1. See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

sql - Concat function is not working - invalid number of arguments

I have a table with two columns(Name, Occupation). I want to output the value in a format something like this. Jane ... should I do to fix it. See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql - Is there a simple way to query the children of a node?

I've been using the crap out of the Nested Set Model lately. I have enjoyed designing queries for just ... is a more straightforward solution. See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql server 2008 - T-SQL Group Rows Into Columns

How can I group an (unknown) number of rows into a single row where the set columns determine the grouping? ... L234 NULL Thanks for any help See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - Select databases which only contain specific table

I'm looking for a way to select all databases on my sql server, which only contain the table "dbo.mytable" ... would like to merge them. Thanks See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

sql - Split a VARCHAR in DB2 to retrieve a value inside

I have a VARCHAR column that contains 5 informations (2 CHAR(3) and 3 TIMESTAMP) separated with '$'. CREATE ... idea to have such columns... See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql - Cross-table UPDATE in SQLITE3

In SQL Server, I can do something like this: UPDATE tbl1 SET col2 = tbl2.col2 FROM table1 tbl1 INNER JOIN table2 ... SQLITE3. Can it be done? See Question&Answers more detail:os...

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

0 votes

533 views

1 answer

sql server - How to Display Page Number in Report Body of SSRS 2008 R2?

I think a lot of developers are facing the problem of try to display page numbers by using SSRS 2008 R2 ... whoever struggling with this issue. See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - How can I optimize/refactor a TSQL "LIKE" clause?

I have a table with 117000 or so records. I need to perform a search that checks 3 separate fields for a ... preferable. Thanks for any help. See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql - in postgres, can you set the default formatting for a timestamp, by session or globally?

In Postgres, is it possible to change the default format mask for a timestamp? right now comes back as 2012-01- ... and reduce a lot of errors. See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - Using IF ELSE in Oracle

As a web developer, I know how to use the IF ELSE in multiple languages. However, I am learning how to write ... salesman := 'ICKY'; END IF; See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql - Getting all the children of a parent using MSSQL query

I have the following data in my database: Parent Child 101 102 101 103 101 104 101 105 101 106 My ... another way to formulate a query? See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql server 2008 - SHA256 in T-sql stored procedure

Is it possible to generate a SHA-256 hash of a string from a stored procedure in Sql Server 2008? For deployment reasons, I'd prefer it in TSQL. See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql server 2008 - SQL LIKE Statement on a DateTime Type

How do you perform a LIKE statement on a column of DateTime datatype in SQL Server? If I run the following ... Server 2008. Thanks in advance. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags