© 2022 Hashnode
#sql-server
In this post, I am going to show you how to backup and restore the database in SQL Server. I am going to use the developer edition and express edition as an example. If you are using Enterprise edition then your experience and the instruct…
Hi there! Let us see how to create a Web API in .NET 6.0 with JWT Authentication and ASP.NET Core Identity. Implementing authentication in any app is rarely an easy task, but don't worry , we will get…
Error: Log reader agent has failed with an error Login failed for user 'sql-user-account'. Solution: Right click on the publication name and open properties window. Go to Agent Security page and select Security Settings of log reader ag…
Error Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188 This database is not enabled for publication. I have used the below script to enable the database for replication option publish. use master; exec sp_replica…
Recently I had a requirement, wherein I had to import the data from one of the internal applications to the SQL Server for further processing. We had REST-API open at a particular endpoint so any other service can consume the API and fetch …
Hola amigos de la #nerdytud Hoy quiero compartirles un ejemplo para poder modificar un ID existente en una tabla de SQL Server para que su funcionalidad sea autonumérico store procedure ALTER TABLE du…
Install SQL Server 2019 Download the installer Go to https://www.microsoft.com/en-us/sql-server/sql-server-downloads Choose Download now under SQL Server on-premises This will download an executable named SQL2019-SSEI-Eval. Install Choose B…
In our team we share a development SQL Server database for each of our services. It works well, in general. It frees developers from having to keep a SQL server running locally. In spite of that, every time I need to make changes to the cod…
Stored Procedure is a block of code given a name which is stored in the database. This block of code can include: SQL Queries DML, DCL, DDL, and TCL commands. Collection Types Loop & IF ELSE statements Variables Exception Handling Cu…
-Introduction -A great builder Syntax -Conclusion Introduction Creating my first webpage was easy for me because I already no the foundation, We've been having lecture about the structure of an HTML document, tags etc. Let us make use of …
