Problems & Solutions
Installed express edition 2014, but not sure how to get AdventureWorks database.
- download AdventureWorks bak files.
- connect sql with root/admin/sa user.
- rightunable to connect it in Talend
Problems & Solutions
Installed express edition 2014, but not sure how to get AdventureWorks database.
- download AdventureWorks bak files.
- connect sql with root/admin/sa user.
- right
unable to connect it in Talend
Create/Drop database
create/Alter/Drop/Truncate/Insert/Select/Delete table
create/Alter/Drop/Exec procedure - Cursors, loops and conditions and more
create/Alter/Drop trigger
Date Functions
String Functions
Aggregate Functions: Min, Max, Sum
Clauses used with select statement: Group by, Order By, Having, Where, In