Recent questions tagged SQL

0 votes

807 views

1 answer

sql server - How to implement FIFO in sql

I working on FIFO implementation in sql. I have Batch number concept in my application. If suppose I am selling ... . Thank you in Advance. See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

sql - ROW_NUMBER() OVER Not Fast Enough With Large Result Set, any good solution?

I use ROW_NUMBER() to do paging with my website content and when you hit the last page it timeout because ... ROW_NUMBER() problem? Any idea? See Question&Answers more detail:os...

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

0 votes

391 views

1 answer

sql server - Can I define which word breakers to use when building a mssql fulltext index?

I have created a fulltext catalog that stores the data from some of the columns in a table, but the contents ... use for finding word breakers? See Question&Answers more detail:os...

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

0 votes

433 views

1 answer

sql server - What are the first issues to check while optimizing an existing database?

What are the top issues and in which order of importance to look into while optimizing (performance tuning, ... database (server) locally? See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

sql - How to change the name of the Athena results stored in S3?

The results of Athena query is saved by the query id (a long string) in S3. I was wondering if there's a ... that can later be easily looked up) See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

sql server - T:SQL: select values from rows as columns

I have a table for Profiles stores profile properties values in row style, ex: [ProfileID] [PropertyDefinitionID] [ ... ] 1 Jone Smith 5000 See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql server - Using bcp utility to export SQL queries to a text file

I debug a stored procedure (SQL Server 2005) and I need to find out some values in a datatable. The procedure ... . How to fix this problem? See Question&Answers more detail:os...

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

0 votes

869 views

1 answer

sql server - SSRS - Process dies/goes to sleep after not being used

Another SSRS question here: We have a development, a QA, a Prod-Backup and a Production SSRS set of servers ... answer to this question. Thanks. See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

sql - Convert Rows to columns using 'Pivot' in mssql when columns are string data type

I need to know whether 'pivot' in MS SQL can be used for converting rows to columns if there is no aggregate ... me......Thanks in advance. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Blank values in Date column returning as 1900/01/01 on running SELECT statement

The column [PAYOFF DATE] has some blank values and some values in mm/dd/yy format. I have to replace '/' with '-' ... ,'-') as date) FROM MTG a See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

sql - Convert PHP while loop to use PDO

I'm currently updating my app by switching to PDO. I have the following code: $stmt = $db->prepare(" ... argument supplied for foreach() error See Question&Answers more detail:os...

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

0 votes

550 views

1 answer

sql - How to subtract 2 dates in oracle to get the result in hour and minute

I want to subtract 2 dates and represent the result in hour and minute in one decimal figure. I have the following ... on. How can I do that? See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

sql server - SET DATEFIRST in FUNCTION

I want to SET DATEFIRST in my function but it is not allowed. SET DATEFIRST 1 I can add the code in ... @my%7)) - @myDeduct)) Select @TotalDays 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 Call a stored procedure from another stored procedure?

I have an insert stored procedure which takes many parameters - 2 of them are @FirstName, @LastName. I ... =@FirstName, @MyLastName=@LastName? See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql server 2008 - How to make a list of T-SQL results with comma's between them?

Suppose we have a simple query like this: SELECT x FROM t WHERE t.y = z If we have one record in the ... of 3 records: Value1, Value2, Value3 See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql - What's a zip join? Have you ever heard of that, or a pairwise join?

This section of Slick's documentation page is quite odd. What is this zip join? It says that it means: a ... outer or inner join? Thanks! See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

sql - Pagination in nodejs with mysql

In my project I need to query the db with pagination and provide user the functionality to query based on current ... am writing a rest api. See Question&Answers more detail:os...

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

0 votes

612 views

1 answer

sql - To find infinite recursive loop in CTE

I'm not a SQL expert, but if anybody can help me. I use a recursive CTE to get the values as below. ... Parent1 --> Parent2 Parent2 --> Child1 See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

sql - How can i speed up this Indexed View?

I have a simple Indexed View. When I query against it, it's pretty slow. First I show you the schema's ... for helping me solve this problem :) See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

sql - Pairwise array sum aggregate function?

I have a table with arrays as one column, and I want to sum the array elements together: > create table regres ... target is: PostgreSQL 9.1.13 See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

sql server - How to determine the datatypes of the results of a SQL?

We have a SQL query that pulls a large number of fields from many tables/views from a database. We ... Microsoft SQL Server Management Studio. See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql server - Invalid Object Name sql

I keep getting an invalid object name error on my sql code. (member_number, subscriber_policy_number) is underlined ... '000000000','000000001') See Question&Answers more detail:os...

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

0 votes

463 views

1 answer

sql - OR WHERE and AND in mySQL Query

Basically, I'm trying to get data from an SQL based on two different groups, t.type has to equal single and t ... working, just not in my head See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

sql server - Is there a practical way to use the hierarchyID datatype in entity framework 4?

As it stands now, the CLR UDTs including HierarchyID aren't supported in Entity Framework 4. HierarchyID.ToString() ... strategies? If so, how? See Question&Answers more detail:os...

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

0 votes

428 views

1 answer

sql - Filter duplicate rows based on a field

I have several records (bills) that are basically duplicates of each other, except for one field, which ... languages in any combination. See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

sql - Count male, female and total

I want to count male, female and total students from Student table for a specific year specified. I wish if ... this happen? Thanks in advance See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

sql - Merging two rows to one while replacing null values

Let's say I've got the following database table Name | Nickname | ID ---------------------- Joe ... manages this (if it's even possible)? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql - Retrieve List of Tables from Specific Database on Server C#

Looking for some C# examples that can retrieve the tables' names from a specific database on a server. I ... later retrieval and manipulation. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags