![dtsql tool dtsql tool](http://www.dtsql.com/docs/images/sql_builder_update_condition.jpg)
The code in Listing 1 populates a temporary table called #Words with binary values. This query relies on geometrical concepts-mainly the Pythagorean theorem-but I get to that later. Look at the script that Listing 1 shows and try to figure out what it does. Let me show you an example that takes this 90-degree approach literally.
#Dtsql tool how to
Watch the class perk up when you announce, "Now, we're going to learn how to draw with T-SQL!" For those of you who aren't instructors, you can think of "drawing with T-SQL" as a fun way to learn T-SQL techniques you might find yourself implementing in totally unrelated business scenarios. I'm not talking about just passing the time until the break I'm talking about teaching techniques that you can use to sharpen the students' T-SQL skills without covering business scenarios. The trick I've learned is to turn 90 degrees and take a totally different approach. Let another customer/employee/order/product/invoice problem escape your lips, and you'll lose them. Clients have business problems they want solved, but students have a limit to the number of business scenarios they can handle. A student in class has different needs than a client in a consultancy job. This learning process takes a lot of energy and effort, and if the teacher can't keep the students interested, the result is inevitable. While learning new material, a student has to cope with new concepts and new logical ideas. And I'll share a little secret with you: Assuming the teacher knows his or her stuff, teaching is easier than learning, contrary to popular belief.
![dtsql tool dtsql tool](https://www.start64.com/images/win64/user/universal-database-tools-1.jpg)
To be frank, I think that "dozing-student syndrome" is mostly the teacher's fault. But for the sake of my job, I turned to more productive thoughts about how to realistically make them stay awake. I've amused myself with the thought of sneaking up behind a nodding student and shouting loudly in his ear or taking a pair of scissors to the ponytail of a dreamy student. Trying to teach a bunch of lethargic students can be tough and unpleasant. I can tell you that from the teacher's viewpoint, it's not a pretty sight. One of the most common activities that all of us (well, most of us) have practiced in the classroom as students is of course sleeping. I spend many hours in class each month teaching about SQL Server and T-SQL. At this point all I need to do is hit enter to have the following code snippet inserted into my query window, at the position of my cursor.Tired of the same old business problems? Try something newĮditor's Note: Send your experts-only T-SQL tips to Itzik Ben-Gan at If we use your tip in the magazine, you'll receive $100 and an exclusive T-SQL Black Belt shirt. Therefore, I double click the “Table” folder to list the snippets that are associated with the tables.Īfter I double click the following window is displayed:Īs you can see there is only 1 snippet associate with a table item, which is called “Create Table”.
![dtsql tool dtsql tool](https://windows-cdn.softpedia.com/screenshots/MS-Access-Project-Management-Tool-with-Time-and-Payment-Tracker_2.png)
For my example of how to use a snippet, I will be creating a table. In this display you will find folder names, where each folder contains one or more snippets related to object type identified by the name of the folder.
![dtsql tool dtsql tool](http://3.bp.blogspot.com/_gZ8Lc-enPQ4/TNRAA_q7hkI/AAAAAAAACPc/uTDOZ9H5BN0/s320/ssms-dts.jpg)
Or I could use the Ctrl+K, Ctrl+X keyboard shortcut.Īfter clicking the “Insert Snippet” item, or using the keyboard shortcut key (Ctrl+K,Ctrl+X) the following “Insert Snippet” window is displayed. Doing this brings up a context menu, where I hover over the “Intellisense” item and finally click on “Insert Snippet…” item, as shown in the screenshot below. To start building my TSQL script using a snippet, I first open a query window. Let me show you how to use a snippet that comes with SSMS to create some TSQL to create a table. At a Glanceīy using a snippet, you can insert a block of code into an existing query window to help jump start your TSQL script writing. The insert process makes it easy to identify and modify the text of that snippet. Snippets of code often contain some text that you need to modify to work for your purpose. A TSQL code snippet is a fragment of code that can easily be placed in your TSQL script using SQL Server Management Studio (SSMS).