I have a Profile model/controller in my cake app as well as an index.ctp view in /views/profiles. Now, when I go to add a column to my table that is already filled with data, and then add the …
Export unicode data from mysql
I have some data in one of my mysql table stored as utf8. The data is some japanese text. I need to export it to excel. Could you tell how to do it? Exporting by SELECT … INTO OUTFILE returns some plain text file. I’m not sure how to read it back in excel so that japanese character would show
clearing an entire column in access
is there a way to clear an entire column in a datasheet in access? i can just right click on it and delete it but that will affect the structure, i just need to clear all the records. how do i do this? perhaps the question i should be asking is how do i clear the entire contents of a
How to use a value from one stored procedure in another?
I have the following statement in a stored procedure: DECLARE @Count INT EXEC @Count = GetItemCount 123 SELECT @Count Which calls another stored procedure with the following statement inside: SELECT …
Guid Primary /Foreign Key dilemma SQL Server
I am faced with the dilemma of changing my primary keys from int identities to Guid. I’ll put my problem straight up. It’s a typical Retail management app, with POS and back office functionality. Has …
From Now() to Current_timestamp in Postgresql
In mysql I am able to do this: now in postgresql I am using this query: but I get this error: How can I resolve ? Answer Use an interval instead of an integer:
Keep local MS SQL 2008 DB table and remote SQL Azure DB table in sync
I have a dedicated server which hosts a Windows Service which does a lot of very heavy load stuff and populates a number of SQL Server database tables. However, of all the database tables it populates and works with, I want only one to be synchronised with a remote SQL Azure DB table. This is because this tab…
SQL using sp_HelpText to view a stored procedure on a linked server
Anyone have an idea about how to use sp_helptext to view a stored procedure on a linked server? basically something like this. I don’t have the credentials to that linked server to look at it. EXEC …
how to show partial key in uml er diagram
in chen’s notation partial keys (discriminator) were shown as dashed lines, how are they shown in uml er (entity-relationship) diagram?
Remove trailing zeros from decimal in SQL Server
I have a column DECIMAL(9,6) i.e. it supports values like 999,123456. But when I insert data like 123,4567 it becomes 123,456700 How to remove those zeros? Answer A decimal(9,6) stores 6 digits on the right side of the comma. Whether to display trailing zeroes or not is a formatting decision, usually implemen…