Recent questions tagged SQL

0 votes

1.6k views

1 answer

sql server - SQL : remove last comma in string

I have a text memo field in SQL table that I need to remove the last character in the field if it's a comma. So, ... , 92 89, 99, 32 Any ideas? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - Quickest way to clone row in SQL

I want to clone multiple tables' rows that have a single primary key (PrimKey). What's the quickest way to ... answers posted by some of you. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

sql - Is there a way to specify table name as a string?

Let us say I have a query like this: SELECT * FROM ( SELECT * FROM ( SELECT * FROM DB.dbo.Table ... is possible, will Intellisense still work? See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

sql server - Dynamically choose column in SQL query

I have a database field name call Code and I am trying to select it using a variable name like this below ... any select or if statements. See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

sql - Inserting default value as current date + 30 days in MySQL

How can I make a column's default value equal to the current date + 30 days in MySQL? For example, if current ... must be inserted as 9-2-2011. See Question&Answers more detail:os...

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

0 votes

916 views

1 answer

sql - Notify my WCF service when my database is updated

I have a WCF service that needs to notify it's clients when changes occur to the database (sql server 2005) ... . All help is appreciated! rinze See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - Stored Procedure and populating a Temp table from a linked Stored Procedure with parameters

I have a Stored Procedure (SP) in which I pass in one value. In this SP, I am trying to create/populate a ... the above SQL is only pseudo code See Question&Answers more detail:os...

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

0 votes

885 views

1 answer

sql - Why are dot-separated prefixes ignored in the column list for INSERT statements?

I've just come across some SQL syntax that I thought was invalid, but actually works fine (in SQL Server at ... is so would also be appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - Why can't I connect to my mssql database using PHP?

I've done so much research trying to get my PHP code hosted on IIS to connect to my MSSQL database. I just ... failing. What are we doing wrong? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - Bidirectional foreign key constraint

I'm thinking of designing a database schema similar to the following: Person ( PersonID int primary key, ... having a primary address? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Hyphen vs Dash : Replace Dash with Hyphen

Alright so we had a problem recently In reporting services some of the String Columns were appearing as gibberish ... ? SQL Server v 2005 See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql timestamp - MySQL 1292 Incorrect datetime value

I am getting this error when I try to insert '2011/03/13 02:53:50.000000000' into a timestamp column. If I ... I'm running version 5.7.9. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - PIVOT with varchar datatype

I′m trying to PIVOT some data in a table, but I cannot do it because I do not find the way to do it using ... s Can someone help me??. Thanks. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - How to use IN clause with PreparedStatement in PostgreSQL

I have to write a SQL query for Postgres database as follows: DELETE FROM employee WHERE ename IN (? ... with PreparedStatement in Postgres? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - auto increment on composite primary key

I have a table called 'Workspaces' where the columns 'AreaID' and 'SurfaceID' work as a composite primary key. ... know how this can be fixed? See Question&Answers more detail:os...

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

0 votes

978 views

1 answer

sql - Is an overuse of nullable columns in a database a "code smell"?

I'm just stepping into a project and it has a fairly large database backend. I've started digging through ... if most columns are nullable? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - "Invalid column name" error on SQL statement from OpenQuery results

I'm trying to perform a SQL query through a linked SSAS server. The initial query works fine: SELECT "Ugly ... the WHERE and HAVING clauses. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Delete all records except the most recent one?

I have two DB tables in a one-to-many relationship. The data looks like this: select * from student, ... to filter out the correct records? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Postgres drop table syntax error

Postgres 9.3.2 on heroku. Pretty sure I'm just being an idiot, but I can't seem to figure out why my ... ERROR: table "error" does not exist See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - JOIN vs Multiple FROM Tables

Is there ever a case where a join will not return data that a FROM multiple tables with the same conditions ... WHERE Names.ID = Numbers.ID See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

sql server - Partitioning results in a running totals query

I'm looking for a fast way to create cumulative totals in a large SQL Server 2008 data set that partition by a ... ? Many thanks for any tips. See Question&Answers more detail:os...

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

0 votes

896 views

1 answer

sql server - Entity Framework - how to create sql script with "GO" statements

In EF 6.1 you can run the command: update-database -script This generates the full SQL script for one or many ... Has anyone else run into this? See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

sql server - Complicated SQL Query--finding items matching multiple different foreign keys

So imagine that you have a table of Products (ID int, Name nvarchar(200)), and two other tables, ... select COUNT(*) from invoiceids) See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

sql - Get "zero" for a count at dates without records

So I'm counting activity records from users in my system. I get the activity counter for each day ... . Obviously, accepting suggestions! See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

sql server - XML DML for 2008 R2..How to modify nested Elements

<Component> <Caption>2 7/8" x 1",Drill Collar,2 3/8 PAC</Caption> <Description>2 7/8" x 1",Drill ... (/Component/Sections/Section/Length)[1] ') See Question&Answers more detail:os...

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

0 votes

934 views

1 answer

sql - Performance of querying for a string that starts and ends with something

Are there any performance difference in querying a database for some character column starting with something and ending ... differ in some way? See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

sql - How to use VBA variable for IN 'SourceDB' clause of MS-ACCESS query

I am trying to pass a vba string variable to an IN clause of a SQL statement in the query builder view. the string ... can't see it. thank you. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - SQL Date Format

How do I format a data in SQL to read like this: Monday, November, 23 2009 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags