Answer / swapna

Bit datatype is used to store boolean information like 1 or
0 (true or false). Untill SQL Server 6.5 bit datatype could
hold either a 1 or 0 and there was no support for NULL. But
from SQL Server 7.0 onwards, bit datatype can represent a
third state, which is Null.

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

What is the difference between a function and a trigger?

0 Answers  

---

What is a partitioned view?

0 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,

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---