Global web icon
codeproject.com
https://www.codeproject.com/articles/Install-and-C…
Install and Configure SQL Server Reporting Services (SSRS)
Step 4 Next click on the Web Service URL tab from the left panel. Here, you can configure the report server URL. We will use this URL to deploy SSRS reports on the report server. You can also configure ports (80 or 443 (SSL)) on which the report server will host. It will preview URLs in the bottom section. I will go with default settings. Click on the Apply button and it will configure the ...
Global web icon
codeproject.com
https://www.codeproject.com/articles/Generating-In…
Generating Insert or Update statements from table data ... - CodeProject
Writing a SQL script to generate insert or update scripts for a table full of data.
Global web icon
codeproject.com
https://www.codeproject.com/articles/Passing-NULL-…
Passing NULL and table values to a parametrized SQL query
Introduction This tip demonstrates how to create a universal method to pass null and table values to dynamic, but parametrized SQL queries, without a need to create any special types on the server side, or relying on pattern matching for IN clauses. While it returns a DataSet, it can be adopted to return ResultSet<T> or a value type, which exercise is left to the reader. Background The ...
Global web icon
codeproject.com
https://www.codeproject.com/articles/How-Do-I-Use-…
How Do I: Use SQL File Stream - CodeProject
An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.
Global web icon
codeproject.com
https://www.codeproject.com/articles/MsSql-RestApi…
MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API
MsSql.RestApi is a library that can help you to speed-up the process of building powerful REST API with the minimal amount of code. In this article, you will see something that I believe is the best and the easiest way to create a REST API. MsSql.RestApi is a free, open-source ASP.NET library that enables you to create almost any REST API that you want with the minimal effort. The key features ...
Global web icon
codeproject.com
https://www.codeproject.com/articles/Using-tempora…
Using temporary tables with LINQ-To-SQL (L2SQL) - CodeProject
Using LINQ to SQL to create and read temporary tables