Recent questions tagged SQL

0 votes

547 views

1 answer

sql server - How can I find duplicate entries and delete the oldest ones in SQL?

I've got a table that has rows that are unique except for one value in one column (let's call it 'Name ... apart from simple queries. Any ideas? See Question&Answers more detail:os...

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

0 votes

496 views

1 answer

sql - How can I expand out a row into multiple row result set?

I have a table that I'm trying to break out each row into one or more rows based on the second column value ... this that I am missing. Thanks. See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql server - Joining a table based on comma separated values

How can I join two tables, where one of the tables has multiple comma separated values in one column that reference an ... | oracle 4 | dot net See Question&Answers more detail:os...

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

0 votes

509 views

1 answer

sql - "Ambiguous column name" error on one particular server

This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We ... some reasons I can't. See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

sql server - Unexpected @@rowcount behavior inside an UDF in MS SQL 2019

here's my sample code drop function rowcount_test go CREATE FUNCTION dbo.rowcount_test () RETURNS INT AS BEGIN DECLARE ... bug in MSSQL 2019? See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

sql - ASP.net MVC: Execute Razor from DB String?

I was thinking about giving end users the ability to drop Partial Views (controls) into the information being stored ... part of the Razor view? See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

sql server - How can I make a primary key as AUTOINCREMENT

I have table in Database and the primry key is 'ID', Just I want to ask how can I make it AUTOINCREMENT I know ... know how can I do it. thanks See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

sql server - TSQL 2008 Using LTrim(RTrim and still have spaces in the data

I have data I cleaning up in an old data table prior to moving it to a new one. One of the fields has ... 1 1085 YouAreHere Ln RT 24 Box 12 See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - CONNECT BY or hierarchical queries in RDBMS other than Oracle

Oracle ships with a very handy feature. You can create hierarchical queries (recursive behaviour) using the following ... so important to me See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql server 2005 - generate sql temp table of sequential dates to left outer join to

i have a table of data that i want to select out via stored proc such that users can connect a MS excel front ... between a start and end date? See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

sql server - Why is CTE better than cursor/derived table/ subqueries/ temp table etc.?

How and why CTE gives a better performance as compared to derived table/ subqueries/ temp table etc. approaches? ... / temp table etc.? See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

sql - Range wildcard pattern matching behaviour with case-sensitive collations

Using PATINDEX and a case-sensitive collation to search for upper-case letters in a string I noticed this was ... is the behaviour like this? See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql server - Can I set a default schema for within a stored procedure?

I'm working on the next update for StackQL. One thing I want to do is have the ability to query over ... default schema used in a query? See Question&Answers more detail:os...

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

0 votes

498 views

1 answer

sql - How to "subtract" privileges in MySQL

I want to revoke update privielges from 2 columns of table "transact". I want the user to have all access to ... above does not seem to work. See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

sql server - How do I allow a drop-down list parameter in SSRS to have a default value of "-- All -- "?

I have a drop-down list that gets populated based on a stored-procedure - that parts works fine. It ... picture: Any tips appreciated thanks. See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

sql server 2008 - SQL-'08: Are multiple Replace statements a bad practice/is there another way to write this query?

Select Distinct REPLACE(REPLACE(REPLACE(REPLACE(Category, ' & ', '-'), '/', '-'), ', ', '-') ... could get even longer in many circumstancials. See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql - Testing PostgreSQL functions that consume and return refcursor

I want to test results of a Postgres function (changing the function is not a possibility). The function ... kind of things in PostgresQL See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

sql server 2008 - Transform/ Project a geometry from one SRID to another

I have a database table which currently holds geometric data in SRID 27700 (British National Grid). While retrieving the data ... ', 4326), :1)) See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - An "entity" specific sequence

Background I have a lot of different "things" (a domain specific item/entity/subject) that are visible to the " ... = 2 order by visible_id; See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

sql server - Is it possible to read data in another session's temporary table?

We're maintaining (and occasionally debugging) a large in-house system. The system has 20+ databases, and a number of ... -shot deal. (I hope). See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

sql - PostgreSQL ERROR: function to_tsvector(character varying, unknown) does not exist

This psql session snippet should be self-explanatory: psql (9.1.7) Type "help" for help. => CREATE ... correct according to the documentation? See Question&Answers more detail:os...

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

0 votes

467 views

1 answer

sql server - VBA Code to Add Linked Table with Primary Key

I have an updatable view in sql server database. When I create linked table to it with ODBC, I'm asked to ... view and create unique index on it See Question&Answers more detail:os...

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

0 votes

510 views

1 answer

sql server - Filter on Output clause sql

I am trying to use a filter on an OUTPUT clause in t-sql. What I want to do is something like this: ... t want to use two insert statements. See Question&Answers more detail:os...

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

0 votes

430 views

1 answer

sql - Is it OK not to use a Primary Key When I don't Need one

If I don't need a primary key should I not add one to the database? See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql server - What is the difference between TEMPORARY TABLE and TABLE VARIABLE in SQL 2008?

What is the difference between: CREATE TABLE #temp ( [ID] INT) INSERT INTO #temp SELECT ... and DECLARE @temp TABLE ... ... in SQL Server 2008? See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql server - SQL cast datetime

In SQL Server 2005, why does: PRINT Cast('' AS datetime) display: Jan 1 1900 12:00AM I would have thought it should be null? See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql server - How can I connect to an external database from a sql statement or a stored procedure?

When running a SQL statement or a stored procedure on a database, can you connect to an external database and pull ... a, externaldb.Data as b See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

sql - Postgresql : How do I select top n percent(%) entries from each group/category

We are new to postgres, we have following query by which we can select top N records from each category. create ... of elements in each group. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags