Answer Posted / sarika jayadave
USE <DATABASE NAME>
GO
ALTER TABLE [SERVER NAME].[TABLE NAME]
ADD CONSTRAINT [PRIMARY KEY NAME]
PRIMARY KEY CLUSTERED
(
[ORDER BY FILED NAME] ASC
)
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain system scalar functions?
What is surrogate key? : sql server analysis services, ssas
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the five major components of a dbms?
what is the system function to get current user's user id? : Sql server database administration
What are the lambda triggers?
What is query optimizer in sql server?
Explain primary key and foreign key constraints?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What do you understand by triggers and mention the different types of it?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
How to execute stored procedure and set temp table in sql server?
What are character string data types in ms sql server?
What is data mart? : sql server analysis services, ssas
How to make a column nullable?