The set of rules that define the combinations of symbols that are considered to be correctly structured for that language.
0
votes
1answer
48 views
Error “#1118 - row size too large” on the first row of the table only
I ran into a problem using a mySQL database. I have some columns as type text but when I try to enter data into the first row I get the error code "#1118 - Row size too large. The maximum row size for ...
1
vote
2answers
31 views
getting error when i use merge statement
I am using sql 2008 r2. when i use merge statement i am gettig error
when i execute following code:
merge products as trgt
using updatedproducts as src
on (trgt.productid = src.productid)
...
0
votes
1answer
40 views
MySQL UPDATE statement using a table created on the fly
I want to update a table, say Table 1 using a table that I create on the fly (saytemp). To achieve this I have the following query:
UPDATE Table1 SET COUNT = temp.ctemp FROM ( SELECT A, SUM(UNO) AS ...
0
votes
1answer
138 views
MySQL: Create multiple tables with one query
Can you list multiple table names in a MySQL CREATE TABLE query?
CREATE TABLE table1, table2, table3 LIKE table_template;
If so, can you do it with the IF NOT EXISTS clause?
CREATE TABLE IF NOT ...
0
votes
1answer
54 views
syntax error within php script sql statement [closed]
I am getting this error when I execute this script:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table) ...
0
votes
1answer
40 views
Need Some SQL help [closed]
I need to pass the following SQL statement:
UPDATE table_products
SET shipping = "a:5:{s:16:"min_items_in_box"; i:0;s:16:"max_items_in_box"; ...
1
vote
1answer
245 views
declare keyword error mysql
This is the code I've written:
delimiter //
create procedure `update_pts`()
begin
set @ctr=1;
set @cnt=(select count(*) from participant);
declare cs1 cursor for select sap from participant;
open ...
2
votes
2answers
70 views
Is there a way to avoid duplicating the definition of a foreign key?
I was wondering about this example
CREATE TABLE cities (
city varchar(80) primary key,
location point
);
CREATE TABLE weather (
city varchar(80) references ...
0
votes
1answer
92 views
Group By - Incorrect syntax near 'mycolumn' [closed]
I'm getting a syntax error in SQL Server Management Studio (SQL Server 2008) for the following query:
SELECT
MIN(EffectiveOn) AS EffectiveOn,
Address1,
Address2,
Address3,
...
1
vote
1answer
79 views
SQL query to get the syntax of an existing table
Is there any SQL query to get the syntax of an existing table in my MySql database?
Intent:
Iam in the early stages of working with databases and I am using the MySql workbench for creating tables ...
1
vote
0answers
88 views
TSQL Trigger Incorrect Syntax
Im a SQL noob but here goes - I have a trigger in SQL which is giving me an incorrect syntax error E.G:
INSERT INTO aTable
(
tTypeId,
opId,
inserted.Id
)
SELECT
3,
0,
inserted.Id
...
1
vote
1answer
160 views
MySql: #1221 - Incorrect usage of UNION and ORDER BY
I have the following query which is intended to retrieve the newest 3 comments for each post in an array of posts.
SELECT * FROM comment AS tbl WHERE sscm_id IN
(
SELECT sscm_id FROM comment AS t1 ...
0
votes
2answers
215 views
Save data to variable and use it in stored procedure
I have a table of 2 columns (Date, Text). I am getting data from the Text column according to the Date using a query like this:
SELECT Text
FROM MyTable
WHERE Date>= @userDate;
This works, ...
0
votes
1answer
51 views
How to add the aliases to the group by clause
In the below query how to add the aliases assignedTOiti, assignedTOasstAdm, assignedTOhlp, closedDate to the group by clause.
I am struggling for the past few hours.
SELECT ieor.aper07_req_k ...
4
votes
1answer
132 views
Detecting if bit set in numeric value
I have a tinyint column that represents a set of flags. Assuming I wanted to know if a specific bit was set or not, how can I do bitwise AND/OR in a stored procedure?
1
vote
1answer
74 views
What is the purpose of the keyword “ID” in PostgreSQL?
I'm new to PostgreSQL and I ran into problems using the following query:
SELECT * FROM table1 WHERE ID = 1
ERROR: column "id" does not exist
LINE 2: WHERE ID = 1
where ID is a column I ...
7
votes
2answers
257 views
What is the purpose of the USING parameter in SQL?
Working with some code on a standard MySQL database, and I came across this statement:
SELECT * FROM foo LEFT JOIN bar USING ('bar_id') WHERE foo_id = 1
What's throwing me is: what is USING for, ...
2
votes
2answers
1k views
What is the easiest way to move data from Oracle to SQL Server?
One of our products supports both Oracle and SQL Server as database backend. We have a customer who wishes to switch from an Oracle backend to Microsoft SQL Server, which isn't a typical transition ...
2
votes
1answer
275 views
create trigger which inserts rows depending on enum values?
I'm quite new to triggers and I ran into general problems. I'd like to achieve this:
CREATE TABLE `searcharticles` (
`articleID` int(11) unsigned NOT NULL,
`ean` char(13) COLLATE utf8_unicode_ci ...
0
votes
2answers
3k views
MySQL Set UTC time as default timestamp
How do I set a timestamp column whose default value is the current UTC time?
MySQL uses UTC_TIMESTAMP() function for UTC timestamp:
mysql> SELECT UTC_TIMESTAMP();
+---------------------+
| ...
2
votes
1answer
123 views
Is it possible to make a reference to the result of an aggregate function in a SELECT clause from the same SELECT clause?
I'm not a Database Administrator--just a Software Engineer. I would like to know if it is possible to reduce the following T-SQL query:
SELECT
SUM(Price * Quantity) as 'Total',
SUM(Price * ...
1
vote
2answers
639 views
How to schedule function in Oracle?
I want to schedule function in Oracle.
begin
dbms_scheduler.create_job(job_name => 'aud_clear',
job_type => 'PLSQL_BLOCK',
...
0
votes
3answers
80 views
Is it possible to check a date in SQL?
I'm trying to write a Microsoft SQL Server stored procedure which takes an account ID, and returns an authentication ticket and whether the ticket is expired.
Something like this:
SELECT ...
2
votes
2answers
395 views
How does pgAdmin III build CREATE statements?
In PostgreSQL, there is no SHOW CREATE statement, known for example from MySQL. But when you use the pgAdmin III client program and go to object details, you see the corresponding CREATE statement.
...
0
votes
3answers
38 views
helping hand for sql server resources
I'm just getting into SQL-SERVER, so forgive me if this is a basic question.
I need help, recently work on database programming, For my query development, to understand complex query, to can ...
17
votes
3answers
2k views
Performance difference for COALESCE versus ISNULL?
I've seen a lot of people use the COALESCE function in place of ISNULL. From internet searches, I've found that COALESCE is ANSI standard, so there is an advantage that we know what to expect when ...
2
votes
2answers
1k views
How do I declare and use variables in Oracle?
My main skills are with SQL Server, but I have been asked to do some tuning of an Oracle query. I have written the following SQL:
declare @startDate int
select @startDate = 20110501
And I get this ...
4
votes
3answers
219 views
How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?
I have a problem with an update statement, that I developed under 11g, when running under 10g.
I reduced the problem to:
Create table test (
col1 number(10)
);
insert into test values (1);
...
5
votes
1answer
300 views
Why can't I call my UDF directly? Why do I need to qualify it 3 levels deep?
I just created a UDF and testing it I found only works when I use this syntax
SELECT [PMIS].[dbo].[fnIsReportingTo] (50,1132)
I was expecting it to work like this:
select * from fnIsReportingTo ...
3
votes
2answers
707 views
SQL Server 2005 : How to use pivot instead of a bunch of case statements?
Please show me how I can modify this SQL select to use pivot instead of all the case statements.
SELECT t.ProjectId,
COALESCE(MAX(ExecutiveChampion), 'n/a'),
...
13
votes
2answers
761 views
Peculiar Oracle outer join syntax case
I have seen the following in a query that was supposed to be ported from Oracle outer join syntax to SQL standard outer join syntax:
SELECT ...
FROM A, B, C, D, E
WHERE A.A_ID = B.A_ID
AND B.B_ID = ...
4
votes
1answer
215 views
Are there tools for SQL-Server helping to add the semicolons?
Earlier versions of SQL-Server didn't recommend the use of semicolons to terminate sql-statements.
Beginning with sql-server-2008 examples show, that now Microsoft recommends terminating with ...
