well very new to sql,as I am...
I am posting this query,please explain me what it is, - CREATE TABLE [dbo].[DOORD_ORDER] (
-
[ORDER_NBR] [int] NOT NULL ,
-
[TOTAL_SEQ_NBR] [int] NOT NULL ,
-
[DELIVERY_IND] [char] (1) NOT NULL ,
-
[CONTACT_LST_NME] [varchar] (30) NOT NULL ,
-
[CONTACT_FRST_NME] [varchar] (40) NOT NULL ,
-
[CONTACT_TYP] [varchar] (30) NOT NULL ,
-
[CONTACT_TXT] [varchar] (100) NOT NULL ,
-
[OR_CDE] [char] (1) NOT NULL ,
-
[DROPOFF_DTE] [datetime] NOT NULL ,
-
[PICKUP_DTE] [datetime] NOT NULL ,
-
[LST_OPR_ID] [char] (8) NOT NULL ,
-
[LST_MNT_TSMP] [datetime] NOT NULL ,
-
[WAIT_INSTORE_IND] [char] (1) NOT NULL
-
) ON [PRIMARY]
-
GO
-
ALTER TABLE [dbo].[DOORD_ORDER] WITH NOCHECK ADD
-
CONSTRAINT [PK_DOORD] PRIMARY KEY CLUSTERED
-
(
-
[ORDER_NBR]
-
) WITH FILLFACTOR = 90 ON [PRIMARY]
-
GO
-
4 2500
Hirak
This query creates a new table called [dbo].[DOORD_ORDER] and then adds a constraint to the table in this case designates the primary key [ORDER_NBR].
Mary
well mary,is this oracle?
we didnt do like this in oracle,right?
please tell me what type of db query is this
hirak
Hirak
This query creates a new table called [dbo].[DOORD_ORDER] and then adds a constraint to the table in this case designates the primary key [ORDER_NBR].
Mary
well mary,is this oracle?
we didnt do like this in oracle,right?
please tell me what type of db query is this
hirak
Actually it does look like Oracle to me. It's been a while since I've used it though so I could be wrong. It could also be SQL Server. Sorry Hirak I haven't used either in a few years and they all just blend together now.
Mary
you need not be sorry mary because you are right.
this is a sqlserver query I found out now.
I am sorry to post it in oracle forum,because then I didnt have an idea,what it was.
I dont have necessary privileges,please transfer it to the sqlserver forum
Actually it does look like Oracle to me. It's been a while since I've used it though so I could be wrong. It could also be SQL Server. Sorry Hirak I haven't used either in a few years and they all just blend together now.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Phil Powell |
last post by:
create table if not exists nnet_produkt_varegruppe (
nnet_produkt_varegruppe_id int not null auto_increment,
primary key(nnet_produkt_varegruppe_id),
nnet_produkt_varegruppe_navn varchar(255) not...
|
by: js |
last post by:
I am trying to create a primary key constraint on a view in the
following statement. However, I got an error ORA-00907: missing right
parenthesis. If the CONSTRAINT clause is removed, then the...
|
by: danths |
last post by:
Hello,
I am being sent a fmt file and a data file without headers which I
would like to import into my sql 2000 server. However the data files
have couple of 100's of columns, how could I avoid...
|
by: teedilo |
last post by:
Our MS SQL (SQL Server 2000) DBA has database privileges locked down
pretty tightly. We end users/developers do not have administrator
privileges for most databases. That arrangement has worked...
|
by: max |
last post by:
Hello,
I am a newbye, and I'm trying to write a simple application.
I have five tables with three columns; all tables are identical; I need to
change some data in the first table and let VB...
|
by: Priya |
last post by:
Hey all,
Is there a way to create a table in the SQL database by using an XML
file as an input? I want to have an XML file which holds all the
details of the table like the tablename, columns,...
|
by: Jeff Kish |
last post by:
Hi.
I have a procedure with this in it (there are no other references to
asset_number_bak_tmp_pk in the procedure and it calls nothing else written by
me, just system calls or normal dml).
...
|
by: yeoj13 |
last post by:
Hello,
I have a db2load script I'm using to populate a large table.
Ideally, my target table is required to have "Not Null" constraints on
a number of different columns.
I've noticed a ...
|
by: Rahul B |
last post by:
Hi,
I have a user UCLDEV1 which is a part of staff and a
group(db2schemagrp1) to which i have not given any permissions.
The authorizations of that user are shown as
db2 =get authorizations...
|
by: jarea |
last post by:
I have read quite a bit about this error but I have yet to find the solution to my problem.
I am trying to execute the following mysql statement:
alter table line_items
add...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: 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...
| |