need brief answers

what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default

what are pseudo tables - Never heard of them, you may mean Derived Tables (A table created in a query that lives only during that query), or Views (a sql statement describing a virtual table)

how queries run by MSDE - You have to use a tool, like Query Analyzer or a client application to send queies to the MSDE engine

how stored procedures run in backend by MSDE - Same as above

how triggers run by MSDE - Triggers are run automatically by the database engine when the proper event happens to a table with a trigger on it.

where triggers and stored proc stored in MSDE and in which form - They are stored in system tables, you access them to create and edit them through Enterprise Manager or writing a DDL query in Query Analyzer

where logs are being maintained of transactions/DML statement by default - The log file(s) are where ever you tell the database to put them when you create a database. By default I think they are in the <SQl Server install location>\Data folder.

|||I sometimes use the term "pseudo table" to describe the INSERTED and DELETED logical tables that are available in triggers. I am not sure if that is what applies here or not.|||ah, good point. I have never heard that term though, always heard them referred to as virtual tables.

Need answer to SQL question

I would really appreciate it if someone could give me the answers or direct
me to a place that would have the answers to the following 5 questions.

1. I need an example of SQL select statement. (table tblSource, fields A,B,C
where C<100).. "is this an example that I have in ( )?

2. I need to list 3 table joins or is "inner, outer, left" etc actual table
joins? what are the others for my own knowledge.

3. Can you join a table to itself? (how? Alias.)

4. What is the diff, between distince and distinct row?

5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
answer?

I am very sorry for my stupidy but I am trying to learn and my boss for one
reason or another gave me a ton of questions I cant answer.

Someone please help!"Troy" <corptkm@.yahoo.com> wrote in message news:<ufCXa.3722$Jk5.3134633@.feed2.centurytel.net>...
> I would really appreciate it if someone could give me the answers or direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields A,B,C
> where C<100).. "is this an example that I have in ( )?

select a,b,c from table where c<100

> 2. I need to list 3 table joins or is "inner, outer, left" etc actual table
> joins? what are the others for my own knowledge.

inner, full outer, left outer, right outer, cross

> 3. Can you join a table to itself? (how? Alias.)

yes. yes.

> 4. What is the diff, between distince and distinct row?

distinct works on a column

> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?

can be - or an inner join. or a left join.

> I am very sorry for my stupidy but I am trying to learn and my boss for one
> reason or another gave me a ton of questions I cant answer.

slap him. or tell him he can live with you rather than paying someone
else a bucket of money to answer his stupid questions...

> Someone please help!

hope we have - expect someone will do it better than me too... :P|||"Troy" <corptkm@.yahoo.com> wrote in message news:<ufCXa.3722$Jk5.3134633@.feed2.centurytel.net>...
> I would really appreciate it if someone could give me the answers or direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields A,B,C
> where C<100).. "is this an example that I have in ( )?
> 2. I need to list 3 table joins or is "inner, outer, left" etc actual table
> joins? what are the others for my own knowledge.
> 3. Can you join a table to itself? (how? Alias.)
> 4. What is the diff, between distince and distinct row?
> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?
> I am very sorry for my stupidy but I am trying to learn and my boss for one
> reason or another gave me a ton of questions I cant answer.
> Someone please help!

At the risk of appearing cynical, your questions look very like an
academic work assignment, and not much like a series of questions from
your "boss".

I suggest you search Google for "sql tutorial" or something similar,
and you should be able to find some useful discussions of basic SELECT
syntax etc. Or any SQL book will cover the same material. None of your
questions are difficult, so it shouldn't be too much effort to work
them out.

Simon|||Hey, you're not trying to have us do your school homework for you, do you?
Those questions look like a school assignment to me..

;P

Bas

"Troy" <corptkm@.yahoo.com> wrote in message
news:ufCXa.3722$Jk5.3134633@.feed2.centurytel.net.. .
> I would really appreciate it if someone could give me the answers or
direct
> me to a place that would have the answers to the following 5 questions.
> 1. I need an example of SQL select statement. (table tblSource, fields
A,B,C
> where C<100).. "is this an example that I have in ( )?
> 2. I need to list 3 table joins or is "inner, outer, left" etc actual
table
> joins? what are the others for my own knowledge.
> 3. Can you join a table to itself? (how? Alias.)
> 4. What is the diff, between distince and distinct row?
> 5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
> answer?
> I am very sorry for my stupidy but I am trying to learn and my boss for
one
> reason or another gave me a ton of questions I cant answer.
> Someone please help!