Answer Posted / Vineet Kumar Garg
Views are used in SQL Server as virtual tables that do not store data themselves, but are simply SELECT statements that can be queried. They are useful for security (hiding sensitive data), simplifying complex queries, and enforcing data integrity rules.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I start sql server 2017?
Why use identity in sql server?
Can one drop a column from a table?
do you know how to configure db2 side of the application? : Sql server database administration
What is temporary table in sql server? Why we use temp table?
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 sql server query analyzer?
Where can you add custom error messages to sql server?
Does view occupy space?
Why should you use or avoid select * statements?
How to remove duplicate rows from table except one?
What is the difference between upgrade and migration in sql server?
What is in place upgrade in sql server?
How efficient you are in oracle and SQL server?
What kind of problems occurs if we do not implement proper locking strategy?