Click here to Skip to main content
15,613,716 members
Home / Discussions / Database
   

Database

 
GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
Mycroft Holmes22-Jun-15 14:13
professionalMycroft Holmes22-Jun-15 14:13 
QuestionMaximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
indian14319-Jun-15 15:46
indian14319-Jun-15 15:46 
AnswerRe: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
Richard Deeming22-Jun-15 1:41
mveRichard Deeming22-Jun-15 1:41 
GeneralRe: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
indian14322-Jun-15 7:00
indian14322-Jun-15 7:00 
QuestionHow to add primary key in existing table? Pin
apple blue16-Jun-15 16:53
apple blue16-Jun-15 16:53 
AnswerRe: How to add primary key in existing table? Pin
Peter Leow16-Jun-15 17:07
professionalPeter Leow16-Jun-15 17:07 
GeneralRe: How to add primary key in existing table? Pin
apple blue16-Jun-15 18:37
apple blue16-Jun-15 18:37 
AnswerRe: How to add primary key in existing table? Pin
Dhamodharan A18-Jun-15 21:33
Dhamodharan A18-Jun-15 21:33 
Hi,

for creating primary key u must need to maintain that columns as not null,

so first execute this query to make it as not null

SQL
<pre lang="sql">  ALTER TABLE D_D_ext
  ALTER COLUMN Categories NVARCHAR(1) NOT NULL ;
  ALTER TABLE D_D_ext
  ALTER COLUMN Sequence NVARCHAR(1) NOT NULL ;


Then execute this query for creating Primary key

SQL
ALTER TABLE D_D_ext
  ADD CONSTRAINT pk_D_D_ext_Categories_Sequence PRIMARY KEY (Categories, Sequence)



Thanks
dhamu
GeneralRe: How to add primary key in existing table? Pin
apple blue29-Jun-15 14:48
apple blue29-Jun-15 14:48 
AnswerRe: How to add primary key in existing table? Pin
Daniel Miller23-Oct-15 15:32
professionalDaniel Miller23-Oct-15 15:32 
Questioninterface a c# application and SCADA system using SQL server Pin
zineb errih16-Jun-15 7:36
zineb errih16-Jun-15 7:36 
AnswerRe: interface a c# application and SCADA system using SQL server Pin
Hernan Osorio6-Oct-17 6:30
Hernan Osorio6-Oct-17 6:30 
QuestionQuery Response Time - SQL Server Replication Pin
JammoD8714-Jun-15 1:48
JammoD8714-Jun-15 1:48 
AnswerRe: Query Response Time - SQL Server Replication Pin
Mycroft Holmes14-Jun-15 13:03
professionalMycroft Holmes14-Jun-15 13:03 
AnswerRe: Query Response Time - SQL Server Replication Pin
GuyThiebaut14-Jun-15 21:25
professionalGuyThiebaut14-Jun-15 21:25 
AnswerRe: Query Response Time - SQL Server Replication Pin
Tim Carmichael15-Jun-15 9:06
Tim Carmichael15-Jun-15 9:06 
AnswerRe: Query Response Time - SQL Server Replication Pin
JammoD8716-Jun-15 1:16
JammoD8716-Jun-15 1:16 
QuestionDatabase grouping of rows using values into columns Pin
indian14310-Jun-15 8:48
indian14310-Jun-15 8:48 
AnswerRe: Database grouping of rows using values into columns Pin
Richard Deeming10-Jun-15 9:05
mveRichard Deeming10-Jun-15 9:05 
AnswerRe: Database grouping of rows using values into columns Pin
Eddy Vluggen10-Jun-15 9:29
professionalEddy Vluggen10-Jun-15 9:29 
QuestionCompare Database Projects Pin
Ashfaque Hussain7-Jun-15 19:47
Ashfaque Hussain7-Jun-15 19:47 
AnswerRe: Compare Database Projects Pin
Mycroft Holmes7-Jun-15 19:54
professionalMycroft Holmes7-Jun-15 19:54 
GeneralRe: Compare Database Projects Pin
Ashfaque Hussain7-Jun-15 20:06
Ashfaque Hussain7-Jun-15 20:06 
QuestionDB2 Please Help Here Pin
ganeshbdas7-Jun-15 2:23
ganeshbdas7-Jun-15 2:23 
AnswerRe: DB2 Please Help Here Pin
CHill608-Jun-15 22:25
mveCHill608-Jun-15 22:25 

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.