Answer Posted / Chitrasain
To change a login name in MS SQL Server, you can use the 'sp_renamedlogin' stored procedure. Here is an example:nn```sqlnEXEC sp_renamedlogin '<old_login_name>', '<new_login_name>';n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 wait types?
How to rebuild the master database?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How efficient you are in oracle and SQL server?
Can one drop a column from a table?
How to convert numeric expression data types using the cast() function?
What are the kinds of subquery?
What is temporary table in sql server? Why we use temp table?
Can sql servers link to other servers like oracle?
How to remove duplicate rows from table except one?
Explain system functions or built-in functions? What are different types of system functions?
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 are the different subsets of sql?
Can you index views?
