SQL Server table reset seed | RESEED | reseed table data

Some time table identity value comes wrong sake of we delete manual entries, we added wrong data in edit mode or it takes next value of identity or some time automatically comes. So in this case many developer are delete data or re-design to table structure (schema). No need to do this you just clear … Read more

Where clause on json data in SQL Server | JSON_VALUE

A very rare example of this. But I find out suppose you have a list of key values, or you want to search value corresponding of the key, you will pass key and get the value of that from JSON list. Using the below example you can easy to achieve this. I have this json … Read more

How to use Entity Framework Migrations | Code First approach | .net core MVC code first

Summary: As you know in the Entity framework we have many ways to connect with the database from our application. We are using their Model first approach, Database first approach, and Code First approach.All approaches have different ways to use or Different requirement to use. The main thing is why we use this or which … Read more

Time in India vs Saudi Arabia | IST vs KSA

We will show you list of time IST vs SKA. Saudi Arabia time is 2:30 hrs behind India. 0:00 AM (0:00) IST == 9:30 PM (21:30) previous day KSA0:30 AM (0:30) IST == 10:00 PM (22:00) previous day KSA1:00 AM (1:00) IST == 10:30 PM (22:30) previous day KSA1:30 AM (1:30) IST == 11:00 PM (23:00) previous day KSA2:00 AM (2:00) IST == 11:30 PM (23:30) previous day KSA2:30 AM … Read more

Using SQL query removes all tables data with schema | stored procedures | views | indexes

Rather then delete one by one remove all data and schema from database using single SQL query. Mostly on shared hosting where we are not able to check SQL server database and table views because of SQL server version, sometimes our SQL version is low or some time they version is high. So we are … Read more

How to make money online | online earning | start an online business

You know what the internet is all about today, everyone is thinking about starting their own online business. In 2020, Krona did a great job, now everyone wanting their business should be online, however. Using these way you can start your own business. 1. Using Youtube2. Facebook Instant article3. Your own web portal apply google … Read more

Laravel Website and cms, content management system in php laravel | realtime editing.

Laravel Website and cms, content management system in PHP laravel | real-time editing, you can easy to manage your content. easy and smart cms.Single page or multiple back pages you can manage there. Live Demo:http://laracms.soninfosys.com/Loginadmin@gmail.comadmin Download Code: https://github.com/code-infosys/Lara.SinglePageCMS For Commercial use Purchase software from below link. Click here for purchase