Click here to Skip to main content
14,664,322 members
Home » Discussions » Database
   

Database

 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Mycroft Holmes20-Jul-11 20:51
professionalMycroft Holmes20-Jul-11 20:51 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy20-Jul-11 21:25
MemberBlue_Boy20-Jul-11 21:25 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Shameel21-Jul-11 2:29
professionalShameel21-Jul-11 2:29 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy21-Jul-11 2:44
MemberBlue_Boy21-Jul-11 2:44 
AnswerRe: What is Buffer Pool in SqlServer? Pin
PIEBALDconsult21-Jul-11 2:45
professionalPIEBALDconsult21-Jul-11 2:45 
QuestionSSRS 2005 Sub report issue (newbie) Pin
Paul E Davies19-Jul-11 1:07
MemberPaul E Davies19-Jul-11 1:07 
AnswerRe: SSRS 2005 Sub report issue (newbie) Pin
Paul E Davies21-Jul-11 0:27
MemberPaul E Davies21-Jul-11 0:27 
QuestionSQL Syntax Issue Pin
Frank Lepkowski18-Jul-11 3:04
MemberFrank Lepkowski18-Jul-11 3:04 
Guru's,

I have the following SQL query and it gives me back some syntactical errors and I am not familiar enough with Sql Server to understand exactly what it is I am doing wrong. Thanks in advance for an information!

ALTER TABLE BatchData
DROP CONSTRAINT PK_BatchData
ALTER COLUMN StartTime VARCHAR(50) NOT NULL
ADD PRIMARY KEY (BatchID,StartTime)

Gives error:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'COLUMN'.
AnswerRe: SQL Syntax Issue Pin
Tim Carmichael18-Jul-11 3:13
MemberTim Carmichael18-Jul-11 3:13 
AnswerRe: SQL Syntax Issue Pin
AnnieMacD18-Jul-11 3:38
MemberAnnieMacD18-Jul-11 3:38 
QuestionDynamic Query Question Pin
Kevin Marois14-Jul-11 19:01
professionalKevin Marois14-Jul-11 19:01 
AnswerRe: Dynamic Query Question Pin
Blue_Boy14-Jul-11 20:54
MemberBlue_Boy14-Jul-11 20:54 
GeneralRe: Dynamic Query Question Pin
Kevin Marois15-Jul-11 5:34
professionalKevin Marois15-Jul-11 5:34 
GeneralRe: Dynamic Query Question Pin
smcnulty200015-Jul-11 22:31
Membersmcnulty200015-Jul-11 22:31 
AnswerRe: Dynamic Query Question Pin
smcnulty200014-Jul-11 21:53
Membersmcnulty200014-Jul-11 21:53 
AnswerRe: Dynamic Query Question Pin
dasblinkenlight15-Jul-11 17:00
Memberdasblinkenlight15-Jul-11 17:00 
AnswerRe: Dynamic Query Question Pin
PIEBALDconsult16-Jul-11 4:27
professionalPIEBALDconsult16-Jul-11 4:27 
JokeRe: Dynamic Query Question Pin
Mycroft Holmes16-Jul-11 13:06
professionalMycroft Holmes16-Jul-11 13:06 
GeneralRe: Dynamic Query Question Pin
S Douglas11-Aug-11 9:48
professionalS Douglas11-Aug-11 9:48 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult11-Aug-11 14:49
professionalPIEBALDconsult11-Aug-11 14:49 
GeneralRe: Dynamic Query Question Pin
S Douglas12-Aug-11 4:48
professionalS Douglas12-Aug-11 4:48 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult12-Aug-11 17:57
professionalPIEBALDconsult12-Aug-11 17:57 
GeneralRe: Dynamic Query Question Pin
S Douglas13-Aug-11 8:20
professionalS Douglas13-Aug-11 8:20 
GeneralRe: Dynamic Query Question Pin
PIEBALDconsult13-Aug-11 9:29
professionalPIEBALDconsult13-Aug-11 9:29 
GeneralRe: Dynamic Query Question Pin
S Douglas13-Aug-11 22:30
professionalS Douglas13-Aug-11 22:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.