Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?
- 3 Answers
- 8734 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / uma lakshman
Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How do you size a resultset?
What is dml command?
How do indexes help, types?
Call by value and call by reference in procedure and function, with NOCOPY.
What is inline variable assignment?
Explain powershell included in sql server 2008?
What happens if you are trying to access a schema not owned by you?
What is the maximum rows in sql server table?
What is master database? : SQL Server Architecture
What do you understand by physical_only option in dbcc checkdb?
Explain system views?
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 is the difference between a stored procedure and a user defined function?
How do you create a data source?
Define Joins?
