RSS

Blog posts tagged with 'sql'

Time-saving nopCommerce SQL query snippets you wish you knew earlier (Series) - Part 2

Written by Lavish Kumar

written by Lavish Kumar

In this article, you will learn about some more time-saving nopCommerce SQL query snippets you wish you knew earlier.
I hope you got some good usage out of my 1st installment of "Time-saving nopCommerce SQL query snippets you wish you knew earlier" series. In case you missed it, you can find the "Part -1"  of this series HERE.
3 Time-saving nopCommerce SQL query snippets you wish you knew earlier

Written by Lavish Kumar

written by Lavish Kumar

nopCommerce is driven by Microsoft SQL database and every single scrap of information is stored in that SQL database. Information like products, orders, customers, plugins, blog posts, comments, product reviews, pages etc; everything is stored in that SQL database.

Sometimes you may need a quick fix for a specific problem or need to change some information (or data) across the board in nopCommerce. When you are dealing with a ton of information (or data), it is not feasible to go through each and every record because it can be a very tedious process. By running a few SQL queries against your nopCommerce database, you can easily make necessary changes without any kind of manual effort.

In this article, we will go over 3 time-saving nopCommerce SQL query snippets.
Generating MS SQL database script with data using SQL Server Management Studio 2008

Written by Lavish Kumar

written by Lavish Kumar

A step by step tutorial for generating MS SQL database script along with data using SQL Server Management Studio 2008

pic
Changing the default value of SELECT or EDIT top rows in SQL Server Management Studio 2008

Written by Lavish Kumar

written by Lavish Kumar

A simple trick to change the default value of SELECT or EDIT top rows in SQL Server Management Studio 2008.