An acronym for "Structured Query Language", SQL can be used in relational database management systems (RDBMS) to query, update, delete, and insert data as well as modify the structure of the database. It can also be used to manage schemas and data access privileges.
0
votes
0answers
150 views
oracle sql dependency extractor
Is there a tool which given a bunch of data extraction SQL scripts will produce a dependency graph?
Basically given scripts which take input tables, create a bunch of interdependent intermediary ...
0
votes
0answers
304 views
Grouping a comma separated value on common data [closed]
I have a table with col1 id int, col2 as varchar(comma seperated value) and column 3 for assigning group to them.
Table looks like
col1 col2 group
..............................
...
0
votes
0answers
303 views
Update Statistics Maintenance Plan - Ambiguous column name error
Microsoft SQL Server 2008 R2 Web Edition (RTM) - 10.50.1600.1 (Intel X86)
Windows 2003 R2 SP2
I am in the process of setting up a maintenance plan to update statistics on a daily basis for all user ...
0
votes
0answers
60 views
query correctness [closed]
I have this query.
Sorry to bother you, I know it’s simple but I’m wracking my brain in order to solve it.
Consider a relation of scheme
Boat(ID,Name,Color,Age)
and a relation of scheme
...
0
votes
0answers
186 views
Save HTML to SQL database in RazorSQL [closed]
I keep getting an
incorrect syntax near '/'
when trying to update a table row in RazorSQL. There is a lot of HTML in this entry. Saving just some text works fine so I imagine I have to escape ...
0
votes
0answers
112 views
how do i bulk copy a huge amount of data and keep the same table updated through stored procedure in SQL SERVER [duplicate]
Possible Duplicate:
How to move data from big table
In my project i need to fetch datas from different tables in a data base and create a new table with the same colmn names for all those ...
0
votes
1answer
407 views
Using Sync Orchestrator to Syncronize two SQL CE 3.5 Databases
I am trying to set up synchronization between two SQL Compact 3.5 databases using SqlCeSyncProvider. I am able to create a scope for the two databases, which creates a meta table. When I try to run ...
0
votes
0answers
393 views
AFTER INSERT Trigger [closed]
I have a table called Customer_Career and there are ID,CusID,SponsorID,CareerID,PeriodID columns.
Secondly,I have a table called Customer_Career_Period and there are ...
0
votes
2answers
170 views
optimize big sql query
My query has to return a statistics for example for march containing productname and price and its sidedishes (1:n relation) with the right price of each sidedish and the right tax for each sidedish ...
-1
votes
3answers
138 views
SQL Server - Transaction Slowness
Using: SQL Server 2008 R2
I'm seeing some behavior right now in SQL Server, and I can't decide if the server is underperforming or not.
I've set up a test to insert an integer into a table, as ...
-1
votes
3answers
105 views
Add Contents in a Column and make them 0 [closed]
http://sqlfiddle.com/#!3/96f11/3
In the above fiddle, I need the required output in the Fiddle.
ie., The UserID column in Filtered Table and Main table are equal.
I need to get the Amt column data ...
-1
votes
1answer
56 views
Single quote issue
I have to update a column where I am giving query which is
Update Table
Set col = '[189] IS NOT NULL and [189] <> '''
Where colid= 198
But it's giving output:- [189] IS NOT NULL and ...
-1
votes
3answers
750 views
Conversion failure varchar to int
When running this code:
declare @SQL NVARCHAR(max);
declare @intFlag INT;
set @intFlag = 2;
SET @SQL = ' SELECT * into [##tmp1]
FROM servicesstats_0511_0412 s WHERE department=''ACC''
and ((SELECT ...
-1
votes
2answers
205 views
Oracle SQL Query/SubQuery Single column with mutilple data [closed]
Id File-Name Descrption
1 yyyy Started
2 yyyy incompleted
3 rrrr Started
4 tttt started
5 uuuu started
6 rrrr completed
7 tttt completed
8 uuuu ...
-1
votes
1answer
306 views
Very slow MySQL query. Index problem?
I have a query like this:
SELECT
BE.NAME as NAME,
BE.PREVIEW_TEXT as PREVIEW_TEXT,
BE.ID as ID,
FPV1.VALUE as PROPERTY_COUNTRY_VALUE,
FPV1.ID as PROPERTY_COUNTRY_VALUE_ID,
...
-1
votes
2answers
484 views
Multiple child tables
I would like to know what is the best solution for making a parent table with multiple children?
I have to make multiple children table. One for each profile.
Is there a better idea than having 3 ...
-1
votes
2answers
61 views
Infinite Loop While Running Query
When I run this query from the command line, it continuously loops. I'm not sure why this is occurring. Could anyone explain this to me, and please offer a fix.
I will be using a query similar to ...
-1
votes
1answer
29 views
BULK INSERT in SQL
I have a text file , entries of which i want to insert into a table in my DB.
My query looks like this:
BULK INSERT myDepartment FROM 'C:\myDepartment-c-t.txt'
WITH (
DATAFILETYPE = 'char',
...
-1
votes
1answer
54 views
Adding a column at a specific position using DBMS_REDEFINITION
Can anybody tell me how I can add a column to table at a specific position using the DBMS_REDEFINITION package from Oracle?
-1
votes
2answers
65 views
How to do division from select statements in sql server?
I am trying to create a select statement that can return a table of 1 column.
Basically, I am looping through all the records of NewHire, and then using its id, to select stuff from another table. I ...
-1
votes
2answers
120 views
Select query having count and variable
I have a table like the one below.
I need to form a select query. I'm going to pass a RefID like
SELECT SNo FROM Register WHERE RefID = 1
And beside the SNo in the Statement, I need to have ...
-1
votes
2answers
135 views
Does MYSQL join before LIMIT?
Imagine that I want to populate the last 10 questions of stackoverflow. I have a table that keep the questions list, a table to keep the question info, a table to list question's asker.
Now imagine ...
-1
votes
1answer
54 views
Select query from two tables which only specified rows [closed]
I want to try querying two tables, like this:
Table A
user_id primary_indicator
------- -----------------
9012445 Y
9012445 N
9012442 N
9012332 Y
9012332 N
9012445
9012332
Table B
...
-1
votes
1answer
70 views
Can I make that connection?
If I have a column with data type varchar(max) in a table that contains a big piece of text, can I make a connection between a word or a sentence in that text with another word or a sentence in ...
-1
votes
1answer
108 views
Selecting just one table from Oracle view [closed]
I am creating a view to ease my manual selecting because I only want to fetch data from DB where it is meeting certain criteria which are present in several tables, so it is containing a lot of joins.
...
-1
votes
1answer
75 views
How to select a row on one distinct attribute? [closed]
I want to select * from A A but only where A.attr1 is distinct. How can I do this?
-1
votes
1answer
65 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
-1
votes
1answer
55 views
Why is this mysql query wrong? [closed]
I try to run the following sql query in mysql
SET @rank:=0;
WITH TEMP
(
SELECT @rank := @rank + 1 AS ROW_ID , UUID() as RANDOM_VALUE,D.*
FROM house_information_new D
ORDER BY ...
-1
votes
2answers
75 views
Combine two SQL statements to a single statement [closed]
My question is related to SQL. I need to pull values from two different tables. I am not successful in doing that. I am able to join the two tables with only a single condition but not many values ...
-1
votes
1answer
187 views
Connecting to database using Toad in windows
I am trying to connect to a database using Toad on windows 7.
But I am not able to connect because I dont have SQLNET Editor, TNSNames Editor and LDAP Editor installed.
Please help me with this. I ...
-1
votes
1answer
71 views
Index Proposals
As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
-1
votes
2answers
166 views
Parsing a string result from a query
My sql server 2008 query returns a very long strings such as:
GET ...
-1
votes
1answer
390 views
how to sum column values with same id [closed]
with this query :
SELECT a.nid, a.stock, b.qty
FROM uc_product_stock a
INNER JOIN uc_order_products b ON a.nid = b.nid
I have the following result:
nid stock qty
11 256 4
11 256 ...
-1
votes
2answers
122 views
Information sources for multiple hierachy trees in a single table
I need some quality sources - books, websites etc. - to educate myself about putting multiple hierarchy trees in a single table using SQL.
I'm looking for some good theoretical and practical ...
-1
votes
1answer
188 views
What exactly is SOLR? [closed]
It seems like a magical technology that can
Do spatial search
do full text search
The problem is,
It doesn't say where does it store all the data. Does it have it's own proprietary database
If it ...
-1
votes
2answers
168 views
Tutorial in datamining [closed]
Where can I find about tutorial of datamining in SQL server 2012 or 2008 R2?
The purpose is to improve my knowledge in datamining.
-1
votes
1answer
1k views
sql server - could not allocate space for object
I am trying to retrieve the first 1000 records of my view and am getting this error message:
Msg 1105, Level 17, State 2, Line 2
Could not allocate space for object 'dbo.SORT temporary run ...
-1
votes
0answers
28 views
How much time is considered 'Ideal' for a SELECT query? [closed]
This is my first experience in developing for the masses, and I wanna know how much time is considered ideal for running a select query and returning the data to the client?
I've seen simple queries ...
-1
votes
0answers
54 views
2 Outer Joins on Same Table? [closed]
Here is a question which has been boggling me for few days now, and I searched and searched but couldn't find any convincing answer !
Simple question, why is it restricted to have 2 Outer Joins in ...
-1
votes
0answers
38 views
Optimize SQL Select Command [closed]
Is there anyway to speed this up by optimizing/condensing the code?
SELECT fullName, email_address, pos_desc, EXT
FROM dbo.BTC_WEB_EMPLOYEE_VIEW
WHERE grp_cde = 'STAFF'
OR grp_cde = 'PROF'
OR ...
-1
votes
0answers
37 views
Transforming natural language to SQL [closed]
So i have this example.
E ≡ O (f.codf,COUNT(DISTINCT f.codp)) I (furnizeaza f) W(E1) G(f.codf)
E1 ≡ 2 = E2
E2 ≡ O (COUNT(s.cods)) I (sectii s) W ((s.cods,f.codf) τ furnizeaza f2[f2.cods,f2.codf]
...
-1
votes
0answers
32 views
Looking for SQL Training Options? [closed]
I am interested in getting an entry level job working with SQL and I'm wondering if anyone has any recommendations for training programs. I am looking for something that would provide a certificate ...
-1
votes
1answer
64 views
validate where each parent intermediary is also a parent to itself [duplicate]
I want to validate where each parent intermediary is also a parent to itself. So this query should return invalid parents in SELECT If table has any.
I need to do is first of all get all parents ...
-1
votes
0answers
44 views
which database suitable for huge inserts for analytics system [closed]
I want to develop a analytics system for very high traffic web sites, that records many behaviors of users. I want to choose a proper database for doing it well.
This database must suitable for huge ...
-1
votes
0answers
38 views
How can I delete duplications with one query? [closed]
Is there any way to delete duplications with one, or only two queries? I'm not good with SQL.
Now I'm trying this solution:
$le = mysql_query('SELECT * FROM tbl_answers');
while($i = ...
-1
votes
1answer
31 views
checking a folder whether required file is present at a regular interval [closed]
i have 4 folder hierarchy in a following format :
Hourly Daily Weekly Monthly.
In every folder i have files which is coming in a frequency based on their folder's name.
Now , i have ...
-1
votes
1answer
52 views
populate table header and data in another table column [closed]
I have 2 tables: Departments and Employees, where Department_Id is primary key in the departments table and a foreign key in Employees table.
Departments Table:
Department_Id Department_Name
10 ...
-1
votes
1answer
58 views
Directory lookup failed during log shipping
I have configured log shipping for all our SharePoint 2010 databases. All worked well since Friday and today Monday I ran this query:
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
WHERE [message] like ...
-1
votes
1answer
30 views
Can we see the implementation of oracle built in function through query? [closed]
For example: I want to see defintion of UPPER function in oracle. What will be query for same?
-1
votes
1answer
42 views
what kind of owner to defined when creating Sql server DB for web site? [closed]
what kind of owner to defined when creating Sql server DB for web site ?
I am trying to create db and i need to select owner.
my db will serve aspnet web site and I wonder witch owner will be safe to ...
