Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure. This tag refers to the standard language, not for questions about specific vendor extensions, like MySQL or Microsoft SQL Server, so if you think your question relates to ...
0
votes
0answers
6 views
only remove 1 record from duplicated (access database)
im making a reservation system, but i'm stuck at the moment.
Microsoft acces 2010 Tables:
-drinks
-ordered_drinks
structure
tables:
-id,
-..,
-...,
drinks:
-id,
-title,
-price,
ordered_drinks:
...
0
votes
0answers
2 views
Creating the “Invalid or Stale Connection found in the Connection Cache” local Oracle DB
I would like to know how to tweak my local Oracle DB settings to get this error through my web application. Any input would be greatly appreciated.
Thanks.
0
votes
0answers
4 views
Partial load using manual sql query with EF
I'm using EF 5.0 and Code first and need to populate an array of entities using manual sql query.
However, I don't need to load the whole entity from db, but only few fields.
I don't need tracking ...
0
votes
0answers
14 views
how to authenticate for internal and external users
In my application I have a login page. I want this login page to appear only to the external users. Internal users should directly go to the application using windows sign information. So, if external ...
4
votes
3answers
53 views
How to select rows with exactly 2 values in a column fast within a table that has 10 million records?
I have a table (TestFI) with the following data for instance
FIID Email
---------
null [email protected]
1 [email protected]
null [email protected]
2 [email protected]
3 [email protected]
4 [email protected]
5 [email protected]
...
0
votes
2answers
15 views
Convert multiple columns (year,month,day) to a date
I've got a few columns that I'm trying to convert to one, but I'm having some issues here.
The problem is that the Month or day can be single digit, and I keep losing that 0.
I'm trying it on a view ...
0
votes
1answer
12 views
Creating new elements and attaching them to a parent element via a join table in SQL
I am trying to write a script to change a database's table structure to a new model and migrate the old data to the new model.
My current problem is this:
I have two tables called Parts and Document, ...
1
vote
1answer
20 views
How would I make a Twitter-like feed using SQL/PHP?
On the site I am building, users can follow others and post things. I am trying to compile a feed page that allows users to see all the posts in chronological order from people they follow (pretty ...
0
votes
2answers
19 views
timezone confusion in relational databases
I have downloaded a postgres database in .sql format. The type of temporal column in the database is: timestamp with time zone. And dates are mentioned in the database in the form given below:
...
0
votes
2answers
37 views
If statement error with variable
I have had this problem for a while and finally i narrowed it down to what it is (I think).
I am trying to put a limit on a income and the limit is $storagecap each $warehouse is = to 500 $storagecap. ...
1
vote
3answers
38 views
SQL Query has no results how do I tell that to a user in my program
I am building a program which checks the roles of users. When a button gets pressed it uses the userID to query the role/group table of our database. If a person is not in the role/group tables then ...
0
votes
1answer
10 views
Case condition in a where clause having another sql statement
I'm working on a jasper report which takes one parameter based on which it should have a different where clause. Below is the query I'm using but seems there's a syntax error somewhere.
select ...
1
vote
1answer
19 views
SQL Server CE query fails to execute in c#, but works in DBMS
I am trying to run a bunch of SQL statements in sql query. The query and the code look as follows:
private void cancelTestCaseCreationWizard()
{
string deleteTestCaseCmd = @"
...
3
votes
3answers
39 views
Efficient Update of Table from One SQL Server to Another, Same Table Structure
I have one database server, acting as the main SQL Server, containing a Table to hold all data. Other database servers come in and out (different instances of SQL Server). When they come online, ...
0
votes
0answers
12 views
Actual employee working hours from payroll system?
I am working on a project which involves a payroll system for Employees. My main goal is to retrieve the actual work hours for each employee, however I am a bit confused about how I should proceed ...
