Recent questions tagged Sql

0 votes

235 views

1 answer

sql server 2005 - Aggregate SQL Function to grab only the first from each group

I have 2 tables - an Account table and a Users table. Each account can have multiple users. I have a scenario ... the order of their User.ID ? See Question&Answers more detail:os...

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

0 votes

230 views

1 answer

sql server - Is it possible to execute a text file from SQL query?

I have a number of generated .sql files that I want to run in succession. I'd like to run them ... and running queries in management studio. See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Count records for every month in a year

I have a table with total no of 1000 records in it.It has the following structure: EMP_ID EMP_NAME PHONE_NO ARR_DATE ... month(ARR_DATE) = '01' See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql server - Update SQL with consecutive numbering

I want to update a table with consecutive numbering starting with 1. The update has a where clause so only ... without using a temp table? See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - Cannot Resolve Collation Conflict

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored ... new server back to Latin1_General_CI_AS?? See Question&Answers more detail:os...

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

0 votes

240 views

1 answer

sql query if parameter is null select all

I've the following query: SELECT NAME, SURNAME FROM MY_TABLE WHERE NAME = ?; Now I want that if '?' is ... can I achieve this in SQL? Thanks See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - Get month name from date in Oracle

How to fetch month name from a given date in Oracle? If the given date is '15-11-2010' then I want November from this date. See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql server - SQL Row_Number() function in Where Clause

I found one question answered with the Row_Number() function in the where clause. When I tried one query, I was ... ) > 0 ORDER BY Employee_ID See Question&Answers more detail:os...

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

0 votes

482 views

1 answer

sql - Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio

I have a problem when data is null and the warning has appear when the result is display. How to solve ... 0 Kamsuzilawati Enquiry 1 (null) See Question&Answers more detail:os...

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

0 votes

212 views

1 answer

sql - Display next event date

The UI design for storing event and event meta data is SQL TABLE DESIGN is CREATE TABLE [dbo].[EVENTS] ([ID] [ ... 2014 10 A.M SQL FIDDLE LINK See Question&Answers more detail:os...

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

0 votes

188 views

1 answer

sql - Oracle RAC and sequences

I have various database applications that use sequences, I′m migrating these applications to Oracle RAC from 10g without ... and RAC? Thanks, See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql server - freeTDS not using its config

I've decided to use FreeTDS driver and unixODBC to manage the PDO connection between my LAMP-based app with a remote ... stupid to find it... See Question&Answers more detail:os...

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

0 votes

208 views

1 answer

sql - Temporal database design, with a twist (live vs draft rows)

I'm looking into implementing object-versioning with the added twist of needing to have both live and draft ... been reasonably successful with? See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - how to get the full resultset from SSMS

How do you get back the full content of rows in SQL Server Management Studio? If you use "results to grid" the ... answer feel free to post it. See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql - Slow bulk insert for table with many indexes

I try to insert millions of records into a table that has more than 20 indexes. In the last run it took more ... helped me make it much faster. See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql server - T-SQL Subquery Max(Date) and Joins

I'm trying to join multiple tables, but one of the tables has multiple records for a partid with different dates. ... to get the results I want. See Question&Answers more detail:os...

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

0 votes

183 views

1 answer

sql - What permissions for PHP scripts/directories?

I am trying to help a friend moving a web-site from one web-hotel to another. The old place is already closed, I ... it is changed if it is). See Question&Answers more detail:os...

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

0 votes

319 views

1 answer

sql server - Create Stored Procedures using Entity Framework Code First?

I am using Entity Framework Code First in my current project. A Database consists of many tables, many views ... Framework Code First strategy? See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql server - ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException

I have a T-SQL stored procedure with the signature CREATE PROCEDURE MyProc @recordCount INT OUTPUT @param1 INT ... ... do with the connection. See Question&Answers more detail:os...

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

0 votes

220 views

1 answer

sql select with column name like

I have a table with column names a1,a2...,b1.b2.... How can I select all those with column names like a%? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - MySQL Sum() multiple columns

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

0 votes

270 views

1 answer

sql - Strip last two characters of a column in MySQL

I have an SQL column where the entries are strings. I need to display those entries after trimming the last ... , 11 characters or whatsoever. See Question&Answers more detail:os...

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

0 votes

231 views

1 answer

sql - Django in / not in query

I'm trying to figure out how to write a 'not in' style query in django. For example, the query ... assuming models called table1 and table2? See Question&Answers more detail:os...

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

0 votes

215 views

1 answer

sql - Queries with prepared statements in Android?

In Android, android.database.sqlite.SQLiteStatement allows me to use prepared statements in SQLite to avoid ... statements in Android? See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - php/mysql zip code proximity search

I'm just looking for suggestions on the best way to do this... I need to create a search function that ... suggestions at this point! Thanks! See Question&Answers more detail:os...

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

0 votes

207 views

1 answer

sql - Update rows in one table with data from another table based on one column in each being equal

Update many rows into one table from another table based on one column in each being equal (user_id). both ... advance for any help offered. See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

sql - The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

I'm trying to run the following statement but am receiving the error messages just below. I have researched ... not working. Help, anyone? See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - VARCHAR as foreign key/primary key in database good or bad?

Is it better if I use ID nr:s instead of VARCHARS as foreign keys? And is it better to use ID nr:s ... Or am I thinking completely wrong here? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags