Recent questions tagged SQL

0 votes

287 views

1 answer

sql - PHP session for tracking unique page views

I want to use sessions to track unique page views. Not a very robust method, I know, but sufficient ... offered there. Help appreciated! See Question&Answers more detail:os...

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

0 votes

296 views

1 answer

sql server - Convert Database Rows into Columns

I need to convert Database rows into columns and show the result in Gridview. My DB is as follows: ID Hotel cDate ... 12/22/2009 12:00:00 AM See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - MS Access Date triggers emulation

I am completely new to Access (have some experience with SQL server). I am not sure if its even possible in ... group opinion on that. Thank you See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql server - Drop temp table within IF ELSE statement

I am facing a deadlock here, the issue is that I have to alter a procedure which makes use of 3 different ... tips? Thank you for your time. See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql - Mysql syntax error creating stored procedure

This is driving me nuts. CREATE DEFINER=`root`@`localhost` PROCEDURE `CalcularCRTarea` (Id_Tarea INT, OUT crTarea ... best way I've found. See Question&Answers more detail:os...

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

0 votes

223 views

1 answer

sql - Merge identical databases into one

We have 15 databases of 75 tables with an avarage of a million rows. all with the same schema but different data. ... ways are there to do this? See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql - Convert one row into multiple rows with fewer columns

I'd like to convert single rows into multiple rows in PostgreSQL, where some of the columns are removed. Here ... get the above desired output? See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - How to convert a text field in an Access table to a rich text memo using VBA

My users have a number of backend .accdb databases (which I can't access directly). I need to code some vba to ... does need to be bomb-proof! See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - Group by repeating attribute

Basically I have a table messages, with user_id field that identifies a user that created the message. When I ... give the best performance. See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - MySQL automatic string to integer casting in where clause?

I am not new to MySQL but a strange situation happened in my code today coincidently which got me surprised ... auto_increment flag turned on. See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - ColdFusion Query - Injection Protection

I ask this question with a bit of sheepishness because I should know the answer. Could someone be kind and explain ... '#value#' doesn't do? See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql server - C# Database The ConnectionString property has not been initialized

I'm trying to insert values in my database and whenever I try to add it, my program just crash, giving me an ... this is not running fine in C#. See Question&Answers more detail:os...

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

0 votes

327 views

1 answer

sql - Compare varchar with char

I am trying to figure out what Postgres does when comparing varchar with char. Here is one of my tests: test ... good documents on this topic? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - How to unpivot a table in PostgreSQL

I am having difficulties writing a Postgres function, as I am not familiar with it. I have multiple tables to import ... fifth year or so ... See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - optional where clause jasper reports

I am trying this query but without success. SELECT name, phone_office, billing_address_city, billing_address_street, ... in sql query. See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql - shows blanks for repeating values in a result set

In the query below, for o.EventSetName, o.EventSetDisplay, o.EventSetDescription - any time the 3 columns in the result ... rows 2,3,4 and 5 See Question&Answers more detail:os...

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

0 votes

462 views

1 answer

sql - How to use Alias in Where clause?

I have this procedure: PROCEDURE P_LOAD_EXPIRED_ACCOUNT ( pDayDiff IN NUMBER, ExpiredCur OUT MEGAGREEN_CUR ) IS BEGIN ... Thanks in advance. See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql server - Renaming multiple tables

In SQL Server, I have a database abc. In this database I have hundreds of tables. Each of these tables is ... the schema for each table to abc See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - Rails Active query order by multiple values in specific order?

I have a table Roles(id int,,name vachar(50),role enum(CAD,CA,CM,CV )) I want select data that order ... Can anyone help me? Thanks in advance See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - oracle autoincrement with sequence and trigger is not working correctly

here is my problemI have this code to make an autoincrement variable in oracle database: CREATE TABLE Korisnici ... newbie in oracle database. See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - Calling Stored Procedure while passing parameters from Access Module in VBA

I am working in Access 2010 with a Microsoft SQL Server 2008 backend. I have a stored procedure that ... help would be greatly appreciated See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - spark dataframe groupping does not count nulls

I have a spark DataFrame which is grouped by a column aggregated with a count: df.groupBy('a').agg(count(" ... ) to properly see the counts. See Question&Answers more detail:os...

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

0 votes

329 views

1 answer

sql - Simple SELECT statement fails with "syntax to use near", "ORA-00906", "syntax error at or near" or "syntax near the keyword"

I have a very simple SQL statement SELECT * FROM Table; but, my query engine returns a syntax error. Why? Error ... . What I am doing wrong? See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql - Refactor foreign key to fields

In PostgreSQL I need to refactor a table (Purchases); it has a foreign key to another table (Shop). Instead I want ... I have to do it this way. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - Creating a View using stored procedure

This questions have asked few times before, unfortunately I did not get an answer to my questions. Well I have ... [Employee ID]) Please help. See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Column cannot be null Mysql

Below is my table structure CREATE TABLE IF NOT EXISTS `physicians` ( `physician_id` bigint(20) NOT NULL ... I fix this problem ? See Question&Answers more detail:os...

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

0 votes

215 views

1 answer

sql server - How to get the stored procedure result using Perl?

I'm beginner in sql. I have created the procedure as follows create procedure testprocedure2 as select 'one' ... help in yesterday's question See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Postgres time with time zone equality

I'm having some trouble with time with time zone equalities in Postgres. timestamp with time zone equality works ... time zone equality does? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags