How is outerjoin represented(symbol) in sqlserver?is it different from sql?what is dynamic sql query,can you plz give me one statement?
How is outerjoin represented(symbol) in sqlserver?is it different from sql?what is dynamic sql query,can you plz give me one statement?
Outer joins are generally used to retrieve data from one table thoug there is no matchind row in left or right table.How is outerjoin represented(symbol) in sqlserver?is it different from sql?
You can access this link for Further information
msdn2.microsoft.com/en-us/library/aa213228(SQL.80) dot aspx
Dynamic SQLs are build run time by using the parameters supplied by user.what is dynamic sql query,can you plz give me one statement
The statements build using parameters can be executed using sp_executesql
The major problem with dynamic SQL is SQLInjection , due to which database becomes vulnerable
You can learn about Dynamic SQL more sommarskog.se/dynamic_sql dot html
HTH
i want following result how is use query
project ename
CRM raja
ramu
tata
ERP arun
priya
vel
here project column is not return again and again project name
coming in front page using dot net.
is it possible in sqlserver query.
thanks
When we want to sellect data from two tables at a time, then we will go for Joins Operation.
To select Matched records as well as Unmatched records from two tables go for Outer Join Operation. It is of two types
1. Left Outer Join
Select table1.column1, table1.column2...........,table2.column1,table2.column2.............. from table1, table2 where table1.commancolumn *= table2.commancolumn
2. Right Outer Join:
Select table1.column1, table1.column2...........,table2.column1,table2.column2.............. from table1, table2 where table1.commancolumn =* table2.commancolumn
Cheers
Prashanth Chenna,