i cant expression it !! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

i cant expression it !!

Author

Topic

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-06 : 11:14:54

hi
i have question and i wish i can expression it
when we desgin project for factory or school ,,,
must be the desgin of the database be smart and make use of all sql server features
so is there any book talk about that ??
thank you

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-06 : 11:18:37

Have fun

http://www.sqlteam.com/store.asp

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-06 : 11:53:56

thank you
i found many books
but i dont know what i have to chose

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-06 : 15:26:22

no answer !!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-06 : 15:54:00

quote:
Originally posted by zaidqis

no answer !!

What is your question?

Tara Kizer
aka tduggan

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-06 : 16:32:28

when we desgin project for factory or school ,,,
must be the desgin of the database be smart and make use of all sql server features
so is there any book talk about that ??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-06 : 16:50:09

What is meant by a smart database?

Tara Kizer
aka tduggan

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-07-06 : 22:13:34

One that uses ALL the features ? At once ?

That sounds like a stupid database to me.

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-06 : 22:24:25

are you asking for a project idea that uses all the server features?

--------------------
keeping it simple...

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-07 : 01:08:54

this question is probably better answered at http://www.dbforums.com

-ec

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-07 : 05:51:20

quote:
What is meant by a smart database?

i mean the desgin of the database be smart (desgin smart)

quote:
One that uses ALL the features ? At once ?

That sounds like a stupid database to me.

i dont mean this
i mean when we desgin database for a case
we must use all the features of sql server which be useful in that case ( i dont mean all features .. just the useful in our case )

mr_mist
Grunnio

1870 Posts

Posted - 2006-07-07 : 06:21:25

Here is a database design that is both smart and utilises the "SELECT" function.

CREATE DATABASE [Iamsuchasmartdatabase]
Go
USE [Iamsuchasmartdatabase]
CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))
INSERT INTO [dbo].[smarttable] VALUES ('smart')
SELECT smartcolumn FROM [dbo].[smarttable]
USE master
Go
DROP DATABASE [Iamsuchasmartdatabase]

-------
Moo. :)

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-07 : 08:51:06

It's called Northwind.

Sort of....

Is this a project for school? If so, I'd ask the instructor for more specifics.

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-07 : 09:24:57

quote:
Originally posted by mr_mist

Here is a database design that is both smart and utilises the "SELECT" function.

CREATE DATABASE [Iamsuchasmartdatabase]
Go
USE [Iamsuchasmartdatabase]
CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))
INSERT INTO [dbo].[smarttable] VALUES ('smart')
SELECT smartcolumn FROM [dbo].[smarttable]
USE master
Go
DROP DATABASE [Iamsuchasmartdatabase]

-------
Moo. :)

Really smart
But you forget to use Smart DataType

Madhivanan

Failing to plan is Planning to fail

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-07-07 : 09:56:43

quote:
Originally posted by mr_mist

Here is a database design that is both smart and utilises the "SELECT" function.

CREATE DATABASE [Iamsuchasmartdatabase]
Go
USE [Iamsuchasmartdatabase]
CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))
INSERT INTO [dbo].[smarttable] VALUES ('smart')
SELECT smartcolumn FROM [dbo].[smarttable]
USE master
Go
DROP DATABASE [Iamsuchasmartdatabase]

-------
Moo. :)

Very smart indeed !

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources