I have used SQL Server a fair amount but always with SSMS. I would like to be able to use all the capabilities and understand the environment better but I do not know where I use T-sql. I have tried a few tutorials but they seem to gloss over this simple but important part; where do I input these commands? Is it command line? Is it some command line type GUI that should have installed with the SQL Server installation? In this post (https://www.tutorialgateway.org/sql-attach-database/), there is a good example of just jumping into the commands but not specifying where these commands are input. Thank you for any help you can give me.
where do I input these commands? Is it command line?
You can use these commands in a variety of tools that connect to SQL Server these include :
SQL Server Management Studio.
SQL Operations Studio, (Now SQL Azure Data Studio)
Power Query tool in Excel.
Powershell
Pretty much any tool that allows you to connect and issue SQL commands.
T-SQL
is the dialect of SQL
used by SQL Server. SQL
is just a language standard. Each vendor implement their own SQL. SQL Server named its SQL as T-SQL
.
The syntax is a bit different for different dialects. Here's some info. https://stackoverflow.com/questions/1301038/what-are-the-differences-between-t-sql-sql-server-and-sql
(database name)
-> right click ->New Query
? – Peter B Sep 27 '18 at 9:00