Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Feb 24, 1999

Data Types - Page 3

By Christopher Shaw

Know the Syntax.

There are many programs that will help you in creating the syntax
for a query or other tasks. Even the EM will do some of this for you, such as permissions,
create table, and build indexes. Things will be much easier to do in the GUI. I must admit
I started by using the GUI, but I can’t stand to use it now. If you know the syntax
you may be able to do it faster, and easier. The syntax has a pattern to it. Once you
learn a few statements the rest are easier to learn.

I do not like to use the EM. I like to use the keyboard, not the mouse. I have
problems navigating through all the GUI’s that are in the EM. Creating tables is slow
with keyboard to mouse movement, while building indexes is the whole nine yards! Every
thing can be done much quicker if you don’t use the GUI.

I am not saying never use the GUI. I have found that it can help me. For example, I am
new at this and I want to create a table. I am not to sure on how this create table syntax
works. First I would check BOL. If that doesn’t clear up the confusion in my mind
then I would try the GUI . I can create the table in the GUI and name it as Junk. To learn
the syntax for all the data types I simply script out the table. This sounds repetitive.
Why script it out if I already have it? I found that I script it out then use that script
so I can see a good example of how the Create table works. I also get an example to GRANT
and BUILD INDEX. I don’t recommend this over BOL, but in some cases, when I
can’t find exactly what I am looking for, I improvise.

There are some tools that can help in learning the syntax. I use Embarcadero's DBArtisan
I like the way that the product color codes your SQL statements. I will soon be posting a review
on DBArtisan. You can check out a trial version of DBArtisan on their home page.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM