User Profile

Collapse

Profile Sidebar

Collapse
smartaju420
smartaju420
Last Activity: Mar 15 '08, 10:31 AM
Joined: Mar 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • smartaju420
    started a topic Auto Primary Keys in View
    in SQL Server

    Auto Primary Keys in View

    Hello Friends,

    I've a table with no primary key. I want to create a View based on that table but I want a auto increamenting primary key in this View.

    Does anybody know how to do this?

    Plz help me..

    Thanks in advance...
    See more | Go to post
    • smartaju420
      started a topic Distinct values
      in SQL Server

      Distinct values

      Hello Friends,

      I have two tables like following

      Table Name: Company
      Company_Entry_I D Company
      ---------------------------- -------------
      <CPY0000001> <Fusion>
      <CPY0000002> <MTN>
      <CPY0000003> <XPC>

      Table Name: Support_Groups
      Support_Organiz ation Support_Group Company
      -------------------------------...
      See more | Go to post
      No activity results to display
      Show More
      Working...