What command is used to create a database in the sql server and how?

0 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

What is bcp? When does it used?

0 Answers  

---

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

Can you use order by when defining a view?

0 Answers  

---