Could anyone suggest me good books for Data modeling and RDBMS?
Geethalakshmi
Posts
-
Book on Data Modeling -
Question [modified]VS 2005 installs SQL Server 2005 EXPRESS as part of default installation.
-
A query on Database designHi all, I have created a database for my application. One of the tables manages the employees data. It has got 2 columns listing primary skillset and secondary skill set (free text to give a summary of skillsets). Both these columns are optional. It is basically aimed at capturing skillsets of employees in a department but could be extended to all. Now, what comments I receive from some of team members is that these skillsets columns being optional should be placed in a different table with a link to employee_master. Should I do this really? If so, why should I? How does this improve the existing design? What is wrong with having it all in a single table? Thanks in advance,
-
SQLDatasource with multiple controlparameters for select commandI would like to introduce myself as ASP.Net 2.0 beginner. I face a problem when using gridview and sqldatasource. Problem: Initially I tried using the SQLDatasource control and Gridview with one parameter in the select query. I made that parameter as a control parameter and set the autopostback of the control. Everything worked fine. Now I want to have multiple control parameters set for one SQLDatasource and GridView combination (It is basically a kind of search screen and the procedure for select command has so many parameters). I have created all the properties for these controls. But getting stuck with how to trigger the retrieval process. If it is one control, I used the autopostback and ASP.Net did the rest. Now that I have to manually trigger the retrieval of data and the binding on a search button click, am getting stuck. This is an urgent requirement and Could you please help??? Thanks Geetha
-
sp with temptables doesnt work in crystal reports