Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sql2000
Its Possible, run the below code and have a look...
begin transaction
create table test (col1 int, col2 int)
insert into test values (1, 1)
insert into test values (1, 2)
insert into test values (1, 3)
insert into test values (2, 1)
delete from test where col1 = 2
alter table test
alter column col2 int not null
alter table test
add
constraint [pk_col2] primary key nonclustered(col2) on
[primary]
rollback transaction
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is cursor in ms sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are different types of constraints?
Explain an incremental backup?
What are the differences between DDL, DML and DCL in SQL?
What is service broker? : sql server database administration
Explain the dbcc pintable command when would you use it?
What are different types of database indexes?
How to create a user name in a database?
How to create a user to access a database in ms sql server using "create user" statements?
What is mean by dml?
What are the steps to follow to configure SQL*Net?
Indexes are updated automatically is the full-text index also updated automatically?
