|
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: teccer |
last post by:
How do you find the date of when a column was add to a table with alter (DB2 V8.2 UDB)
|
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: 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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
|