How to create new databases with "create database" statements?

0 Answers  

---

Can two tables have the same primary key?

0 Answers  

---

Explain insert into select statement?

0 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Explain the usage of floor function in sql server.

0 Answers  

---

What are the restrictions that views have to follow?

0 Answers  

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What are sparse columns?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

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  

---