by: FRED |
last post by:
hi all,
i have a table that has a column date varchar(20) and now i learned some
more about mysql I want to make it date date but if I do an alter table on
it what will it do to my existing data...
|
by: Geoff Jones |
last post by:
Hi
I have a table that contains date/time together in one field. Is it possible
to ALTER the table so that this field now only contains the time (or date)?
Thanks in advance
Geoff
P.S....
|
by: M Simpson |
last post by:
/* for the google index */
ALTER TABLE
DEFAULT COLUMN
DEFAULT VALUE
I've worked out several stored procedures for altering the default column
values in a table. They were compiled from books...
|
by: me |
last post by:
I would like to add an Identity to an existing column in a table using a
stored procedure then add records to the table and then remove the identity
after the records have been added or something...
|
by: Mike L |
last post by:
Hello all
I'm trying to migrate a BE from Access to SQL Server.
I've been making changes to the Access BE from the FE with SQL
statements, and want to do the same with the BE in SQL Server.
...
|
by: bloc |
last post by:
I am programming an interactive CV using xml, xslt and java script. The
page consists of a header which contains links to various 'sections' on
the xml cv, a left and right menu, and a central...
|
by: aspatsli |
last post by:
Hi
I am using oracle 9.2.0.1 in windows XP.
When I try to alter a co-dependent type I get an error as follows.
Please look at the script and help me to solve it.
Thanks
|
by: cmartin1986 |
last post by:
Hi,
I am trying to write code to change my table data types. what i have so far is:
currentdb.execute "alter table getdates alter column Line Unit 0001 date"
If I leave it at that it...
|
by: semaj.remle 'at' gmail |
last post by:
For files saved in source control, is it better to use code to DROP/
CREATE a procedure like this:
------------------------------------------------------------------
IF OBJECT_ID ('procName') IS...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|