Recent questions tagged SQL

0 votes

448 views

1 answer

sql server - Refactoring ADO.NET - SqlTransaction vs. TransactionScope

I have "inherited" a little C# method that creates an ADO.NET SqlCommand object and loops over a list of items ... would prefer, and why? Marc See Question&Answers more detail:os...

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

0 votes

273 views

1 answer

sql - How to insert a string which contains an "&"

How can I write an insert statement which includes the & character? For example, if I wanted to insert "J&J ... but I'm using Oracle 9i. See Question&Answers more detail:os...

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

0 votes

297 views

1 answer

sql - Indexes and multi column primary keys

Went searching and didn't find the answer to this specific noob question. My apologies if I missed it. In a ... the structure of my table? See Question&Answers more detail:os...

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

0 votes

273 views

1 answer

sql - Oracle date "Between" Query

I am using oracle database. i want to execute one query to check the data between two dates. NAME START_DATE -- ... on this. thanks in advance. See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql server 2005 - How do I avoid character encoding when using "FOR XML PATH"?

I'm looking to create a comma-separated list of values from a SQL Server 2005 table, just like in JanetOhara's ... "FOR XML" in SQL Server? See Question&Answers more detail:os...

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

0 votes

240 views

1 answer

sql server - Create SQL script that create database and tables

I have a SQL database and tables that I would like to replicate in another SQL Server. I would like to ... script would be enough. Thanks. See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql server - SQL function as default parameter value?

I tried changing a default parameter value with this: ALTER PROCEDURE [dbo].[my_sp] @currentDate datetime = GETDATE ... this wrong? Many thanks. See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql server 2005 - how to increment integer Columns value by 1 in SQL

My questions is how to increment a column's value by 1. For example, suppose a column ID has values 1,2,3,4, .. ... ID will become 2,3,4,5, .. See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql - Embedded database for .net

I need an embedded database for one of our .net applications. This database should support sql (Unlike Berkley). Can anyone suggest any options. See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql - Oracle: how to "group by" over a range?

If I have a table like this: pkey age ---- --- 1 8 2 5 3 12 4 12 5 22 I can "group by" ... be interested in any 11g-specific approaches as well. See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql server - Hide SQL database from Management Studio

How can you hide databases you do not have access rights to when logging into SQL Server 2005 / 2008? ... list to find their database. See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - How to select data where a field has a min value in MySQL?

I want to select data from a table in MySQL where a specific field has the minimum value, I've tried this: ... WHERE MIN(price) Please any help? See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql server 2008 - What is the use of SYNONYM?

What is the use of SYNONYM in SQL Server 2008? See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql - How to export a MySQL database to JSON?

I am interested in exporting a subset of values from a MySQL database into a JSON-formatted file on disk. I ... or some other method)? Thanks! See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - How to delete rows in tables that contain foreign keys to other tables

Suppose there is a main table containing a primary key and there is another table which contains a foreign key to ... do I write this query? See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql - Update MySQL with if condition

It seems I have big problems with conditional queries. I have to do a conditional update. I write here what I would ... doesn't work. Any idea? See Question&Answers more detail:os...

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

0 votes

215 views

1 answer

sql - Allow null in unique column

I've created the following table: CREATE TABLE MMCompany ( CompanyUniqueID BIGSERIAL PRIMARY KEY NOT NULL, Name VARCHAR ... can I achieve that? See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql server - SQL: How to get the id of values I just INSERTed?

I inserted some values into a table. There is a column whose value is auto-generated. In the next statement of my ... to do it the right way? See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql - How can I get the number of records affected by a stored procedure?

For INSERT, UPDATE and DELETE SQL statements executed directly against the database, most database providers return the ... a stored procedure? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - How to calculate an exponential moving average on postgres?

I'm trying to implement an exponential moving average (EMA) on postgres, but as I ... /ccc?key=0AvfclSzBscS6dDJCNWlrT3NYdDJxbkh3cGJ2S2V0cVE See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql server - What's the simplest way to access mssql with python or ironpython?

I've got mssql 2005 running on my personal computer with a database I'd like to run some python scripts ... and possibly works with ironpython. See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql server - SQL join against date ranges?

Consider two tables: Transactions, with amounts in a foreign currency: Date Amount ========= ======= 1/2/ ... B, without tying myself in knots? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - Generate serial number in mysql query

I have a table: student_marks marks ----- 44 55 64 98 76 Expected output: serial_number|marks ----- ... without using user defined variables? See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql server - Is it better to use an uniqueidentifier(GUID) or a bigint for an identity column?

For SQL server is it better to use an uniqueidentifier(GUID) or a bigint for an identity column? See Question&Answers more detail:os...

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

0 votes

302 views

1 answer

sql - Delete all but one duplicate record

I have a table that is supposed to keep a trace of visitors to a given profile (user id to ... 0 date_visited timestamp Non CURRENT_TIMESTAMP See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql server - Query runs fast, but runs slow in stored procedure

I am doing some tests using the SQL 2005 profiler. I have a stored procedure which simply runs one SQL query. ... else 0 end) OPTION(recompile) See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our DB has ... once I have all the tables. See Question&Answers more detail:os...

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

0 votes

297 views

1 answer

sql - How to check db2 version

How to check db2 version on Z/OS using only SQL commands? Thanks, Melita See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags