Answer / guru

Union gives the result in two records

We have to use cross join like below



select * from table1,table2

Answer / vivek

select col1,col2 from table1 union table2

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

State a few properties of relational databases?

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

What is query cost in sql server?

0 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What is a periodical index?

0 Answers  

---