Answer Posted / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Can we store videos inside the sql server table?

980

---

List some of the rules that apply to creating and using a ‘view’

888

---

Explain the difference between primary keys and foreign keys?

1025

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

953

---

How to edit table in sql server 2017?

927

---

Explain the difference between cross join and full outer join?

981

---

Where is my database stored on the hard disk in ms sql server?

1061

---

What is a recursive stored procedure in sql server?

1175

---

what are different types of backups available in sql server? : Sql server database administration

938

---

how many bits ip address consist of? : Sql server database administration

900

---

How to list all field names in the result set using mssql_field_name()?

914

---

Who is the owner of a schema in ms sql server?

1079

---

Can you name a few encryption mechanisms in sql server?

942

---

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

2236

---

What are trace flags and mention a few common trace flags used with sql server?

1087

---