Thursday, October 12, 2017

Database Fundamentals #13: Data Entry Through T-SQL

DZone Database Zone
Database Fundamentals #13: Data Entry Through T-SQL
Database Fundamentals #13: Data Entry Through T-SQL

T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time, you won’t be typing everything into T-SQL directly, as we’ll do here. You’ll be able to use stored procedures and parameters to automate the use of scripts. These will also be generated or used by applications.

To start using T-SQL, you need to open a query window. You can do this by right-clicking on a database and selecting the New Query command from the Context menu. This will open a new query window in the main window on your screen. This is basically just a big, open text box into which you can type commands.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...