Recent questions tagged sql

0 votes

316 views

1 answer

sql - What is the best way to implement soft deletion?

Working on a project at the moment and we have to implement soft deletion for the majority of users ( ... within the Application database. See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql server - How to insert a C# List to database using Dapper.NET

Using dapper, how can I insert a C# List to database. Previously without dapper I used the below code to insert ... I'm using SQL Server 2008. See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Determine if one coordinate is in radius of another

Let's say I have a Table of rows that contain coordinates. What would be the best way to pull only the rows ... the radius of Row3 for example? See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql server - Linux - PHP 7.0 and MSSQL (Microsoft SQL)

Yes, I know that PHP 7.0 removed the extensions needed to connect to MSSQL. FreeTDS was my option prior to PHP 7 ... there (FWIW we use both). See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Restrict varchar() column to specific values?

Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008? For ... Studio when creating the table? See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - COALESCE Function in TSQL

Can someone explain how the COALESCE function in TSQL works? The syntax is as follows COALESCE(x, y) The ... on this function is pretty vague See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql server - Generate MD5 hash string with T-SQL

Is there a way to generate MD5 Hash string of type varchar(32) without using fn_varbintohexstr SUBSTRING(master. ... a view with SCHEMABINDING See Question&Answers more detail:os...

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

0 votes

209 views

1 answer

sql - is it possible to select EXISTS directly as a bit?

I was wondering if it's possible to do something like this (which doesn't work): select cast( (exists(select * ... a bit and be done with it. See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - Challenge,how to implement an algorithm for six degree of separation?

UserA-UserB-UserC-UserD-UserF Users connected by '-' know each other. And I need an algorithm for these 2 tasks: ... it must be a sql solution! See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - How to update rows with a random date

I have a simple SQL table which has a DateTime column. I would like to update all the rows (>100000 rows) with a ... way to do this a SQL Query? See Question&Answers more detail:os...

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

0 votes

215 views

1 answer

sql - How do composite indexes work?

I've created composite indexes (indices for you mathematical folk) on tables before with an assumption of how ... index actually look like? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql server - How can I fill a column with random numbers in SQL? I get the same value in every row

UPDATE CattleProds SET SheepTherapy=(ROUND((RAND()* 10000),0)) WHERE SheepTherapy IS NULL If I then do a ... to generate unique random numbers? See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql server - Calculate Time Difference Between Two Rows

I have a table that contains the following: DataDate Value 2010-03-01 08:31:32.000 100 2010-03-01 08:31:40. ... ? I am using SQL Server 2005. See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - How to create a new database with the hstore extension already installed?

Recently I went into trouble trying to use hstore with Django. I installed hstore this way: $ sudo -u postgres ... in a newly created database ? See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql - Left Join without duplicate rows from left table

Please look at the following query: tbl_Contents Content_Id Content_Title Content_Text 10002 New case Study New case ... NO DUPLICATE RECORDS. See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql - WHERE Clause to find all records in a specific month

I want to be able to give a stored procedure a Month and Year and have it return everything that happens in ... the year and month? Thanks. See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql server 2005 - Convert a string to int using sql query

How to convert a string to integer using SQL query on SQL Server 2005? See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql - Why is a primary-foreign key relation required when we can join without it?

If we can get data from two tables without having primary and foreign key relation, then why we need this rule? Can ... what is the use of that? See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - Insert Data Into Tables Linked by Foreign Key

I am using PostgreSQL. Customer ================== Customer_ID | Name Order ================ ... which can be achievable using 1 SQL statement? See Question&Answers more detail:os...

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

0 votes

222 views

1 answer

sql server - Table-level backup

How to take table-level backup (dump) in MS SQL Server 2005/2008? See Question&Answers more detail:os...

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

0 votes

245 views

1 answer

sql - MySQL - why not index every field?

Recently I've learned the wonder of indexes, and performance has improved dramatically. However, with all I've learned, ... the line, and why? See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - How to get a list column names and datatypes of a table in PostgreSQL?

How can I get a list of column names and datatypes of a table in PostgreSQL using a query? See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - Find duplicate rows with PostgreSQL

We have a table of photos with the following columns: id, merchant_id, url this table contains duplicate values for the ... 9.2 and Rails 3.) See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - postgresql: INSERT INTO ... (SELECT * ...)

I'm not sure if its standard SQL: INSERT INTO tblA (SELECT id, time FROM tblB WHERE time > 1000) What I' ... prepared statement out of this!! :( See Question&Answers more detail:os...

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

0 votes

405 views

1 answer

sql server - Temporarily disable all foreign key constraints

I am running an SSIS package which will replace data for a few tables from FlatFiles to existing tables in a ... import, then re-enable them? See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql - Functions vs Stored Procedures

Let's say I have to implement a piece of T-SQL code that must return a table as result. I can implement ... account for using one or the other? See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - How to select only the first rows for each unique value of a column?

Let's say I have a table of customer addresses: +-----------------------+------------- ... the server has already seen the column value before? See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql server - How to change column datatype in SQL database without losing data

I have SQL Server database and I just realized that I can change the type of one of the columns from int ... is already entered into that table? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags