The Ved Blog

Learn Development with new technology before it get change.

Search This Blog

Showing posts from 2023

View all

Posts

EXCEPT and INTERSECT in SQL Server

on February 04, 2023

+0 EXCEPT and INTERSECT in SQL Server

EXCEPT and INTERSECT in SQL Server

0

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

.asmx file
.Net Three Tier Architecture
1NF
2005
2008 backup
2nd Highest Salary
2NF
3NF
About HTML5
add

add days in date
add google search in website
Add number of days in date using asp.net
Add Remove List Item from ListBox
ADO.net
Ajax
Ajax Accodian
Ajax Extender
Ajax features
Ajax Model Popup
Ajax model popup Control in GridView
Ajax Model Popup Extender
Ajax Model Poup Extender
Ajax Popup
Ajax Popup Control Extender
Ajax Update Panel
Ajax update progress
Ajax without postback
All Or Single result base on parameter in SQL; SQL query parameter to get all or single result; how to get all or single result by sql parameter.
Allowed only numeric in javascript
Alphabetical Indexing using Ajax
Amortization calculator
Application Error via Global.asax
Application Variable
ArrayList to Variable Conversion in C#
Ashtmi Puja
asp.net
asp.net using c# contact code
ASP.net 2.0 vs 1.1
ASP.net 2.0 vs 3.5
ASP.Net 4.0
ASP.net 4.0 features
ASP.NET ADO
Asp.net ajax new features
ASP.net Amortization Calculator
ASP.net calendar using GridView
ASP.net Calendar with Date and Days
ASP.net connection time out
asp.net date comparison
asp.net enquiry page
Asp.net Error Handling
ASP.net Facebook and twitter shares
ASP.net FB and Twitter Share from website
ASP.net interview questions. Boxing and Unboxing
ASP.net Login Control
ASP.net Range Validator
Asp.net three tier architecture
Asp.net time entry application
Asp.net validation control
ASP.net validations control only Alphabets
ASP.net validations control only Numeric
ASP.net webService
Attendance System using C#
Auto Complete
auto complete in asp.net using JQuery
auto number
Auto redirect when session time out in Asp.net
AutoComplete Extender
AutoComplete in Asp.net
AutoComplete Text in Textbox using JQuery in ASP.Net
AutoComplete TextBox Extender
Automated SQL database backup
Backup Database
Bargraph using C#
Basic of Jquery
BASIC SQL Statements
BI Lookup and Lookup In BI
Bind DropDown List using XMl
bind gridview using dataview
bind GridView using LINQ
Bind Image Gallery using DataList with DirectoryInfo
Bind Images in ASP.net
Bind Repeater With DataBase through ASp.net page
Bind Report through asp.net page. Zoom Mode in SSRS Report
Bind State City on Change Event using Data Reader
BindGridView
BL and DAL
blame
breakfast
Bullet list using Ajax
Bullet list using Asp.net ajax control
Bussiness Logic
C#
C# Linq
C# three tier Architecture
calculate date after few days
Calculate Finance Year data in sql
Calendar control in Ajax
Calendar Time Entry
Camel casing
Chart in asp.net
checkbox checked
choose catchy domain name
choose your domain name
Clustured
COALESCE
COALESCE function in sql
coding standards in Asp.net
coding standards in C#
Collpase – Expand in Treeview
combobox
Comma Separated Date entry in SQL table
command time out error
Commit
Common regular Expression Validator
Compress
connection string
connection time out error in asp.net
Contact us page in asp.net
Content Template
ContentTemplate
Conversion of Date from Varchar in SQL Server
cookie expiration time
Count down timer using ASP.net C#
countdown date function
CREATE
Create Calendar using C#
Create Cookies in ASP.net
Create Curosr
Create graph using C#
Create Nested Tablix in SSRS Report
create pie-chart using asp.net
create setup file
Create Shopping Cart
Create your calendar using Gridview
Create your first SSRS report
Cross page post back
Crystal Report
crystal report with parameter
Crystal Report with SQL Server
crytalreport in ASP.net
CSS
CSS3
CSS3 features
CSS3 with Html5 shadow effect
custom calendar in asp.net
custom error
Custom error mode
custom google search
Custom paging in datalist
Customized DataList Control
Customized GridView
Data Access Layer
Data Type
Database connection Error in ASP.net
Database Mail
DataGridView
DataImport through SQLBulkCopy
DataList paging
DataView
date addition
Date Conversion in SQL
date function in ASP.net
Date Name in sql
Date time issues on local server and deployment server in C# .Net
DateAdd in sql
DateDiff in SQL
DateFormat
Day Number in SQL
Daya kar Daan Bhakti ka Hame Parmatma Dena
Days count down in ASP.net using C#
DDL and TCL
deadlock in sql server
dear
Debgug Javascript.
DEBUG and Release Mode
Debug vs Release Mode in ASP.net
Debug vs Release. Web.config release mode.
Debug='true'
Debugger
DECLARE Cursor
DefaultRedirect
Delete button
Delete Duplicate Records
DELETE in SQL
DELETE statement in LINQ using C#
delete using LINQ
delete with LINQ to SQL
Delete with SQL Index on table.
Delete. How to Delete
Directory Info
DirectoryInfo
display date time on status bar in windows application
Display runtime Image in ASP.net
DISTINCT and TOP
Distinct and top keyword in Sql
Div Shadow effect
div shadow effect using CSS3
Divide by zero
Divide by zero and COALESCE function in SQL
domain name selection
Domain selection
Doughnut chart in asp.net
Download file using popup box
Download Files in ASP.net
DROP Statement in SQL
dropdown
DropDown without postback in Asp.net
Dyanimc Image Binding
Dynamic DataList Control
edit
emailbody
EMI calculator
EMI Calculator in C#
Employee Attendance System updated version
Employee Attendance System using C# (ASP.net)
Enquiry page in asp.net
Enquiry page source code using asp.net
Events
Events of page in asp.net
Excel to SQL
EXCEPT and INTERSECT in SQL Server
Exist Clause
Exist over Count
Facebook and Google Login Integration in website using JQuery
Fast Data Import Through SQLBulkCopy
faster query
FB Share
features of ASP.net 2.0
features of ASP.net 3.5
features of ASP.net 4.0
File Upload Control in ASP.net
Filter issue with Tablix
Firebug
Flat File Source Error: Data conversion failed in SSIS
Form
Gaph in asp.net
generate crystal report in ASP.net
Generate I.P using ASP.net
Generate SQL Scripts
ger auto generated number after record inserted
Get Financial Year record from SQL table
Get host I.P address in Asp.net
get I.P address of server in asp.net
Get last affected rows number
Get Logged In User Manager in Look Field
Get Manager to logged in User in MSCRM 2016
Get Month wise Date in SQL
Global.asax error handling
Good naming convention in C#
google search in html website
Graph using C#
Gravatar control in Ajax
GridView
GridView binding using dataview
GridView Calendar Control
Gridview checkbox selection control
GridView Default Edit
GridView in ASP.net
GridView paging
GridView row data bound
GridView Sorting
GridView Sr. no
GridView using StringBuilder
GridView with checkbox control
GridView with DataReader
GridView within Edit
Handle error through Global.asax
Happy Diwali
Happy Dussehra 2012
Happy Navratri
happy navratri 2014
Happy New Year 2012
Happy New Year 2015!
Heap in ASP.Net
Hour Minute Calculation from TextBoxes using JQuery
How IF Exists Works
how to add cookies in asp.net
how to bind Dropdown through XML
How to choose a domain name
how to choose good domain name
how to create .asmx file
how to create bar chart in asp.net
how to create ssrs report
how to create web services in asp.net
How to debug JavaScript method in ASP.net
how to do proper coding
How to enable paging in DataList
how to get last inserted row number in sql
How to get Logged in User Count
How to get Month name in SQL
How to handle error using Global.asax
How to identify who has created or dropped table in SQL Server DB?
how to increase SSRS graph width.
how to insert
How to insert record using linq
how to optimize asp.net page
How to pass XML as parameter in SQL Stored Procedure
How to resolve connection timeout issue
how to set control autocomplete disable
How to Set Max Length of TextBox Control
how to show datalist in two rows
How to Show Div Using JQuery
how to take SQL backup
How to upload images in Asp.net using C#
how to upload large files in ASP.net
how to use Distinct and top keywords
how to use LINQ
how to use LINQ query in ASP.net
how to use Login Control in Asp.net.
how to use naming convention
how to use SQL query in LINQ
how to work with crystal report
how to write web service in asp.net
how WCF works
Html
HTML image control
HTML page design
Html page optimization
Html Standards
HTML5
HtmlImage in Asp.net
human
I.P
identity
IF condition in SSRS
IF Exists in SQL
IF Exists keyword in SQL
Image effect in javascript
Image mouse out effect
Image mouse over
Image optimization
Image rollover effect
Imp functions in SQL
Imp points for SSRS
Imp Query
Imp Topics on Sharepooint
Import Excel to SQL
Import from excel to SQL using asp.net
Important question on WCF
Improve site performances
Improve SQL Server Performance
Increase SSRS Graph series width
Index
Index and Delete Query.
Indexing Slow Delete Operations On SQL Table
insert
Insert into SQL Statements
inside page
IsPostback
javascript
Javascript Numeric
Javascript numeric in asp.net
javascript on mouse over and out efect
Javascript optimization
Javascript Validation inside Asp.net Control.
javasript mouse over and out effect
JQuery
Jquery autocomplete
JQuery Check in GridView. JQuery GridView
JQuery DropDown in HTML with Asp.net
JQuery Effect
Jquery Max Length in TextBox
JQuery total in GridView
JQuery with Asp.net
know about ASP.net 4.0
Know your sql statement
kolaveri
LeafNode
learn HTML5
Learn JQuery
learn php
Learn SQL
lifestyle
LINQ BASIC
LINQ Delete Query
LINQ features
LINQ in ASP.net
LINQ Select Query
LINQ to SQL
LINQ to SQL in ASP.NET
LINQ Update Query
LINQ with ASP.net
List Control in SSRS Report.
LOCK
Login Control in ASP.net
Lookup Cache
Lord Rama.
luxury
Mail sending via SQL Database
Maintain your Session in Class file using C#
Managment
Matrix in SSRS
Max Length in TextBox
mercy
Model popup box
Model Popup Control
Modify column in SQL
Month Number
MOSS in sharepoint
mouse out effect
Mouse over and out javascript effect
mouse over feect
Multiple Drop Down Binding using Data Reader
Multiple Paramter in Table Filter in SSRS
MVC
Navigation Control in ASP.net
Navratri 2012
new realeases of Ajax control toolkit
No of days to go function in ASP.net
NOCOUNT
Non clustured
nonedtable
Normalization
nth highest salary in sql server.
Number of occurrence of character in C#
Number validation in javascript
Off
old people
OledbCommand
OledbDataReader
On
onClick
open popup in gridview Item Template
optimize asp.net page
ORDER By Group By
OutputCache
page asp.net page faster
Page Buffer
page event in asp.net
Page load event in asp.net
page not found error
page optimization for designer
Page optimization in Asp.net
Page performance in ASP.Net
PagedDataSource in Asp.net
Paging
PagingBulletedListExtender control in ASP.net
Parent Node
Partial Class
Partial Class Example
partial class in ASP.net
Partial Class in C#
pascal
Pascal Casing
Pass Parameter from one from to another form in MSCRM 2016
pass paramter in windows form
pass value to windows form
PHP
php link
php tutorials
Pie Chart Label OutSide
PL
Play video in popupbox
Populate Dynamic DropDown with JQuery
Popup Control
Popuup control inside gridView
post data from one to another page in asp.net.
postback data in Asp.net
Presentation Layer
Prevent postback in asp.net
Prevent postbck on select index change of dropdown
Prevent SQL Injection
PromptAreaCollapsed property in SSRS 2008R2
Proper Html Tags
Reference Type
Regex in Codebehind
Regular Expression Validator
Regular Expression validator for Date
RemoteOnly
Remove character from string in C#
repater binding through XML
Repeater paging
report parameter using functions
Report with full page width in zoom mode
RequiredFieldValidator on runtime
Response.ContentType in ASP.net
Rollback
RootNode
Row data bound
Row Deleting
ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID
Running Value
Runtime Image in ASP.net
Save Image in SQL table in form of image data type
schedule sql backup usin batch file
Scheduled Backup database
SCHEMA
Search Index using PagingBulletListExtender
second highest salary
selecetion change
Select auto increment number from select query in SQL
SELECT Count vs EXISTS
Select Index Change via Ajax
Select Statement Auto Number
select URL
SEO in Asp.net
SEO tips
Series width
Server farm
Share with facebook and twitter from your website
SharePoint Imp Questions
Sharepoint installation guide
sharepoint installation note help
Sharepoint server 2010
Shopping Car in asp.net
Shopping Cart Example
Shopping Cart in C#
Shopping cart source code
Show Hide Div using JQuery
Shree Krishna Janmashtmi 2014
Simple crystal report
Simple Online Quiz with timer using ASP.Net and SQL Server
Site Map using Treeview
SiteMap
song
Sorting in GridView manually
Split Date with comma separated value
SQL
SQL 2008
SQL 2008 Scripts
SQL auto number in SELECT Statement
SQL Backup using stored procedure
SQL Column Running Value
SQL command
SQL Commands
SQL Comparison Operator
SQL Cursor
SQL Data Encryption
SQL Data Encryption on column; Data Encryption
SQL Data Reader
SQL Data Reader with Next Result
SQL data Scripts
SQL Database Maintenance
SQL DataReader
SQL db backup
SQL deadlock
SQL DML
SQL for beginer
SQL Injection
SQL Interview questions
SQL Logical Operator
SQL Mathematical Operator
SQL Operation
SQL operator
SQL Performance
SQL Procedure
sql query
SQL Scripts
SQL Scripts Backup
sql select
SQL Send Mail
SQL Server 2008
SQL Server in ASP.net
SQL Server Performance
SQL Statement
SQL Statements
SQL Table Partitions
SQL Transaction
SQL While loop with Date
SQL2000
SQLBulkCopy
SQLDataClient class object
Srting to Date Format
SSAS Cube and Schema
SSIS
SSRS 2008 Expressions
SSRS Expression
SSRS Graph width size
SSRS List Item
SSRS Report
SSRS Report rendering issue
SSRS Report with Asp.net
SSRS Reports
Stack
State Management in ASP.net
Status bar message in window application
Stored procedure
Stored Procedure with XML in SQL
stringbuilder
Substring in SQL
Switch case in SSRS
T-SQL
Tablix Group and Sorting Issue
Tax Calculations in C# (ASP.NET)
things to avoid in sql query
third lowest salary
Three Tier in ASp.net C#
time
Time Entry calendar form in asp.net
Timeout Expired
today
Tracing
TreeView CheckBox
TreeView Control
TreeView control in ASP.net
TreeView SiteMap
Trigger
Truth
Twitter Control in Ajax
Twitter Share
txt file
update
update and Edit in GridView
Update Panel
Update Progress
update statement
UPDATE Statements in SQL
update topic views in sql server
UpdateMode
UpdatePanel
uplaod images in sql database
Upload Files in ASP.net
Upload Image in ASP.net
upload images in asp.net
upload large files
upload large files using progress bar
URL Mapping
URL Mapping in ASP.Net
Use of LINQ
Use of LINQ in ASP.net
use of proper sql query
user control
user control inside page
User Roles in MSCRM
User Roles on form load Dynamics 365
validatation using javascript
Validation control in Asp.net and used.Display property in validation control
Validation in .cs
Validator in C#
Value Type
Varchar to Date Conversion
Variable
VB.Net
Views Data
Views Topic
ViewState
visual studio 2005 setup
W3C Standard
WCF
WCF and WebServies
WCF example
WCF in ASP.net
WCF in C#
WCF sample
WCF Services
web method in asp.net
Web Service
Web.Config
WebReference
Webserice in asp.net
Website Login User Count
Website Performances
What is .svc file in WCF?
what is camel casing
What is CSS3
what is HTML5
what is important in SQL query
What is LINQ
what is pascal casing
what is sharepoint
What is SOA service?
what is ssrs
What is three major points in WCF?
What is WCF
What is WCF?
what's new in Ajax
what’s new in ASP.net 3.5
What’s new in ASP.net 4.0
While LOOP in SQL
Why deadlock used in SQL?
why this kolaveri di
Window form parameter
windows application
windows setup
Wish you happy new year 2014
with no lock
Working with LINQ
Working with Page Methods in ASP.net
XML Parameter in SQL Stored Procedure
xml as sql parameter
XML Databind
XML DropDown Binding
Xml in stored procedure as Parameter
Ya Devi Sarvabuteshu Shakti Rupen Sanshtita Namstaste Namstaste Namstaste Namoh Namah

Show more Show less

Report Abuse

Powered by Blogger

Ved Pathak Blog