creating tables in a database by using proper ANSI SQL syntax 98-364 database fundamentals

Question

Hi 

We are working on 98-364 exam guide and one of the requirements is 

"creating tables in a database by using proper ANSI SQL syntax"

Is someone able to give me T-SQL CREATE TABLE statement that is NOT ANSI SQL Syntax???

Answer 1

They may just mean actually writing the SQL as opposed to using the graphical designer in SSMS

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 2

http://www.w3schools.com/sql/default.asp This is a good source for ANSI SQL

---

Microsoft Certified Trainer & MVP on SQL Server
Please "Propose as Answer" if you got an answer on your question, and vote for it as helpful to help other user's find a solution on a similar question quicker.

Answer 3

Hi 

We are working on 98-364 exam guide and one of the requirements is 

"creating tables in a database by using proper ANSI SQL syntax"

Is someone able to give me T-SQL CREATE TABLE statement that is NOT ANSI SQL Syntax???

Hello Katie..

ANSI SQL SYNTAX: Is when you use the code directly rather than with the graphic style

Example:Graphic Style

Ansi Sql syntax. :

CREATE TABLE [MYTABLE] (ID NCHAR(10), NAME NVARCHAR(10))

Best Regards.

---

Please vote if you find this posting was helpful or Mark it as answered. Leonardo Martínez

Answer 4

I know with join you can use "old" way instead of ANSI SQL (using WHERE instead of join/on)  but I haven't heard anything about it that would apply to create table?

I suspect that there is only proper way using T-SQL unless they mean something very specific but if most people haven't heard about it (or don't care as it is insignificant) I think I will just put comment "don't worry about this one"

Answer 5

I know with join you can use "old" way instead of ANSI SQL (using WHERE instead of join/on)  but I haven't heard anything about it that would apply to create table?

I suspect that there is only proper way using T-SQL unless they mean something very specific but if most people haven't heard about it (or don't care as it is insignificant) I think I will just put comment "don't worry about this one"

People should worry about it - you would be suprised how many people cannot write a Create table statement and always use the designer ;)

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 6

T-SQL has some non_ANSI data types. The DEFAULT clause has to come after the data type. The ANSI temporary table syntax is different. The functions in the CHECK() can be dialect in T-SQL. Partitions are different. ANSI has more options in the DRI actions.   That is all I have off the top of my head. 

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

Answer 7

T-SQL has some non_ANSI data types. The DEFAULT clause has to come after the data type. The ANSI temporary table syntax is different. The functions in the CHECK() can be dialect in T-SQL. Partitions are different. ANSI has more options in the DRI actions.   That is all I have off the top of my head. 

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

True, but since it is a Microsoft certification test, I doubt that they are trying to get people to draw distinctions between ANSI and non ANSI portions of the language.

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 8

I think the confusing word is proper ANSI SQL syntax.

many thanks for all replies

Answer 9

http://www.contrib.andrew.cmu.edu/~shadow/sql

And btw, using the gui to create an table will also be ANSI as the gui generates a script that executes.

---

Microsoft Certified Trainer & MVP on SQL Server
Please "Propose as Answer" if you got an answer on your question, and vote for it as helpful to help other user's find a solution on a similar question quicker.

Answer 10

Follow tequality website for best reference to sql databade fundamentals ...