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

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What is subquery explain with example?

0 Answers  

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

What is indexing?

0 Answers   AOL,

---

How can I create a report based on a query? : sql server management studio

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---