Author |
Topic |
zaidqis
Yak Posting Veteran
63 Posts |
Posted - 2006-07-06 : 11:14:54
|
hii have question and i wish i can expression itwhen we desgin project for factory or school ,,,must be the desgin of the database be smart and make use of all sql server featuresso is there any book talk about that ??thank you |
|
X002548
Not Just a Number
15586 Posts |
|
zaidqis
Yak Posting Veteran
63 Posts |
Posted - 2006-07-06 : 11:53:56
|
thank youi 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 Kizeraka 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 featuresso 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 Kizeraka 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 |
|
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 thisi mean when we desgin database for a casewe 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]GoUSE [Iamsuchasmartdatabase]CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))INSERT INTO [dbo].[smarttable] VALUES ('smart')SELECT smartcolumn FROM [dbo].[smarttable]USE masterGoDROP DATABASE [Iamsuchasmartdatabase]-------Moo. :) |
|
|
X002548
Not Just a Number
15586 Posts |
|
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]GoUSE [Iamsuchasmartdatabase]CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))INSERT INTO [dbo].[smarttable] VALUES ('smart')SELECT smartcolumn FROM [dbo].[smarttable]USE masterGoDROP DATABASE [Iamsuchasmartdatabase]-------Moo. :)
Really smartBut you forget to use Smart DataType MadhivananFailing 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]GoUSE [Iamsuchasmartdatabase]CREATE TABLE [dbo].[smarttable] (smartcolumn VARCHAR (25))INSERT INTO [dbo].[smarttable] VALUES ('smart')SELECT smartcolumn FROM [dbo].[smarttable]USE masterGoDROP DATABASE [Iamsuchasmartdatabase]-------Moo. :)
Very smart indeed ! - Jeff |
|
|
|