Sql Server
Generate script in SQL server With Data
To generate script in SQL server with data you need to follow the following step Open SQL server management studio expand database Right-click in the…
Read more
SQL
Blazor read Json from Database
Create table create table jsontable ( id int identity(1,1), fname nvarchar(100), Lname nvarchar(100), age int ) create procedure CREATE proc…
Read more
Sql Server
Sql Server Dynamic Query
Introduction Dynamic Query helps you to run SQL statements dynamically at runtime. It allows you to create more flexible SQL statements because the f…
Read more
Sql Server
How to start SQL Server Agent when Agent XPs show disabled
Problem : SQL Server Agent started but Agent XPs Disabled. What is the issue and how to fix this? Solution : I started to search for services…
Read more
Sql Server
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset.
Sometimes this error makes us very sad. But this is a very simple error which is easily recovered. this is happening due to loss of drive or any oth…
Read more
SQL
find table without indexing in SQL Server
The index in the table is very useful for data to accelerate. The index in the table help to get result fast. this is also important to query tuning…
Read more
SQL
Allow SQL to connect in Local AND Remote access
"error in connection with SQL server remotely" We are working in the development area and we are going to implement it in other as well …
Read more
SQL
Alter table in SQL
Alter table means you are going to change the table structure to be careful when you going to change the table structure it may harm your existing d…
Read more
SQL
Sql Database Backup Query
To backup database using SQL query, you can use the following query, but this is for manual keep and using from the query windows. if you want …
Read more
SQL
Setup SQL Job for backup database
Data is a very important part of every office, every human being and. Data are the one kind of information, every software, as well as a web applica…
Read more
SQL
Enable Sql Server Authentication Mode And User Login
Error :Login failed for user sa. (Microsoft SQL Server, Error: 18456) While installing the SQL server where you will find the two installation mod…
Read more
It's Edu Point is a blog that is all about tutorials and news for Microsoft office, dot net, Blazor Technology and other Programming and Information Solution.
Social Plugin