by: Dylan Nicholson |
last post by:
Seems that Oracle 9.2 (using MS ODBC driver) requires extra
parentheses when adding multiple columns to a table:
ALTER TABLE MyTable ADD (MyColumn1 VARCHAR(255), MyColumn2
VARCHAR(255))
vs
...
|
by: Stephen Miller |
last post by:
Is it possible to ALTER a temporary table in TSQL (SQL2000)?
The following TSQL reports a syntax error at the ALTER TABLE line:
DECLARE @Test TABLE(
NOT NULL ,
NOT NULL
)
ALTER TABLE...
|
by: Paul Sampson |
last post by:
Hi,
I'm trying to run the ALTER TABLE command using a dynamic string for the
table, like so:
DECLARE @TableName CHAR
SET @TableName = 'Customers'
ALTER TABLE @TableName
ADD ...blah
|
by: Kevin Haugen |
last post by:
I need to create a script to disable all triggers and constraints in my
database.
It appears as though I cannot use a local variable for the table name in the
ALTER TABLE statement (e.g. ALTER...
|
by: Klemens |
last post by:
Hi,
I get an implicit -101 on an alter table statement on changing the length of
one column
ALTER TABLE XTRADE.LIEFERANT ALTER COLUMN ZENTRALE_NUMMER SET DATA TYPE
VARCHAR(13)
DB21034E The...
|
by: BuddhaBuddy |
last post by:
Platform is DB2/NT 7.2.9
The table was created like this:
CREATE TABLE MYTEST (
MYTESTOID bigint not null primary key,
FK_OTHEROID bigint not null references other,
FK_ANOTHEROID bigint not...
|
by: Kimi |
last post by:
Hi,
I'm trying to change a column on a DB2 table so that it has a default value
but I cannot get it to work. Does anyone have any experience in this area.
I'm trying with this statement:
...
|
by: RamaKrishna Narla |
last post by:
In MS SQL Server, I have the following tables with some data in it.
create table table1 (
column1 varchar(32),
column2 int not null,
column10 varchar(255),
.....
primary key (column1,...
|
by: islandtalker |
last post by:
Hi,
In a stored procedure (MS SQL) I want to update a table to Add columns to it, and then update those new columns with data from a variable.
The problem is that, after updating the table I...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|