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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 25, 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

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