hi,i want t0 knom d syntax for a super key with an example

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

---

What is the default order of an order by clause?

0 Answers  

---

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

---

What are user defined functions in ms sql server?

0 Answers  

---

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

What are policy management terms?

0 Answers  

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Define full outer join in sql server joins?

0 Answers  

---