9 Kicks

Specify a Condition while Editing TOP Rows using SSMS(SQL Server 2008)(sqlservercurry.com)

submitted by samsertsamsert(2159) 2 years, 7 months ago

I had recently posted about Using SSMS to change the Edit TOP Rows option . A user Greg commented asking me if it was possible to specify a condition while Editing the TOP Rows. Here's how to specify a condition.

2 comments |category: |Views: 125

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
misrumisru(0) - codebettercodebetter(0) - rogringerrogringer(0) - aokocaxaokocax(55)
More who kicked this story...
Comments:

posted by lysplysp(5) 2 years, 7 months ago 0

You do this the same way you have done in previous sql management studio versions.

Creating a view is a very bad solution as it alters the database to solve an editor issue.

Here is the correct solution:
* Click edit top x rows. Click the "view sql pane" button (the letters SQL in a white box) from the query designer toolbar that appears in edit mode.

* Change the sql as needed.

* Click the red exclaimation mark to re-query the dataset.

* Edit as needed.

* You can also click the 'view sql pane' a 2nd time to hide it and still keep the changed query. You can also hit the execute icon as many times as needed to refresh the data.

Reply

posted by lysplysp(5) 2 years, 7 months ago 0

You do this the same way you have done in previous sql management studio versions.

Creating a view is a very bad solution as it alters the database to solve an editor issue.

Here is the correct solution:
* Click edit top x rows. Click the "view sql pane" button (the letters SQL in a white box) from the query designer toolbar that appears in edit mode.

* Change the sql as needed.

* Click the red exclaimation mark to re-query the dataset.

* Edit as needed.

* You can also click the 'view sql pane' a 2nd time to hide it and still keep the changed query. You can also hit the execute icon as many times as needed to refresh the data.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?