CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible BOOLEAN default false)
I'm using this against an Access DB using JET driver... I keep getting
a syntax error which goes away when I remove the last line... Any
ideas whats wrong with it?
Thanks!
CREATE TABLE IF NOT EXISTS TempA (id int);
CREATE TABLE IF NOT EXISTS TempB (id int);
For some reason the above statements are giving me syntax errors?
I want to create table only if it does not already exist.
Also, can the same "if not exists" clause be applied to "DROP TABLE" and "TRUNCATE" ?
thx in advance .
Ok I am new to Sql and am wonder How I can (when createing a table ) have a field that is auto incremented.
Here is what I have so far
Code:
CREATE TABLE test (`id` INTEGER NOT NULL, `test` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)
I want the primary key id to be an incremented number.
I am used to mysql and I would just have the field created as an AUTO_INCREMENT.
Do I use the INCREMENT function within the first query or do I have to have another query that will alter the table and make the field an auto incremented number.
Any suggestions would be great.
Thanks,
Tom
I am trying to create a database and I manage to get the code right for dropping the database if it already exists and then createing the data file and log file. After this I try to set some options for the database with the following code
ALTER DATABASE MyDataWarehouse
SET RECOVERY SIMPLE,
ANSI_NULLS ON,
ANSI_PADDING ON,
ANSI_WARNINGS ON,
ARITHABORT ON,
CONCAT_NULL_YIELDS_NULL ON,
QUOTED_IDENTIFIER ON,
NUMERIC_ROUNDABORT OFF,
PAGE_VERIFY CHECKSUM,
ALLOW_SNAPSHOT_ISOLATION ON;
GO
But I get an error saying Incorrect syntax near 'CHECKSUM'.
Hi guys,
I need to pass some SQL to someone else who will run it on their database. I have got the SQL for SQL Server 2000 but they are running SQL Server 7. Apparently the below MSSQL 2000 script doesn't work;
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tableName](
[id] [int] IDENTITY(1,1) NOT NULL,
[ArticleID] [int] NULL,
[Heading] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BodyContent] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WrittenDate] [datetime] NULL,
CONSTRAINT [tableName] PRIMARY KEY CLUSTERED ( [id] ASC )
)
What is the equivalent of the above in for SQL Server 7? I don't have access to it via SQL Server Manager so have to run the script.
I am having 100 of flat files need to load in respective staging table.I want to create table on run time as per filename input.suppose if input filename is ABC then table name should be Staging_ABC if file name is XYZ then it should be Staging_XYZ.Table structure is below need to create at run time
CREATE TABLE Staging_'Filename'(
[COL001] [varchar](4000) NULL,
[Id] [int] IDENTITY(1,1) NOT NULL,
[LoadDate] [datetime] NOT NULL default getdate()
)
Hello,
the following alter table statement:
ALTER TABLE [dbo].[CalCalendar]
ALTER COLUMN [OID] uniqueidentifier NOT NULL PRIMARY KEY NONCLUSTERED
is answered with:
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'PRIMARY'.
which I consider to be interesting. Anyone has an idea why? I checked documentation but I do not see an error.
Note that:
ALTER TABLE [dbo].[CalCalendar]
ALTER COLUMN [OID] uniqueidentifier NOT NULL
DOES get executed, and
ALTER TABLE [dbo].[CalCalendar]
ALTER COLUMN [OID] uniqueidentifier NOT NULL PRIMARY KEY
produces the same error.
Now, in my understanding this has nothing to do with an index may already exist etc. - the eror indicates a SYNTAX error, before any checking. Makes no sense to me, though, reading the documentation.
So - anyone an idea?
HiHaving a problem with a ms sql 2000 server. The script below wascreated i SQL manager 2005 lite and gives a syntax error near '('ALTER TABLE [dbo].[Community_ActivityLog]ADD CONSTRAINT [PK_Community_Errors]PRIMARY KEY CLUSTERED ([activity_ID])WITH (PAD_INDEX = OFF,IGNORE_DUP_KEY = OFF,STATISTICS_NORECOMPUTE = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON)ON [PRIMARY]GOAny ideas of what might be wrong?/Michael
View 1 Replies View RelatedFolks!
What is wrong with my syntax with the following command?:
alter table EmployeeInfo alter column OriginDate smalldatetime not null default getdate()
I'm getting:
Incorrect syntax near the keyword 'default'
Currently, in my table OriginDate is nullable with no default.
Thanks in advance for your help!
APF
Have been given this code to create a table
CREATE TABLE 'emaillist' (
'id' INT(11) NOT NULL AUTO_INCREMENT,
'clientname' VARCHAR(200) NOT NULL DEFAULT '0',
'email' VARCHAR(200) NOT NULL DEFAULT '0',
PRIMARY KEY ('id')
);
when I execute it says
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'emaillist'.
What the correct code should be?
I am trying to access data from a database to print a report. The code I am using says I have a syntax error regarding the object person_info. Person_Info is a table value function on the SQL Server (2005). Does anybody see a problem with this line of code? Thanks for your help! Regards, Steve
"INNER JOIN (SELECT * Person_Info FROM (" & Session("current_project") & ")) ON pc.personID_fk=pe.personID_pk " & _
hai guys,
i have written a stored procedure which creates a table ex:
USE PUBS
GO
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = 'RC_STRPROC')
DROP PROCEDURE RC_STRPROC
GO
USE PUBS
GO
CREATE PROCEDURE RC_STRPROC
(@TBLNAME VARCHAR(35), @COLVAL1 VARCHAR(35), @COLVAL2 VARCHAR(35))
AS
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = '@TBLNAME')
DROP TABLE @TBLNAME
CREATE TABLE @TBLNAME
(@COLVAL1, @COLVAL2)
GO
it gives an syntax error at '@tblname'
can u guys tell me the problem
thanks
hiss
I am getting error when I am trying to create table on runtime
Declare @FileName varchar(100)
Declare @File varchar(100)
set @FileName='brkrte_121227102828'
SET @File = SUBSTRING(@FileName,1,CHARINDEX('_',@FileName)-1)
--=select @File
[Code] ....
Error massage:-
Msg 203, Level 16, State 2, Line 16
The name 'CREATE TABLE DataStaging.dbo.Staging_brkrte ( [COL001] VARCHAR (4000) NOT NULL, [Id] Int Identity(1,1), [LoadDate] datetime default getdate() )' is not a valid identifier.
How to resolve above error....
Hi,
I have set up a publisher using transactional replication. ( all seems ok). The initial snapshot has been generated.
The replication share on the distributor has all the generated DDL in it.
I add a subscriber. The tables are generated up to tblCountry then I get an incorrect syntax near ')' error
The Replication Monitor shows the following code as the cause. ( bold indicates incorrect sql)
Is this a bug in Replication (as this is an autogenerated sp)or have I configured something incorrectly?
The ddl for the table index is as follows ( from the replication folder)
/----
CREATE TABLE [APP].[tblCountry](
[CountryId] AS ([ISO 3166-1 NUMERIC-3]) PERSISTED NOT NULL,
[CountryCode] AS ([ISO 3166-1 ALPHA-2]) PERSISTED NOT NULL,
[CountryName] [varchar](80) COLLATE Latin1_General_CI_AS NOT NULL,
[ISO 3166-1 ALPHA-2] [char](2) COLLATE Latin1_General_CI_AS NOT NULL,
[ISO 3166-1 ALPHA-3] [char](3) COLLATE Latin1_General_CI_AS NOT NULL,
[ISO 3166-1 NUMERIC-3] [int] NOT NULL
)
GO
---/
/------ Keys ddl (.dx)
ALTER TABLE [APP].[tblCountry] ADD CONSTRAINT [PK_TBLCOUNTRY] PRIMARY KEY CLUSTERED ([CountryId])
go
ALTER TABLE [APP].[tblCountry] ADD CONSTRAINT [UQ_TBLCOUNTRY_ALPHA2] UNIQUE NONCLUSTERED ([ISO 3166-1 ALPHA-2])
go
ALTER TABLE [APP].[tblCountry] ADD CONSTRAINT [UQ_TBLCOUNTRY_ALPHA3] UNIQUE NONCLUSTERED ([ISO 3166-1 ALPHA-3])
go
ALTER TABLE [APP].[tblCountry] ADD CONSTRAINT [UQ_TBLCOUNTRY_COUNTRYNAME] UNIQUE NONCLUSTERED ([CountryName])
go
--------/
/------------
Command attempted:
create procedure "sp_MSins_APPtblCountry_msrepl_ccs"
@c1 int,@c2 varchar(80),@c3 char(2),@c4 char(3),@c5 int
as
begin
if exists ( select * from "APP"."tblCountry"
where
)
begin
update "APP"."tblCountry" set
"CountryName" = @c2
,"ISO 3166-1 ALPHA-2" = @c3
,"ISO 3166-1 ALPHA-3" = @c4
,"ISO 3166-1 NUMERIC-3" = @c5
where
end
else
begin
insert into "APP"."tblCountry"(
"CountryName"
,"ISO 3166-1 ALPHA-2"
,"ISO 3166-1 ALPHA-3"
,"ISO 3166-1 NUMERIC-3"
)
values (
@c2
,@c3
,@c4
(Transaction sequence number: 0x00000016000004F2014500000000, Command ID: 213)
------------/
Hi all,
I have SQL Server Management Studio Express (SSMS Express) and SQL Server 2005 Express (SS Express) installed in my Windows XP Pro PC that is on Microsoft Windows NT 4 LAN System. My Computer Administrator grants me the Administror Privilege to use my PC. I tried to use SQLQuery.sql (see the code below) to create a table "LabResults" and insert 20 data (values) into the table. I got Error Messages 102 and 156 when I did "Parse" or "Execute". This is my first time to apply the data type 'decimal' and the "VALUES" into the table. I do not know what is wrong with the 'decimal' and how to add the "VALUES": (1) Do I put the precision and scale of the decimal wrong? (2) Do I have to use "GO" after each "VALUES"? Please help and advise.
Thanks in advance,
Scott Chang
///////////--SQLQueryCroomLabData.sql--///////////////////////////
USE MyDatabase
GO
CREATE TABLE dbo.LabResults
(SampleID int PRIMARY KEY NOT NULL,
SampleName varchar(25) NOT NULL,
AnalyteName varchar(25) NOT NULL,
Concentration decimal(6.2) NULL)
GO
--Inserting data into a table
INSERT dbo.LabResults (SampleID, SampleName, AnalyteName, Concentration)
VALUES (1, 'MW2', 'Acetone', 1.00)
VALUES (2, 'MW2', 'Dichloroethene', 1.00)
VALUES (3, 'MW2', 'Trichloroethene', 20.00)
VALUES (4, 'MW2', 'Chloroform', 1.00)
VALUES (5, 'MW2', 'Methylene Chloride', 1.00)
VALUES (6, 'MW6S', 'Acetone', 1.00)
VALUES (7, 'MW6S', 'Dichloroethene', 1.00)
VALUES (8, 'MW6S', 'Trichloroethene', 1.00)
VALUES (9, 'MW6S', 'Chloroform', 1.00)
VALUES (10, 'MW6S', 'Methylene Chloride', 1.00
VALUES (11, 'MW7', 'Acetone', 1.00)
VALUES (12, 'MW7', 'Dichloroethene', 1.00)
VALUES (13, 'MW7', 'Trichloroethene', 1.00)
VALUES (14, 'MW7', 'Chloroform', 1.00)
VALUES (15, 'MW7', 'Methylene Chloride', 1.00
VALUES (16, 'TripBlank', 'Acetone', 1.00)
VALUES (17, 'TripBlank', 'Dichloroethene', 1.00)
VALUES (18, 'TripBlank', 'Trichloroethene', 1.00)
VALUES (19, 'TripBlank', 'Chloroform', 0.76)
VALUES (20, 'TripBlank', 'Methylene Chloride', 0.51)
GO
//////////Parse///////////
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '6.2'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'VALUES'.
////////////////Execute////////////////////
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '6.2'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'VALUES'.
I am having this error when using execute query for CTE
Help will be appriciated
Dear All,
I was trying to create a table with many columns. However, I got the following error. Have anyone seen this error before?
>>>>>
Warning: The table 'PDMS_USER' has been created but its maximum row size (9118) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
<<<<<
Thanks.
Hi
I've been looking at scripting some create tables, but want to know if the table created successfully. I've been doing the following:
DECLARE @ERRCODE INT
CREATE TABLE x
SET @ERRCODE = @@ERROR
This works ok, if there is no erroor. However if I run this again, then obviously I get the error "This object already exists" and the script stops executing.
Is there a way that I can capture the error using @@ERROR and still let the script run ?
Thanks in advance
Mickster
Hi
Working with SQL Server 2005
I am trying to create a table with the following code
create table department
(dept_id smallint unsigned not null auto_increment,
name varchar(20) not null,
constraint pk_department primary key (dept_id)
)
but keep coming up with an error. I suspect that I am trying to use mysql (which I don't want to use!) instead of sql, but can't find the changes I need to make.
Thank you in advance
CREATE PROCEDURE dbo.spCreateObBabyEpisodeArchive AS
DECLARE @TableName as varchar(400)
DECLARE @SQL as varchar(8000)
SET @TableName = 'ObBabyEpisode' + CONVERT(varchar,REPLACE (CONVERT(VARCHAR, GETDATE(), 106) , ' ', ''))
SET @SQL = 'CREATE TABLE ' + @TableName + '
(
AdmitSource INT NOT NULL DEFAULT 0,
Anaesthesia3rdINT NOT NULL DEFAULT 0,
Anaesthetist3rdINT NOT NULL DEFAULT 0,
Apgar1INT NOT NULL DEFAULT 0,
Apgar10INT NOT NULL DEFAULT 99,
Apgar5INT NOT NULL DEFAULT 0,
ApgarOtherVARCHAR(20) NOT NULL DEFAULT '' '',
AttAccoucherVARCHAR(30) NOT NULL DEFAULT '' '',
AttAccoucherRankVARCHAR(30) NOT NULL DEFAULT '' '',
AttMidwifeVARCHAR(30) NOT NULL DEFAULT '' '',
AttMidwifeRankVARCHAR(30) NOT NULL DEFAULT '' '',
AttOthersVARCHAR(30) NOT NULL DEFAULT '' '',
AttOthersRankVARCHAR(30) NOT NULL DEFAULT '' '',
AugmentationVARCHAR(30) NOT NULL DEFAULT '' '',
BabyAdmitDrINT NOT NULL DEFAULT 0,
BabyDisDateVARCHAR(12) NOT NULL DEFAULT '' '',
BabyDisDestINT NOT NULL DEFAULT 0,
BabyDisFeedINT NOT NULL DEFAULT 0,
BabyDisHospINT NOT NULL DEFAULT 0,
BabyDisStaffINT NOT NULL DEFAULT 0,
BabyDisTimeVARCHAR(7) NOT NULL DEFAULT '' '',
BabyEddVARCHAR(12) NOT NULL DEFAULT '' '',
BabyGenderVARCHAR(20) NOT NULL DEFAULT '' '',
BabyLosINT NOT NULL DEFAULT 0,
BabyNumINT NOT NULL DEFAULT 0,
BabyPostMedsVARCHAR(30) NOT NULL DEFAULT '' '',
BabyRecStatusVARCHAR(50) NOT NULL DEFAULT '' '',
BabyRegStaffINT NOT NULL DEFAULT 0,
BabyReqMandatoryFieldsVARCHAR(250) NOT NULL DEFAULT '' '',
BabyScnNicuVARCHAR(6) NOT NULL DEFAULT '' '',
BabyTreatmentVARCHAR(80) NOT NULL DEFAULT '' '',
BabyUrnoVARCHAR(20) NOT NULL DEFAULT '' '',
BabyWardINT NOT NULL DEFAULT 0,
BirthAnaesVARCHAR(30) NOT NULL DEFAULT '' '',
BirthDateVARCHAR(12) NOT NULL DEFAULT '' '',
BirthDefectVARCHAR(80) NOT NULL DEFAULT '' '',
BirthLengthDECIMAL NOT NULL DEFAULT 0,
BirthModeINT NOT NULL DEFAULT 0,
BirthPlaceINT NOT NULL DEFAULT 0,
BirthStatusVARCHAR(55) NOT NULL DEFAULT '' '',
BirthTimeVARCHAR(7) NOT NULL DEFAULT '' '',
BirthTraumaVARCHAR(30) NOT NULL DEFAULT '' '',
BirthTypeINT NOT NULL DEFAULT 0,
BirthWeightVARCHAR(10) NOT NULL DEFAULT '' '',
CaesarTypeVARCHAR(20) NOT NULL DEFAULT '' '',
CmpAccPaidDECIMAL NOT NULL DEFAULT 0,
CmpAccRcvdDECIMAL NOT NULL DEFAULT 0,
CmpCategoryINT NOT NULL DEFAULT 0,
CmpDisDateVARCHAR(12) NOT NULL DEFAULT '' '',
CmpDisFeedINT NOT NULL DEFAULT 0,
CmpFeedChangeVARCHAR(6) NOT NULL DEFAULT '' '',
CmpFeedReasonINT NOT NULL DEFAULT 0,
CmphomeConsultINT NOT NULL DEFAULT 0,
CmpHospConsultINT NOT NULL DEFAULT 0,
CmpNotHomeINT NOT NULL DEFAULT 0,
CmpOutPhoneINT NOT NULL DEFAULT 0,
CmpOutreachTotINT NOT NULL DEFAULT 0,
CmpPhoneConsultINT NOT NULL DEFAULT 0,
CmpProblemINT NOT NULL DEFAULT 0,
CmpProviderINT NOT NULL DEFAULT 0,
CmpReadmitBabyINT NOT NULL DEFAULT 0,
CmpReadmitMotherINT NOT NULL DEFAULT 0,
CmpReferBabyINT NOT NULL DEFAULT 0,
CmpReferMotherINT NOT NULL DEFAULT 0,
CmpVisitTotINT NOT NULL DEFAULT 0,
CordAnalysisTimevarchar(25) NOT NULL DEFAULT '' '',
CordBaseExcessvarchar(6) NOT NULL DEFAULT '' '',
CordBloodVARCHAR(6) NOT NULL DEFAULT '' '',
CordCompsVARCHAR(55) NOT NULL DEFAULT '' '',
CordInsertionVARCHAR(55) NOT NULL DEFAULT '' '',
CordLactateVARCHAR(6) NOT NULL DEFAULT '' '',
CordPhVARCHAR(6) NOT NULL DEFAULT '' '',
CordStemBloodVARCHAR(6) NOT NULL DEFAULT '' '',
CordVesselsINT NOT NULL DEFAULT 0,
DischWeightvarchar(10) NOT NULL DEFAULT '' '',
DisFeedReasonINT NOT NULL DEFAULT 0,
EndDate3VARCHAR(12) NOT NULL DEFAULT '' '',
EndTime3VARCHAR(6) NOT NULL DEFAULT '' '',
EpisodeIDINT NOT NULL ,
EstGestDECIMAL NOT NULL DEFAULT 0,
EstRespsINT NOT NULL DEFAULT 0,
ExclusiveBFVARCHAR(6) NOT NULL DEFAULT '' '',
FirstFeedDateVARCHAR(12) NOT NULL DEFAULT '' '',
FirstFeedModeINT,
FirstFeedTimeVARCHAR(6) NOT NULL DEFAULT '' '',
FoetMonVARCHAR(30) NOT NULL DEFAULT '' '',
ForcepTypeVARCHAR(100) NOT NULL DEFAULT '' '',
HeadCircmDECIMAL,
HearTestDateVARCHAR(12) NOT NULL DEFAULT '' '',
HearTestResultVARCHAR(20) NOT NULL DEFAULT '' '',
HepBvDateVARCHAR(12) NOT NULL DEFAULT '' '',
HepBvTimeVARCHAR(6) NOT NULL DEFAULT '' '',
HindleakDateVARCHAR(55) NOT NULL DEFAULT '' '',
HindleakTimeVARCHAR(6) NOT NULL DEFAULT '' '',
ID INT NOT NULL ,
ImmGnDateVARCHAR(12) NOT NULL DEFAULT '' '',
ImmGnTimeVARCHAR(6) NOT NULL DEFAULT '' '',
InductionDateVARCHAR(12) NOT NULL DEFAULT '' '',
InductionTimeVARCHAR(6) NOT NULL DEFAULT '' '',
InductMainINT,
InductModeVARCHAR(30) NOT NULL DEFAULT '' '',
InductOtherVARCHAR(250) NOT NULL DEFAULT '' '',
IntendedChangedVARCHAR(55) NOT NULL DEFAULT '' '',
IntendedPlaceVARCHAR(30) NOT NULL DEFAULT '' '',
IntendedSpecifyVARCHAR(55) NOT NULL DEFAULT '' '',
IntendedYnVARCHAR(6) NOT NULL DEFAULT '' '',
KonakDateVARCHAR(12) NOT NULL DEFAULT '' '',
KonakRouteVARCHAR(10) NOT NULL DEFAULT '' '',
LabAnalgesiaVARCHAR(30) NOT NULL DEFAULT '' '',
LabCompsVARCHAR(60) NOT NULL DEFAULT '' '',
LabDrugsVARCHAR(30) NOT NULL DEFAULT '' '',
LabourTime1VARCHAR(6) NOT NULL DEFAULT '' '',
LabourTime2VARCHAR(6) NOT NULL DEFAULT '' '',
LabourTime3VARCHAR(6) NOT NULL DEFAULT '' '',
LastUpdateVARCHAR(55) NOT NULL DEFAULT getdate(),
LiquorINT NOT NULL DEFAULT 0,
MembDateVARCHAR(30) NOT NULL DEFAULT '' '',
MembRuptureVARCHAR(55) NOT NULL DEFAULT '' '',
MembTimeVARCHAR(6) NOT NULL DEFAULT '' '',
NeoMorbVARCHAR(80) NOT NULL DEFAULT '' '',
NewBornScrVARCHAR(12) NOT NULL DEFAULT '' '',
ObsAccClassVARCHAR(10) NOT NULL DEFAULT '' '',
ObsAdmitDateVARCHAR(12) NOT NULL DEFAULT '' '',
ObsAdmitTimeVARCHAR(6) NOT NULL DEFAULT '' '',
OnsetDate1VARCHAR(12) NOT NULL DEFAULT '' '',
OnsetDate2VARCHAR(12) NOT NULL DEFAULT '' '',
OnsetLabVARCHAR(30) NOT NULL DEFAULT '' '',
OnsetTime1VARCHAR(6) NOT NULL DEFAULT '' '',
OnsetTime2VARCHAR(6) NOT NULL DEFAULT '' '',
OpdelAnaesthetist INT NOT NULL DEFAULT 0,
OpdelDilationDECIMAL NOT NULL DEFAULT 0,
OpdelMainINT NOT NULL DEFAULT 0,
OpdelNatureVARCHAR(40) NOT NULL DEFAULT '' '',
OpdelOtherVARCHAR(30) NOT NULL DEFAULT '' '',
Oxytocic3VARCHAR(30) NOT NULL DEFAULT '' '',
PassedMecVARCHAR(6) NOT NULL DEFAULT '' '',
PassedUrineVARCHAR(6) NOT NULL DEFAULT '' '',
PdcuBatchErrorVARCHAR(250) NOT NULL DEFAULT '' '',
PdcuBatchIDINT NOT NULL DEFAULT '' '',
PeriAnaesINT NOT NULL DEFAULT '' '',
PeriStatusINT NOT NULL DEFAULT '' '',
PeriSuturedByINT NOT NULL DEFAULT '' '',
PlacentaAbnormVARCHAR(100) NOT NULL DEFAULT '' '',
PlacentaDelModeVARCHAR(55) NOT NULL DEFAULT '' '',
PlacentaMemVARCHAR(55) NOT NULL DEFAULT '' '',
PositionVARCHAR(40) NOT NULL DEFAULT '' '',
PresentationINT NOT NULL DEFAULT '' '',
RefHospitalINT NOT NULL DEFAULT '' '',
RegistrarFlagINT NOT NULL DEFAULT '' '',
ResusVARCHAR(60) NOT NULL DEFAULT '' '',
ScalpLactateDateVARCHAR(50) NOT NULL DEFAULT '' '',
ScalpLactateTime VARCHAR(30) NOT NULL DEFAULT '' '',
ScalpLactateValue VARCHAR(30) NOT NULL DEFAULT '' '',
SkinContactVARCHAR(6) NOT NULL DEFAULT '' '',
SkinContactDateVARCHAR(12) NOT NULL DEFAULT '' '',
SkinContactReasonGT30INT NOT NULL DEFAULT '' '',
SkinContactTimeVARCHAR(6) NOT NULL DEFAULT '' '',
TotLabourTimeVARCHAR(6) NOT NULL DEFAULT '' '',
UrNoVARCHAR(20) NOT NULL,
VCordBaseExcessVARCHAR(6) NOT NULL DEFAULT '' '',
VCordLactate VARCHAR(6) NOT NULL DEFAULT '' '',
VCordPhVARCHAR(6) NOT NULL DEFAULT '' ''
)'
EXEC @SQL
GO
When I run the query, I get this error
Server: Msg 203, Level 16, State 2, Line 172
The name 'CREATE TABLE ObBabyEpisode18Jun2007
(
AdmitSource INT NOT NULL DEFAULT 0,
Anaesthesia3rdINT NOT NULL DEFAULT 0,
Anaesthetist3rdINT NOT NULL DEFAULT 0,
Apgar1INT NOT NULL DEFAULT 0,
Apgar10INT NOT NULL DEFAULT 99,
Apgar5INT NOT NULL DEFAULT 0,
ApgarOtherVARCHAR(20) NOT NULL DEFAULT ' ',
AttAccoucherVARCHAR(30) NOT NULL DEFAULT ' ',
AttAccoucherRankVARCHAR...
Line 172 Points to EXEC @SQL
I cannot understand what is the error. Any clues?
Hi,
I have connected sdf database through SQL server management studio.
I want to execute a simple query as,
CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL)
While executing the same through Query pane, it gives error as,
<>
Major Error 0x80040E14, Minor Error 26100
> CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL)
The table name is not valid. [ Token line number (if known) = 1,Token line offset (if known) = 22,Table name = user ]
<>
Any pointers?
Thanks,
Shailesh.
Hi,
I am new to SQL and i am trying to create a table from a table. below is my query but im getting an error
CREATE TABLE Production.TransactionHistoryArchive1 AS
(SELECT ProductID,SUM(Quantity) QuantitySum,SUM(LineItemTotalCost) TotalCostByID FROM Production.TransactionHistoryArchive
GROUP BY ProductID)
error:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'AS'.
I have both MSDE and SQL Server 2000 on my development PC.
Using Server Explorer - select MSDE server - right click on Tables icon - and I'm offered Create New Table.
Using Server Explorer - select SQL Server 2000 server - right click on Tables icon - and I'm NOT offered Create New Table.
Both servers are configured identically (except for whatever is keeping me from Create Table ...) Any suggestions?
I'm trying to create a table in Microsoft Server Management Studio 2012. The table has two fields which are both foreign keys.
I created the following:
create table tblRoomEquipment(
RoomID nvarchar(8),
EquipmentType nvarchar(1),
foreign key (RoomID) references tblRoom(ID),
foreign key (EquipmentType) references tblEquipment(Type)
)
Both tblRoom and tblEquipment have the red line error which when I highlight say the they both reference an invalid table!
Both tables are there and have primary keys defined as ID & Type. I have searched around and all I could find was that there maybe a permission problem.
I am new to sqlserver.
Could anybody please help me by giving me a syntax for the command in job schedular to run dts package
i enter the job name in the first screen of the wizard.
I entered the step name. type Transact SQL
database msdb
What should i enter in command text box
My dts package name is fullcube.
Thanks in advance
i have created a fact table which has unique cluster index as below,
CREATE UNIQUE CLUSTERED INDEX [FactSales_SalesID] ON [dbo].[FactSales] (salesid ASC)
WITH (DATA_COMPRESSION = PAGE)
GO
however later when i add CLUSTERED COLUMNSTORE INDEXES :
CREATE CLUSTERED COLUMNSTORE INDEX CSI_FactSales
ON dbo.FactSales WITH (DATA_COMPRESSION = COLUMNSTORE)
GO
it prompts error.
Msg 35372, Level 16, State 3, Line 167 You cannot create more than one clustered index on table 'dbo.FactSales'. Consider creating a new clustered index using 'with (drop_existing = on)' option.
Why can't one use a three part naming convention when creating a view?
example:
CREATE VIEW databasename.schemaname.anyview
AS
SELECT * FROM anytable
The following error is returned:
Msg 166, Level 15, State 1, Line 1
'CREATE/ALTER VIEW' does not allow specifying the database name as a prefix to the object name.
ALTER TRIGGER [dbo].[Trigger1]
ON [dbo].[Table1] with execute as SELF
AFTER INSERT
[code]....
I am trying to create a trigger so every time a entry is made on a table, and the Colum1 is 'entry', it starts a job. But the users running the inserts do not have permission to Start jobs so I need to make it run as a super user. Where do i put the syntax in here? I Have tried Execute as login 'superuser' before the exec statement but it errors on the principal not being valid
What is the equivalent for INCLUDE clause (in Create index syntax) in SQL Server 2000.
SQL Server 2005 will support Include clause in Create index syntax . How to attain it in SQL Server 2000
Example : I have below query executable in SQL Server 2005
CREATE INDEX Index_Name ON mytable(col1 ASC) INCLUDE (name,id);
What is the equivalent for the above query in SQL server 2000
Thanks ,
Sushma
SSIS Newbie Question:
I have a simple Control Flow setup that checks to see if a particular table exists. If the table does not exists, the table is created in an alternate path, if it does exist, the table is truncated before moving to a file import Data Flow that uses an OLE DB Destination to output the imported data.
My problem is, that I get OLE DB package errors if the table the OLE DB Destination Container references does not exist when I load the package.
How can I over come this issue? I need to be able to dynamically create the table in an earlier step, then use that table to import data into in a later step in the workflow.
Is there a switch I can use to turn off checking in the OLE DB Destination Container so that it will allow me to hook up the table creation step?
Seems like this would be a common task...
Steps:
1. Execute SQL Task to see if the required table exists
2. Use expresions to test a variable to check the results of step 1
3. If table exists, truncate the table and reload it from file in Data Flow using OLE DB Destination
4. If table does not exist, 1st create it, then follow the normal Data Flow
Can someone help me with this?
Signed: Clueless with a deadline approaching...
Hi All,
i have migrated a DTS package wherein it consists of SQL task.
this has been migrated succesfully. but when i execute the package, i am getting the error with Excute SQL task which consists of Store Procedure excution.
But the SP can executed in the client server. can any body help in this regard.
Thanks in advance,
Anand
Hi, all
I'm getting this error at runtime when my page tries to populate a datagrid. Here's the relevant code.
First, the user selects his choice from a dropdownlist, populated with a sqldatasource control on the aspx side:<asp:SqlDataSource ID="sqlDataSourceCompany" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [PayrollCompanyID], [DisplayName] FROM [rsrc_PayrollCompany] ORDER BY [DisplayName]">
</asp:SqlDataSource>
And the dropdown list's code:<asp:DropDownList ID="ddlPayrollCompany" runat="server" AutoPostBack="True" DataSourceID="sqlDataSourcePayrollCompany"
DataTextField="DisplayName" DataValueField="PayrollCompanyID">
</asp:DropDownList>
Then, I use the selectedindexchanged event to bind the data to the datagrid. Here's that code:
1 Sub BindData()
2
3 Dim ds As New DataSet
4 Dim sda As SqlClient.SqlDataAdapter
5 Dim strSQL As String
6 Dim strCon As String
7
8 strSQL = "SELECT [SocialSecurityNumber], [Prefix], [FirstName], [LastName], [HireDate], [PayrollCostPercent], " & _
9 "[Phone], [BadgeNumber], [IsSupervisor], [SupervisorID], [IsUser], [IsScout] FROM [rsrc_Personnel] " & _
10 "WHERE ([PayrollCompanyID] = @PayrollCompanyID)"
11
12 strCon = "Data Source=DATASOURCE;Initial Catalog=DATABASE;User ID=USERID;Password=PASSWORD"
13
14 sda = New SqlClient.SqlDataAdapter(strSQL, strCon)
15
16 sda.SelectCommand.Parameters.Add(New SqlClient.SqlParameter("@PayrollCompanyID", Me.ddlPayrollCompany.SelectedItem.ToString()))
17
18 sda.Fill(ds, "rsrc_Personnel")
19
20 dgPersonnel.DataSource = ds.Tables("rsrc_Personnel")
21 dgPersonnel.DataBind()
22
23 End Sub
24
I'm assuming my problem lies in line 16 of the above code. I've tried SelectedItemIndex, SelectedItemValue too and get errors for those, as well.
What am I missing?
Thanks for anyone's help!
Cappela07
Hello all,
Please help....
I have a text file which needs to be created into a table (let's call it DataFile table). For now I'm just doing the manual DTS to import the txt into SQL server to create the table, which works. But here's my problem....
I need to extract data from DataFile table, here's my query:
select * from dbo.DataFile
where DF_SC_Case_Nbr not like '0000%';
Then I need to create a new table for the extracted data, let's call it ExtractedDataFile. But I don't know how to create a new table and insert the data I selected above into the new one.
Also, can the extraction and the creation of new table be done in just one stored procedure? or is there any other way of doing all this (including the importation of the text file)?
Any help would be highly appreciated.
Thanks in advance.