Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by database1

  1. database1

    How do you refer a field which is a part of a composite primary key

    The sequence follows like this:<br>1. create table integer(a int,b int,primary key(a,b))<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&gt;&nbsp;&nbsp;a table is created with both fields as composite primary<br>2. create table referinteger(a int references...
  2. database1

    refering a composite primary fields

    can u refer a composite primary field?
  3. database1

    drag and drop

    how can we use drag and drop event in javascript to transfer images.
  4. database1

    Query presentation in 2-D format

    &nbsp;&nbsp;&nbsp;The table contains Department,Grade,status. <br>How to obtaine the below output<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dept/Grade&nbsp;&nbsp;&nbsp;&nbsp;G1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G3...
  5. database1

    can i select duplicate rows in a table -how?

    how can i select duplicate records in a table
  6. database1

    How to find duplicate records in MS-SQL

    how can i select duplicate rows in a table
  7. database1

    hierarchy level

    In ORACLE u have start_with/connect_by function to find the level.<br>can u suggest an equivalent in MS-SQL Server
  8. database1

    returning rows

    which is the function that will answer queries such as <br>-select first five rows in a table<br>-select last five rows<br>-even rows <br>-odd rows

Part and Inventory Search

Back
Top