|
I get around this, and other issues such as collation issues between SQL Server and Excel, by always passing dates to Excel as text in a format of dd-MMM-yyyy e.g. '01-Jan-2014'.
It's not pretty but it has worked so far...
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
modified 30-Jun-14 8:06am.
|
|
|
|
|
Hi all;
I am learning to write stored procs on MySQL and am going crazy.
DELIMITER $$
DROP PROCEDURE IF EXISTS CleanCopyEnvData$$
CREATE PROCEDURE CleanCopyEnvData ()
BEGIN
insert into EnvData(UserDate, XAction, Balance, UserID)
select
CAST(udate as Date)
, CAST(amount1 as Decimal(6,3))
, CAST(amount2 as Decimal(6,3))
, CAST(UID as UnSigned)
from
DataLoad;
END $$
DELIMITER ;
I get an error:
Error starting at line : 17 in command -
END $$
Error at Command Line : 17 Column : 1
Error report -
SQL Error: 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 'END $$' at line 1
I am using Oracle SQL Developer and the INSERT statement works ok when executed on its own. I can do these things blindfolded with my arms tied on MSSQL. Any help appreciated.
EG.
|
|
|
|
|
You don't need the delimiter expression $$ after your END statement.
DELIMITER $$
DROP PROCEDURE IF EXISTS CleanCopyEnvData$$
CREATE PROCEDURE CleanCopyEnvData ()
BEGIN
insert into EnvData(UserDate, XAction, Balance, UserID)
select
CAST(udate as Date)
, CAST(amount1 as Decimal(6,3))
, CAST(amount2 as Decimal(6,3))
, CAST(UID as UnSigned)
from
DataLoad;
END
Everyone dies - but not everyone lives
|
|
|
|
|
|
Glad to help.
Everyone dies - but not everyone lives
|
|
|
|
|
Hi,
I have .NET WinForm application with MySQL backend.
It's an HR application.
I want to store employee documents such as ID card, passport, letters (e.g. salary certificates, warning letters, etc).
I don't want to store the scanned documents in the database itself therefore I am planning to store it on my file server and just save a link in MySQL.
My question, if I save a link, how can I make sure no one will know that link's folder then open it and see everything else?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Just store the filenames without the path to the file server in the database table. Store the path to the file server separately say in another database table and concatenate it with the filename by code whenever user wants to access a file.
|
|
|
|
|
Instead of using a plain database back-end, create a server which communicates with the clients and the database. So any client will contact the server which in turn talks to the database and file system, and serves the data/documents back to the clients.
|
|
|
|
|
what is difference and similarities between mysql and ms sql server.
|
|
|
|
|
They are exactly the same except SQL Server is better in every way.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
can we use them by replacing each other with other tools for example can i use mysql with asp.net and php with ms sql server
|
|
|
|
|
Mix and match to your heart's content.
Best use a layered approach of course. The front-end shouldn't care what the back-end is.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
plz explain something called in simple words thank you
|
|
|
|
|
You put the lime in the coconut.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
|
There are differences in query keywords and functionality; also differences in datatypes (MySQL does not have a Guid datatype). Also MySQL has some strange calculation bugs when dealing with DateTime values. Escaping reserved keywords uses different characters. Etc...
You cannot simply replace MS SQL Server and MySQL, you'll need to adjust your application to the database!
|
|
|
|
|
If there are any, what is the difference between Data Warehouse and Database?
|
|
|
|
|
|
I don't want the answer of Google I would like the answer of developers. Google is an advertising and media company  .
|
|
|
|
|
Google Search engines returns also articles, blog posts, etc., written by developers.
|
|
|
|
|
Well... it's the same you know.
For some reason I won't explain here it happens that companies or countries block some websites. Some companies block everything except professional website like this one (codeproject) or Microsoft or universities, ... But blogs are blocked.
That the reason I don't like when people answer to go to check on Google or other search website.
|
|
|
|
|
The purpose.
A traditional transactional database is made for storing data. These databases are generally highly normalized to keep the referential integrity, but might be to slow for analytical queries.
A data warehouse is optimized for analysis of the data. The data is therefore often stored in a denormalized and/or aggregated form. To make sure the referential integrity is kept intact they usually pull their data from a transactional database.
|
|
|
|
|
There is not a straight answer to that question as there are many different forms of data warehouses.
Also a data warehouse is a database so the question does not really make sense.
The data warehouses I have worked with differ from non data warehouse databases in the following manner:
A data warehouse keeps transactional data so that the state of a database at any point in time can be recreated.
As a consequence data warehouses contain a lot of data as every single change, at the column level, illicits the creation of a new row.
Data warehouses can contain raw, staging and warehouse schemas to enable the verifying of data before it is placed in the data warehouse.
A data warehouse is generally used where one wants to be able to have an audit trail of the contents of the database.
That's my t'penneth.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
modified 27-Jun-14 4:23am.
|
|
|
|
|
Hello,
I'll have to create a new database. It's a classic membership database. I need to create tables to allow my users to identify with Facebook, Google, Windows, ...
I'm not the first one to create this kind of database. I would like to know if it exists a website with samples, helpers or pattern of classic database design (in UML or ERM).
Thank you,
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
