With this application sample we can create a new user, show all the user, modify user data & also can able to delete the user through API build with Express from frontend using AngularJS.
- MSSql – SQL database
- Express – NodeJS Framework
Read more “Learn About MEAN Stack”
In this post we are going to Insert data using an UDF. We all know that User-defined functions (UDF) cannot be used to perform actions that modify the database state.
Error Occur while Inserting using UDF:
Invalid use of the side-affecting operator ‘INSERT’ within a function.
Read more “Modify Database State Using User-defined Function”
In this post we will create a new user in SQL Server Management Studio (SSMS) & allow access to that user to perform specific operation.
Read more “SQL Server User Access Permission to Particular Table in Database”
- Download Country-State-City-CSV 387 KB
- Download Country-State-City-SQL 550 KB
Get a list of all countries, state, city. List by country and then by state and then all cities in SQL Server database and CSV file format.