Post reply

can anyone give me name of the software which creates views automatically with wizard

  • June 11, 2013 at 1:27 am

    #294455

    I had tried to create views for sql server 2008 with tocows software ,but it does not give any valuable results.

  • June 11, 2013 at 3:12 am

    #1622770

    You could create a new view from SSMS. Just right click "views" in Object Explorer and choose "new view". This will open up the design view (which act as some kind of wizard).

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 11, 2013 at 3:36 am

    #1622785

    mca.deepak3335 (6/11/2013)

    hi on which option should I click in object explorer like databases ,tempdatabase.

    - Start SQL Server Management Studio

    - connect to the instance where you want to create a view

    - expand "databases" in Object Explorer

    - expand the database in which you want to create a view

    - right click "Views"

    - choose "New view..."

    - select all the tables/views/functions,etc. you want to use in the view and click [add]

    - select all the required fields and give them Alias names if needed

    - define filters, sort order, etc

    give the defined view a name when saving all changes.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply