Microsoft – SQL Operations Studio

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. You can download SQL Operations Studio here: Windows https://go.microsoft.com/fwlink/?linkid=862648 macOS https://go.microsoft.com/fwlink/?linkid=862647 Linux https://go.microsoft.com/fwlink/?linkid=862646 Open source project is available in Github. You can contribute from  https://github.com/Microsoft/sqlopsstudio

How to Use the SQL Helper Class to Create Web APIs

The SQL Helper class is used in the Data Access Layer, which interacts with a database with the help of connection strings provided. It contains several methods, as shown below. And it improves the performance for the Business Layer and Data Access Layer.  ExecuteNonQuery   ExecuteDataset  ExecuteDataTable   ExecuteReader   ExcuteScalar  ASP.NET Web API The ASP.NET Web API […]

Learn AWS With MS-SQL(DB) Using SQL Client

Introduction In this article, we will learn about Amazon web service with MS-SQL database using local ms-sql management studio. Requirements Register AWS console SQL Server Management Server Let’s start Create SQL Database in AWS You want to login to the AWS console here. If you have no login register new users here. After registering amazon will provide […]

SQL To JDEdwards Date Conversion

Once Linked JDEdwards database in our MS-SQL database under the Linked server and when we going to see the data it should be encrypted. Here I am show to how to see data like as MS-SQL. Actual JDEdwards data My linked server name is “TESTDTA” (JDEdwards database). Open new query window type the below query […]

MS-SQL Convert String To Table List

In this blog, I will demonstrate how to convert string into table list the dynamically using MS-SQL user define function. Create a function:    When we start programming in any language, mostly we use loop & every time to hit server side code for list data. This function helpful to reduce our server side code […]

About

Hi Everyone, My name is Thiruppathi Rengasamy. I ‘m a .Net Developer, Author & Blogger. And also I’m working as senior software engineer in Microsoft Technologies for  5 Years. I would like to spend my precious time in writing articles, research in .Net technologies and to learn new technologies. I have been awarded as C# Corner […]

Learn MVC Using Angular Dynamic Control In DataTables

Introduction In this article, we will learn MVC using Angular data binding for dynamic control in DataTables from a server side Web API using Visual Studio 2017. In this article, we are going to: Create a Database. Create a Store procedure. Create an MVC Application. Use Angular DataTables Dynamic Control. Create Database Open SQL Server […]

Show Buttons
Hide Buttons