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.
| Author |
Topic |
|
Shadab Shah
Starting Member
23 Posts |
 Posted - 2012-07-25 : 04:52:15
|
| Hi, I would like to know wheather we can create a table in such a manner that only one record is stored in the table? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-25 : 04:57:05
|
http://www.sqlservercentral.com/Forums/Topic456823-149-1.aspx#bm456837
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Shadab Shah
Starting Member
23 Posts |
Posted - 2012-07-25 : 05:19:13
|
| Yeah thats fine. Thanks for the reply but over here,the query is restricted to the value 1 which i don't want can you suggest anything else. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-25 : 05:33:34
|
You can just have another column with your wanted value.If you can post post what you really want then we can give help in more detail...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Shadab Shah
Starting Member
23 Posts |
Posted - 2012-07-25 : 22:52:49
|
| Hi, The output given b you is completely fine but , i am bound to the value 1. I don't want that.I want that when the table is presented to the user he/she can enter any value other than 1 i.e. i don't decide during the table creation that what value the user should enter. It should be user preference as to what value the user can enter. |
|
|
|
|
|
|
Single Record in a Table