SQL VIEWS and Security

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 a stored query. Can also be said as virtual 
table. They don't hold any data into them.Data comes from 
real tables.SQL select query operator (WHERE, ORDER BY, etc)
 can be used with it.

Script:

File 1:

... Read more »

Insert Delete Update Select using Web Service and Stored procedure in ASP.NET

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, web service and website to test. You can download it from here (click here to download). Lecture:

Sub Queries-

Three basic rules only.

Where you can place sub query?
3 places where you can place your sub query:
SELECT ----- FROM
FROM   ----- WHERE
WHERE  ----->

SELECT ----- FROM
_____________________
(sub query can only return single value & no alias to value returned is required)

Correct:
_________

(select max(val) from abc where ---) Ex output: 10
(select top 1 val from abc where ----) Ex output: abctext

Wrong:
_________
(select val from abc where ----) and result is returning multple rows:

Ex. ouput of above query:
val
___
12
32
45
6
45

Click here to view complete article

How to improve logic building ?

Note: Watch video before reading text below.
Concept:

• Now concept of logic building is not so complex and not so simple.
• We will not work on how to make logic program in C ?
• We will study how to build complex logic in SQL, .NET, JAVA or any other major technologies in market.

Main Part:

• Main part in logic building under all technologies is LIBRARY DEFINED FUNCTIONS.
• This is the main thing I will explain you with different examples in complete lecture.

Click here to read complete article.

To make paper based animation card you need black and white icons or picture sketches. Also you require animbar software which you can download from link provided below. 

Require:

1. Images of same resolution 

2. Animbar

To view complete article and download files click here.

In this tutorial I have used SharpSSH for downloading, uploading and deleting file from remote SFTP..

Code use in video is mentioned below:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Tamir.SharpSsh;
using System.Collections;
using System.Windows.Forms;
using System.IO;
using Tamir.SharpSsh.jsch;
namespace SFTPConnectSample
{
    class Program
    {
        static void Main(string[] args)

Read More>>

LINQ for Beginners

Topic covered are :

• WHERE clause in LINQ
• LEFT JOIN in LINQ
• INNER JOIN in LINQ
• GROUP BY in LINQ
• ORDER BY in LINA

To download script click here.

SQL XML:

You can generate XML from SQL queries without even doing single line of code in your programming language. Below is the script used in above video:

--Query 1

select 1 as tag,null as parent,
c.customerid as [Customers!1!Customerid],
null as [order!2!orderid]
from customers c inner join orders o
on o.customerid=c.customerid
union
select 2 as tag,1 as parent,
c.customerid,
o.orderid
from customers c inner join orders o
on o.customerid=c.customerid
order by [Customers!1!Customerid],[order!2!orderid]
for xml auto

--Query 2

select 1 as tag,null as parent,
c.customerid as [Customers!1!Customerid],
null as [order!2!orderid]
from customers c inner join orders o
on o.customerid=c.customerid
union
select 2 as tag, ... Read more »

Below is script you can use to get scheduled records:

-- Table you requre to hold schedule time and other information
-- you can add other columns too to suite your requirements. 
-- Main columns are scheduletype :  it hold information if schedule is daily, weekly or monthly
-- Scheduletime : Time when you need to send report
-- Scheduleday : Day of week or month you want to fire report
-- for week Sunday holds value 1, monday 2, ... saturday equal 7 and repeat for next week from 1 to 7
-- for month value for scheduleday is for day of month means 1 is 1st day of month 
-- for daily its value doesn't matter
-- other columns are just dependent on requirement
create table #scheduletable
(
reportname varchar(100),
scheduletime time,
scheduletype varchar(10),
scheduledate date,
scheduleday int,
userid int
)
--Note: I am using temporary table. Use table ac ... Read more »

IE11 ssrs report viewer OR report viewer internet explorer 11

If you are doing this in ASP.net. Then add ASP NET Folder App_Browser. Then add Browser File and replace all text with text below or download file attached below:

<browsers>
 <browser id="IE11Preview" parentID="Mozilla">
 <identification>
 <userAgent match=
		... 
		
			Read more »