Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balaji_99
Starting Member
2 Posts |
 Posted - 2006-05-11 : 09:31:08
|
| I'm a part of QA team of a project which mostly deals with the datamigration where the target database is oracle.We are to test those target tables and validate them. So before we go into it indepth, We would like to have some handson of SQLs etc. We have not worked in SQLs as we QAs. Can anyone share if there are any link for getting hands on of SQLs. We have n number of books for SQL but we are looking for getting practical experience. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-11 : 09:44:03
|
| Try searching forsql tutorialin google.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
balaji_99
Starting Member
2 Posts |
Posted - 2006-05-11 : 09:56:30
|
| Actually i'm looking for a software kind of an application which can replicate TOAD or WINSQL.We just need to have a feel of writing SQL queries before we jump into the real time project. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-11 : 10:47:52
|
| SQL Server (2000) has a set of Client Tools that includes Query Analyser which does a similar job to TOAD.I believe that there is a version of TOAD for SQL Server, and WinSQL works with SQL Server too - they may a better choice if you are more familiar with them, although obviously SQL Server's own tools are closely-matched with SQL Server itself.SQL Server Client Tools also include a Profiler tool which can "spy" on queries being sent to the server - and report on Duration / Coverage etc. which may be useful in a QA role.Kristen |
|
|
|
|
|
|
SQL Dumbs