please bar with my english
i having a database called tblhallreservation in which
res_date is date field
has to select all the fields in table deponding on month
either has to display all details for the month jan or feb
and so on

create table with fields ID, reserved_by,res_date
res_date is datefield like 2010-03-09 00:00:00.000 from
2005 to 2006 any date assume
based on res_date need to slect table and display
based on month (full jan details in database irrespective
of date and year

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.

372

How to restore performance issues and how to check?

861

If user is owning any SQL Objects, can we drop that user

863

What is data modeling and Reterminal integrity?

682

tell me the disaster recovery plan

1302

How do you Implement SSIS Packages in your Project?

848

how do you determine the Load performance of any query in
sql server {example how do u determine performance of a
select stmnt which returns Dynamically many no of records
... some times 100,1000,10000 etc., }

1069

how to do partition in sqlserver

1324

Does any body please help me what question's have asked for
SSRS in the interview?

899

plss anybody specify tha constrian management system in dbms

836

how to use DTS package in 2000,2005,2008 in sql server

797

Any one plz send me SQL Server Developer/DBA resume for 4
years experience

1512

How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?