Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I make an Insert Query in Enterprise Manager
Message
From
23/04/2002 10:02:15
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00647527
Message ID:
00648112
Views:
21
Hi Sergey,

That did it!

Thanks
Jim

>In the EM right click on a table/view and select one of the option under the Open Table. It'll open the Query Designer. Click on Show Sql button on the toolbar to see the default query. From here you can change the query type as described in the BOL.
>
>>Hello group
>>
>>I'm new at this
>>BOL says:
>>
>>How to create an Insert Values query (Enterprise Manager)
>>To create an Insert Values query
>>
>>Add the table you want to update to the Diagram pane.
>>Convert the default query to an Insert Values query by right-clicking in the Diagram or SQL pane, choosing Change Type, and then choosing Insert Values.
>>
>>
>>I took this to mean open a new view and right click in the diagram pane. I did not find the default query prompt.
>>
>>What am I doing wrong.
>>
>>Thanks
>>Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform