Answer Posted / Tanveer Ahmad
To change the name of a database user in MS SQL Server, you can use the ALTER USER command followed by the new username and existing username.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
List the ways in which dynamic sql can be executed?
How efficient you are in oracle and SQL server?
What are the properties of the transaction?
What is in place upgrade in sql server?
What kind of problems occurs if we do not implement proper locking strategy?
What is a view in sql?
List out the different types of locks available in sql server?
What is standby servers? Explain types of standby servers.
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is sql or structured query language?
Is it possible to have clustered index on separate drive from original table location?
Can sql servers link to other servers like oracle?
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
How do I find the sql server version?