Recent questions tagged SQL

0 votes

276 views

1 answer

sql - Is there a way to get DateTime value from timestamp type column?

I need a select from table which does not have column that tells when row was inserted, only timestamp column ( ... is a well known solution? See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql server - .NET, the SqlConnection object, and multi-threading

We have an application which uses an SQL Server 2008 R2 database. Within the application, calls to the database are ... , and then access it? See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - Converting MySQL select to PostgreSQL

I have this query which works correctly in MySQL. More background on it here. SELECT c.*, SUM(ABS(v.vote) ... How can this problem be resolved? See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

sql - ORA-00907 Missing right parenthesis issue - select with order by inside insert query

I am trying to do insert to a table and it uses one select statement for one column. Below is the illustration of my ... it. How can I fix it? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - foreign keys on table from different database

I have two databases in SQL Server and i have a common table for both the databases an important big table ... in complexity. Any suggestions? See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql server - SQL Subtract exactly a year

First I want to thank everyone for helping me, It gave me a lot of ideas on how I should do this and I ... @DYYYY=Y dateadd(year,-Y,getdate()) See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql server - T-SQL rounding vs. C# rounding

I am using Microsoft SQL Server Express 2016 to write a stored procedure. One of the requirements is to do ... .06 What is the explanation? See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql - Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

My webpages are on secured server (https), and I am trying to connect the SQL Server 2008 Database, which is normal ... ")); con.Close(); } See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql server - Calculate exact date difference in years using SQL

I receive reports in which the data is ETL to the DB automatically. I extract and transform some of that data ... get the exact date in years? See Question&Answers more detail:os...

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

0 votes

217 views

1 answer

sql - What is the effect of omitting size in nvarchar declaration

I usually define size when declaring parameters in my SP, like : @myParam nvarchar(size) or when I casting ... specifying size. Any comments? See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Default getdate for Insert date

I have a table called sample and it has a column called [__INSERT_DATE] which is null. Now I want to alter the ... tell me what the problem is? See Question&Answers more detail:os...

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

0 votes

306 views

1 answer

sql - Left Outer join and an additional where clause

I have a join on two tables defined as a left outer join so that all records are returned from the left hand ... there a way of doing this? See Question&Answers more detail:os...

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

0 votes

278 views

1 answer

sql server - EF code-first many-to-many with additional data

I have these tables: CREATE TABLE [EDR_SECURITY].[Person]( [ixPerson] [bigint] IDENTITY(1,1) NOT NULL, [ ... Person and Security Group? Thanks. See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - Mysql table with composite index but not primary key

I need a table to store some ratings, in this table I have a composite index (user_id, post_id) and other ... need to change it? Thank you See Question&Answers more detail:os...

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

0 votes

200 views

1 answer

sql - Interactive Plots in R

Using the plotly library, I made the following plot in R: library(dplyr) library(ggplot2) library(plotly) set.seed( ... how to do this? Thanks See Question&Answers more detail:os...

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

0 votes

428 views

1 answer

sql server - How can I to read a XML from a URL using T-SQL?

Have xml file in url : <response> <sum>0</sum> <result>0</result> <comment>sel*1.9488|buy*1.9453</comment> </ ... .9453 to my table. How do it ? See Question&Answers more detail:os...

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

0 votes

557 views

1 answer

sql - Unique constraint on combination of two columns?

I have been trying to figure out if it is possible to have a unique constraint for a combination of two ... combination exists before I insert? See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - Pivot on Oracle 10g

I am using oracle 10g. I have a temp table TEMP. TEMP has following structure:- USER COUNT TYPE ---- -- ... will show total count of types. See Question&Answers more detail:os...

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

0 votes

359 views

1 answer

sql server - Passing a list of values from Python to the IN clause of an SQL query

I am trying to pass a list like below to a sql query x = ['1000000000164774783',' ... (1000000000164774783, 1000000000253252111)'] See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - For XML length limitation

I am trying to concatenate results of some string data in a query using XML PATH See query below.What happens ... x where statement is not null See Question&Answers more detail:os...

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

0 votes

333 views

1 answer

sql - How can I set a size limit for an "int" datatype in PostgreSQL 9.5

I am experimenting with PostgreSQL coming from SQL using MySQL and I simply wish to create a table with this ... into the "pk_flat_id" field See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql server - How can I generate a hierarchy path in SQL that leads to a given node?

In my MS SQL 2008 R2 database I have this table: TABLE [Hierarchy] [ParentCategoryId] [uniqueidentifier] NULL, [ChildCategoryId] ... , A > D > C See Question&Answers more detail:os...

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

0 votes

245 views

1 answer

sql - What is the difference in these two queries as getting two different result set?

I am getting different result set for these two queries and second result set seems to be correct. What is the ... .Id AND t1.StatusId = 12 See Question&Answers more detail:os...

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

0 votes

288 views

1 answer

sql server - Do Inserted Records Always Receive Contiguous Identity Values

Consider the following SQL: CREATE TABLE Foo ( ID int IDENTITY(1,1), Data nvarchar(max) ) INSERT INTO Foo (Data) ... 't have to worry about it. See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - Avoid string concatenation to create queries

Martin Fowler in his book Patterns of enterprise application architecture says A good rule of thumb is to avoid ... considered a bad practice? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - Select second most minimum value in Oracle

I need to write a query that selects a minimum value and it's second most minimum value from a list of ... second most min can be 10000. See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql - How do I Handle Ties When Ranking Results in MySQL?

How does one handle ties when ranking results in a mysql query? I've simplified the table names and columns in ... advice, please let me know. See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

sql - List of Stored Procedure from Table

I have a huge database with 100's of tables and stored procedures. Using SQL Server 2005, how can I get a ... update operation on a given table. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags