What is spid in sql server profiler?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What are functions

3 Answers  

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What's the difference between a primary key and a unique key?

4 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---