Click here to Skip to main content
15,922,155 members
Home / Discussions / Database
   

Database

 
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 
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 
You can't define a primary key on a nullable column, so first you will need to ensure there are no null values in the Categories column and in the Sequence column. Then you can alter the table so these columns are not null:
SQL
ALTER TABLE [Application] ALTER COLUMN Categories NVARCHAR(1) NOT NULL
ALTER TABLE [Application] ALTER COLUMN Sequence NVARCHAR(1) NOT NULL

Then you can create your primary key:
SQL
ALTER TABLE [Application] ADD CONSTRAINT PK_Application PRIMARY KEY (Categories, Sequence)

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 
AnswerRe: DB2 Please Help Here Pin
CHill6017-Jun-15 1:50
mveCHill6017-Jun-15 1:50 
QuestionSeparating names from a single column to 2 columns Pin
jkirkerx6-Jun-15 7:59
professionaljkirkerx6-Jun-15 7:59 

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.