How can i select all the fields in a table with reference to 3 or more fields. what is the synax for that.
Printable View
How can i select all the fields in a table with reference to 3 or more fields. what is the synax for that.
can you please clarify by passing more information.
What exactly you want ?
The statement for retrieving the column names from a table in sql server is
Select column1,column2, column3 from tablename where 'here you have to write the referencing conditions..
You can use the fallowing statement
select * from tablename where the reference conditions
You can use the following query syntex
select * from tableName where firstCondition && secondCondition && thirdCondition
nice and helpfull answers