In this lecture, you will learn to do basic CRUD operation using web service and stored procedure. To complete this lecture you need database script,...
What View do ?• First, It help you break down complex queries.• Secong, Query reusability.• Third, Security.(not fully recommendable) What is View ?View is just...
•Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover:•PIVOT example•PIVOT syntax•Interview Question•PIVOT on northwind•Dynamic PIVOT query SQL Query:
Generating Row Number in SSIS for each record. Steps for Generating Row Numbers are: Step 1: Add Data Flow.
SQL (Structured Query Language) It is high level language which provide you capability to query data from any structured data source (Tables). High level language...
Topic to cover: Connecting SFTP using Private Key using .NET console App• Downloading and Uploading File For complete SFTP operation in detail check link below:Article:...
Topic to cover: Connecting SFTP using Private Key using .NET console App• Downloading and Uploading File For complete SFTP operation in detail check link below:Article:...
This exception is thrown only in 3 cases:1. Parameter is not passed to sub report2. Parameter which is been passed is not been created on...