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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-12 : 07:15:33
|
| ramesh writes "i was using oracle database in last 2 years.presently my concern using sqlserver 2000. so i have some doubt in sqlserver 2000.pls answer me.1.Give some tips T-SQL with Examples.2.how to call .sql files in query analyser." |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-12-12 : 07:23:17
|
quote:
Originally posted by AskSQLTeam
1.Give some tips T-SQL with Examples.2.how to call .sql files in query analyser."
Regarding T-SQL tips you can read the BOL or you will find out lot's of link in www.sqlteam.com. Just search it.You can "open" .sql file in query analyzer.Surendra |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-12 : 07:36:18
|
| 1 Read the topics in Transact -SQL forum2 If you want to run the script stored in .sql then make use of osql. Read it in SQL Server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-12 : 08:15:52
|
| YOu also might want to invest in a couple good books. I would recommend anything by Ken Henderson for the language, since you are already familiar with a version of SQL. Also, Books Online, which is included free with SQL Server, gives you tons of information on the language and includes examples. To open a .sql file in Query Analyzer, you just need to associate the file type with Query Analyzer or go to file/open in the tool and open it. It's pretty straightforward. Was that really what you meant to ask?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
sql doubt