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
Go to Top of Page

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
Go to Top of Page

zaidqis
Yak Posting Veteran

63 Posts

Posted - 2006-07-06 : 15:26:22
no answer !!
Go to Top of Page

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
Go to Top of Page

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 ??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-06 : 16:50:09
What is meant by a smart database?

Tara Kizer
aka tduggan
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

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
Go to Top of Page

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 )

Go to Top of Page

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. :)
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -