Click here to Skip to main content
       

Database

 
QuestionWhat is Ado.net PinmemberHimanshu Sharma 88812-Feb-13 20:20 
AnswerRe: What is Ado.net PinmvpRichard MacCutchan12-Feb-13 23:31 
GeneralRe: What is Ado.net PinmemberShameel13-Feb-13 1:44 
GeneralRe: What is Ado.net PinmemberThomas Gabriel20-Feb-13 23:42 
AnswerRe: What is Ado.net PinmvpSandeep Mewara13-Feb-13 1:23 
QuestionSQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 7:47 
AnswerRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 8:48 
GeneralRe: SQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 9:27 
GeneralRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 9:36 
GeneralRe: SQL 2008 Truncate vs Delete PinmemberKhorshed Alam, Dhaka18-Feb-13 19:09 
AnswerRe: SQL 2008 Truncate vs Delete PinmemberNickPace12-Feb-13 11:09 
AnswerRe: SQL 2008 Truncate vs Delete Pinmemberdjj5513-Feb-13 4:59 
AnswerRe: SQL 2008 Truncate vs Delete Pinmembergvprabu20-Feb-13 22:37 
QuestionSQL Server 2008 PinmemberVishwaKL10-Feb-13 18:51 
Hi Guys,
 
I want to know the table creation for the problem described below.
 
I have a 26 parameters for a customer feed back,
and i have a set of sites , some sites don't have some parameters in my 26 points, and some site want more then 26 points,
 

so i thought to create table like
 
id(int),parametename(Nvarchar(max)),site1(bit),site2(bit),site3(bit),site4(bit)
 
and i will allow in UI to check which point is applicable for which site,
 
this solution is for time being,
 
my concern is id the site name may add in future that time we have to change the parameter table and modify the insert and update methods as well as Store procedure,
 
How can avoid the re-coding by creating customized table.
 

Please suggest me the solution.
 

Thanks and regards
Vishwa
AnswerRe: SQL Server 2008 PinmemberShameel10-Feb-13 23:33 
AnswerRe: SQL Server 2008 Pinmemberjschell11-Feb-13 9:20 
Questionupdate values in a table in single query Pinmembernainakarri7-Feb-13 21:07 
AnswerRe: update values in a table in single query PinmemberMycroft Holmes7-Feb-13 22:00 
GeneralRe: update values in a table in single query PinmemberShameel10-Feb-13 23:38 
GeneralRe: update values in a table in single query PinmemberMycroft Holmes11-Feb-13 14:30 
AnswerRe: update values in a table in single query PinmvpEddy Vluggen7-Feb-13 23:42 
GeneralRe: update values in a table in single query Pinmembergvprabu10-Feb-13 19:02 
AnswerRe: update values in a table in single query Pinmembergvprabu20-Feb-13 22:43 
QuestionIs it possible to print a variable in stored procedure PinmemberDeepthi.214567-Feb-13 20:45 
AnswerRe: Is it possible to print a variable in stored procedure Pinmembernainakarri7-Feb-13 21:22 
GeneralRe: Is it possible to print a variable in stored procedure Pinmembervanikanc12-Feb-13 9:19 
QuestionVisual Studio 2005 Access 2010 Database PinmemberMember 98194707-Feb-13 13:06 
AnswerRe: Visual Studio 2005 Access 2010 Database PinmemberMycroft Holmes7-Feb-13 14:45 
QuestionSimulate transaction: non blocking insert / update PinmemberBob Stanneveld7-Feb-13 12:12 
AnswerRe: Simulate transaction: non blocking insert / update PinmemberMycroft Holmes7-Feb-13 14:44 
QuestionPropagating a MySQL transaction with MSMQ II PinmemberGer Hayden6-Feb-13 9:08 
QuestionMissing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 4:03 
AnswerRe: Missing Data in an Access Report Pinmemberjschell6-Feb-13 9:11 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 20:01 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 10:52 
AnswerRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 13:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 20:06 
GeneralRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 21:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 21:32 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 10:56 
Questionoracle error with winserver2008 Pinmemberfares35-Feb-13 2:03 
AnswerRe: oracle error with winserver2008 PinmemberBernhard Hiller5-Feb-13 5:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy1-Feb-13 19:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmvpRichard MacCutchan2-Feb-13 0:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) [modified] Pinmemberdevvvy2-Feb-13 16:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmemberPIEBALDconsult2-Feb-13 6:22 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy3-Feb-13 0:30 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberjschell3-Feb-13 7:36 
QuestionSP Unexpected Behavior Pinmembereddieangel1-Feb-13 8:19 
QuestionEncrypt a field in the database. Pinmembervanikanc1-Feb-13 6:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 27 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid