Click here to Skip to main content
15,867,488 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 7:48
professionalEddy Vluggen12-Feb-13 7:48 
GeneralRe: SQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 8:27
mrfalk12-Feb-13 8:27 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 8:36
professionalEddy Vluggen12-Feb-13 8:36 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Khorshed Alam, Dhaka18-Feb-13 18:09
Khorshed Alam, Dhaka18-Feb-13 18:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
NickPace12-Feb-13 10:09
NickPace12-Feb-13 10:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
Corporal Agarn13-Feb-13 3:59
professionalCorporal Agarn13-Feb-13 3:59 
AnswerRe: SQL 2008 Truncate vs Delete Pin
gvprabu20-Feb-13 21:37
gvprabu20-Feb-13 21:37 
QuestionSQL Server 2008 Pin
VishwaKL10-Feb-13 17:51
VishwaKL10-Feb-13 17: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 Pin
Shameel10-Feb-13 22:33
professionalShameel10-Feb-13 22:33 
AnswerRe: SQL Server 2008 Pin
jschell11-Feb-13 8:20
jschell11-Feb-13 8:20 
Questionupdate values in a table in single query Pin
nainakarri7-Feb-13 20:07
nainakarri7-Feb-13 20:07 
AnswerRe: update values in a table in single query Pin
Mycroft Holmes7-Feb-13 21:00
professionalMycroft Holmes7-Feb-13 21:00 
GeneralRe: update values in a table in single query Pin
Shameel10-Feb-13 22:38
professionalShameel10-Feb-13 22:38 
GeneralRe: update values in a table in single query Pin
Mycroft Holmes11-Feb-13 13:30
professionalMycroft Holmes11-Feb-13 13:30 
AnswerRe: update values in a table in single query PinPopular
Eddy Vluggen7-Feb-13 22:42
professionalEddy Vluggen7-Feb-13 22:42 
GeneralRe: update values in a table in single query Pin
gvprabu10-Feb-13 18:02
gvprabu10-Feb-13 18:02 
AnswerRe: update values in a table in single query Pin
gvprabu20-Feb-13 21:43
gvprabu20-Feb-13 21:43 
QuestionIs it possible to print a variable in stored procedure Pin
Deepthi.214567-Feb-13 19:45
Deepthi.214567-Feb-13 19:45 
AnswerRe: Is it possible to print a variable in stored procedure Pin
nainakarri7-Feb-13 20:22
nainakarri7-Feb-13 20:22 
GeneralRe: Is it possible to print a variable in stored procedure Pin
vanikanc12-Feb-13 8:19
vanikanc12-Feb-13 8:19 
QuestionVisual Studio 2005 Access 2010 Database Pin
Member 98194707-Feb-13 12:06
Member 98194707-Feb-13 12:06 
AnswerRe: Visual Studio 2005 Access 2010 Database Pin
Mycroft Holmes7-Feb-13 13:45
professionalMycroft Holmes7-Feb-13 13:45 
QuestionSimulate transaction: non blocking insert / update Pin
Bob Stanneveld7-Feb-13 11:12
Bob Stanneveld7-Feb-13 11:12 
AnswerRe: Simulate transaction: non blocking insert / update Pin
Mycroft Holmes7-Feb-13 13:44
professionalMycroft Holmes7-Feb-13 13:44 
QuestionPropagating a MySQL transaction with MSMQ II Pin
Ger Hayden6-Feb-13 8:08
Ger Hayden6-Feb-13 8:08 

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

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