tsql - How to store a list of items on a single column in SQL Server 2008 -

April 15, 2011

I am looking for an efficient way to store users' information in a SQL Server 2008 table.

All user data in the design will be stored in a table in a column, but one of the columns will need to store the list of values, for example: 'column1' Will store user name , 'column2' user id and 'column 3' which will change over time I will store a list of items. I

I would like this information to be different for each user I really want to avoid putting because you will need several tables in the database.

What data types should I use for this 'Column3' ? Should I use a completely different approach?

  I think we can use it on SQL Server, but it only works for temporary storage. 
  Thank you.

  
  Generally accumulating multiplier values in columns is an indication of poor database design that is that single column Based on the criteria, it makes it very difficult to choose the rows efficiently. If you really need to select those values based on only one line line, consider using XML.


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment








Popular Posts




IronPython in C#: No module named xmlrpclib -



    I am trying to create a web application with an interactive console for IronPython. When I try to import xmlrpclib into the General console of IronPython, it works. However, if I use IronPython inside my C # code, then it does not put an exception "a module named xmlrpclib", is it a known issue? Any solution to solve this issue?   Here is the code:    var testcode = @ "import xmlrpclib; apiarver = xmlrpclib.ServerProxy ('address', allow_none = true); print APIServer.Hello () ; "; Mystream str = newest Mystream (); ScriptEngine Engine = Python. Cretegenine (); Engine. Retyme.io asset output (str, system text encoding. ASCII); Engine. Serial.io.setuperoutput (str, systemtext.edcoding.aspx); ScriptScope scope = engine.CreateScope (); ScriptSource src = engine.CreateScriptSourceFromString (testCode); Src.Execute (scope); Sorry for the silly question, it has come to know that there is a path used by IronPathon inside me.       The C # code was not correct. I ...






qt creator - QtCreator importing makefile projects -



    Have you ever tried importing Classic C ++ / project into Qt Creator?   Say that I wanted to use some libraries in my GUI project, which must be created. how can I do this?      In Qt Creator 2.0.1 you can import projects using only * * Cmake, * .creator, * .pro or * .qmlproject   Then switch to cmake and you can import the project into Qt builder (Welcome tab -> Open project ...).   Alex     






php - cURL Cookie and 307 redirect issue -



    I currently have a script that loads my client using curls on another server Currently, the settings    curl_setopt ($ CH, CURLOPT_RETURNTRANSFER, 1); Curl_setopt ($ CH, CURLOPT_FOLLOWLOCATION, TRUE); Curl_setopt ($ ch, CURLOPT_AUTOREFERER, true); Curl_setopt ($ ch, CURLOPT_USERAGENT, $ UserAgent); Curl_setopt ($ CH, CURLOPT_HEADER, 0); $ Usecookie = ROOT_PATH "/public_html/football_parser/cookie.txt"; If ($ usecookie) {if (! Is_writable ($ usecookie)) {return "$ usecookie can not write cookie file, change the file's permission to 777 or read only for windows."; } Curl_setopt ($ ch, CURLOPT_COOKIEJAR, $ usecookie); Curl_setopt ($ ch, CURLOPT_COOKIEFILE, $ usecookie); } $ Output = curl_xac ($ ch);    I'm trying to load two example URLs   statto.com/football/teams/newcastle-united/2005-2006/results   and   statto.com/football/teams/newcastle-united/2008-2009/results   Without a second load without any problems  curl_setopt ($ ch, CURLOPT_FOLLOWLOCATION, TR...








Powered by Blogger

Pat wiki

Search This Blog

tsql - How to store a list of items on a single column in SQL Server 2008 -

Comments

Post a Comment