Recent questions tagged sql

0 votes

947 views

1 answer

sql - OpenRowSet and OpenDataSet without sysadmin rights

Is there any way to use the OpenRowSet and OpenDataSet commands in SQL Server 2008 R2 without having to have ... WHERE Amount > 0 Thanks See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

sql - Are single quotes escaped automatically in PHP? Then what's the need for cleaning?

I'm reading up on web security and one obvious topic to cover is SQL injections. I'm trying to set up a ... need to clean user input any more? See Question&Answers more detail:os...

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

0 votes

737 views

1 answer

sql - Why can't I exclude dependent columns from `GROUP BY` when I aggregate by a key?

If I have the following tables (as an example using PostgreSQL, but could be any other relational database), where ... 18 Example in DB Fiddle. See Question&Answers more detail:os...

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

0 votes

879 views

1 answer

sql server 2008 - SQL Trigger cannot do INSTEAD OF DELETE but is required for ntext, image columns

CREATE TRIGGER [dbo].[C1_Deletions] ON [dbo].[C1] INSTEAD OF DELETE AS SET NOCOUNT ON IF EXISTS ( SELECT ' ... entry then it deletes by recid. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Select first record if none match

In PostgreSQL, I would like to select a row based on some criteria, but if no row matches the criteria, ... using a single SELECT statement? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - ODBC can't find correct OpenSSL version after upgrading OpenSSL

Update: if you have this same issue, the source of the problem is being discussed here After upgrading to ... ]ERROR: Could not SQLDriverConnect See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - C# equivalent to java prepared statement

I am trying to create a prepared statement in c#. For some reason everything I try ends up with an exeption. ... current state of the object." See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Many to Many Self referencing relationship

I'm attempting to create a library database using SQL in which one book_id recommends another book_id number. ... to many self relationship? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Recursive CTE in presence of circular references

I have a hierarchical structure in a SQL Server database. I'm trying to write a query to get all elements in the ... Is there a way to do that? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Attempting CREATE VIEW in Access gives "Syntax error in CREATE TABLE statement"

I typed this code to create a view in a pre created database: CREATE VIEW NHTrips AS SELECT TripID, TripName, ... CREATE TABLE statement." Why? 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 - Active Directory Password Connection Azure SQL Failure from Azure Automation

I need to connect via Azure Automation to an Azure SQL Server using my Azure Active Directory Admin account ... when using Azure Automation. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

sql - EXEC and Set Quoted_Identifier

I've got a Stored proc [A] that creates another stored proc [B] [A] Will never be run by end users ... I make EXEC create the proc correctly? 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 - rename a column in all the tables - SQL

I need to rename a column in all tables in my database. so a column 'OldColumn' has to be renamed to 'NewColumn ... 't have to write a cursor? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - MySQL STR_TO_DATE NULL on error

I'm currently migrating a table with dates in VARCHAR columns to a new table with DATE columns. I managed to ... -%d'); DROP TABLE dates_temp; See Question&Answers more detail:os...

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

0 votes

778 views

1 answer

sql - Oracle Performance IN or OR

Which operator in oracle gives better performance IN or OR ex: select * from table where y in (1,2,3) or select * from ... 1 or y = 2 or y = 3 See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

sql - Retrieve last known value for each column of a row

Not sure about the correct words to ask this question, so I will break it down. I have a table as follows: ... caters for a single column ... 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 2008 - Converting float to varchar with correct decimal separator

Hi i'm living in austria and we use the , as decimal separator. It seems to be impossible to convert the float to ... (varchar,@f),'.',',') See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

sql - Fastest way to check if a character is a digit?

I am having issues with sqlserver's ISNUMERIC function where it is returning true for ',' I am parsing a ... then LEFT(v.patientPostal,3) See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

sql server data tools - How to Apply Transforms to SSDT publish profiles

Using Visual Studio 2013 I have a set of 8 SSDT projects that can all be deployed to several distinct ... post by Sayed Ibrahim Hashimi. See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

sql - concatenating string

Is there a way in SQL sever that can write the output as follow: select events from mytable original output events ---- ... ', 'BERGS', so on... See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

sql server - Windows authentication trusted connection not working

MSSQL Server is in the "abc" domain and have mixed mode authentication. I am connecting from the machine which ... same subnet, it works fine. See Question&Answers more detail:os...

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

0 votes

948 views

1 answer

sql - Escaping command parameters passed to xp_cmdshell to dtexec

I am calling an SSIS package remotely using a stored procedure and a call to xp_cmdshell: declare @cmd varchar(5000) ... can't figure out what. See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

sql - How to add dynamic column to an existing table

I have 2 tables 1st table contains following columns, id code Name 1 c1 chk1 2 c2 chk2 3 c3 chk3 2nd table ... (50)' exec(@query) end end See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

sql server 2005 - How to get the corresponding comma-separated text for a string of comma separated codes?

I've a table, there is a column called "locations" which is in type of varchar(max). It carries string ... advise. Thank you! Regards, William See Question&Answers more detail:os...

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

0 votes

780 views

1 answer

sql - Update multiple table column values using single query

How would you update data in multiple tables using a single query? MySQL Example The equivalent code ... 920/a96540/statements_108a.htm#2067717 See Question&Answers more detail:os...

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

0 votes

849 views

1 answer

sql - MySQL update with select from another table

I've got 3 tables. Companies, Kommuner and Fylker. The companies table have an empty field forretningsadresse_fylke ... . Thanks in advance! See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

sql - join two different tables and remove duplicated entries

I'm complete novice in sql queries. I have two tables: table1: id_s name post_code city subject --------- ... it but they were too complicated. See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

sql - Missing mysql.h and trying to find mysql-devel

(I've been through four or five questions that are related to mine, but this sticking point I run into doesn't ... hope it's simple to resolve! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags