SQL Server :: Database With Less Number Of Tables And More Columns

Sep 28, 2010

What would you all suggest a database with less number of tables and more number of columns or more number of tables with less number of columns. I am developing a web application using Visual stuio 2005 and Sql Server 2005

View 2 Replies


Similar Messages:

SQL Server :: Search Word In All Tables / Columns Of Database

Sep 15, 2010

I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.

View 2 Replies

DataSource Controls :: No Of Tables And Columns In Database?

Jun 15, 2010

I want to know that how many tables we can have in database and what is the maximum no. of columns.I also want to know the maximum size for each datatype.

View 3 Replies

ADO.NET :: How To Create A Table Which Is The Combination Of Different Columns In Database Tables

Jan 12, 2011

How to create a table which is the combination of different columns in database tables.

I know how to make the var table using single table.

What is I have to combine multiple coolumns and create a table.

My requirement is a gridview which has a datasource which is loading from columns from multiple tables.

View 13 Replies

Columns Of Two Related Database Tables In One GridView With EntityDataSource

Feb 17, 2010

I have two SQL Server tables with Primary Keys (PK) and a Foreign Key (FK) linking the two tables:

1) Table "Order"

OrderID, int, PK
AddressID, int, FK
...

2) Table "Address"

AddressID, int, PK
City, nvarchar(50)
...

Then I've created an (ADO.NET) Entity Data Model out of those two tables. Now on my (ASP.NET) webpage I put a GridView with an EntityDataSource. In my GridView I want to display two columns:

OrderID City (belonging to that order and linked by the AddressID-key) How can I do that? My problem is: When I configure the Entity Data Source I can select an "EntitySetName" which can be either "Order" or "Address" but not both, nor can I select any kind of relationship. If I select "Order" as EntitySetName
then in the GridView I can add the columns

OrderID
Address
Address.AddressID

Adding the column "Address" displays empty cells. Adding "OrderID" and "Address.AddressID" displays the expected IDs. But how can I add the "City" of the related address to my GridView? Edit: Clarification:

The Entity Framework has created a class "Order" and a class "Address" corresponding to the database tables. The class "Order" has a reference to an "Address" object as a navigation property, corresponding to the 1-n relationship between Address and Order table. Basically I want to have a column in my GridView which displays Order.Address.City. I have tried to add a bound field with "Address.City" as data field to the GridView but it results in a runtime error ("no such property...").

View 3 Replies

SQL Server :: Using BulkCopy To Map Columns In Tables

Nov 8, 2010

using sql server 2005 and vb.net 2005. I am writing a console application to import a mass amount of data from a non-sql database table into a sql server database table. The destination db table (sql server) has fewer tables than the source db table so I need to map the columns. does anyone have an example of how to do this?

View 1 Replies

SQL Server :: Add New Columns (with Data) To The Existing Sql Tables?

Jul 14, 2010

I have two sql tables.

- (Fields:PersonID, FirstName, LastName, Role, Department)

and

- (fields: PersonID, Unit).

I want to merge those with a single table ( Fields:PersonID, FirstName, LastName, Role, Department, Unit). How can I query to accomplish this so that same personID data go to same row ? ANY QUERY ?? (I have an idea : both export to excel and merge into a single excel file and import to SQL table but due to very long data it was truncated last time when importing so I don't want to reimport again.)

View 5 Replies

SQL Server :: Deny Access To A Number Of Tables?

Oct 18, 2010

I have set up a SQL Role and denied SELECT, INSERT, UPDATE, DELETE access to a number of tables.I noticed that a user in this role can create a stored procedure containing a SELECT, INSERT, UPDATE or DELETE statement on the table that I have denied access to.How could I stop the user in the role from being able to create/alter/execute stored procedure which use the tables than I have denied access to?Also, the user in the role needs to be able to execute stored procedure on the tables which they are not denied access to.

View 7 Replies

Trying To View Tables On Another Server Database?

Feb 17, 2011

I'm really not a database person, so forgive me if this question. I'm using visual studio 2008 and i am trying to view tables on another server database. Example

I have my aspnetdb.mdf database, and my anaylsis.mdf database. What i am trying to do within visual studio is read table colunms that are inside aspnetdb.mdf from anaylsis.mdf.

View 4 Replies

SQL Server :: Cannot Delete Tables From Database?

Jul 23, 2010

IDE: MS Visual Studio 2008 / SQL Server 2005 Express / SQL Server Management Studio Express 2005
Skills: BeginnerI was trying to delete a table from my database ASPNETDB.MDF ,that DB was previously used for User login information i made it by using asp.net built in login support by opening ASP.NET configuration ,but now i want to built my own simple login control...so i want to remove all the tables made by ASP.NET configuration.I got this error when deleting one of the table"Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FORIEGN KEY constraint"

View 7 Replies

SQL Server :: Select Column From All Tables In Database?

Sep 3, 2010

I want to retrieve the name and phone columns from all the tables in my database not in systables.

Ok this works but i dont want to get it from just the test table I want to get it from all the tables that I create

"USE mrpoteat SELECT name, phone FROM mrpoteat.dbo.test where name = name and phone = phone"

View 3 Replies

Sql Server - How To Customize The Membership Database Tables

Jun 21, 2010

I want to add custom columns to some tables created by ASP.NET. For example; I need to add two fields such as FirstName and LastName to the aspnet_Membership table.

I can add this directly by editing the table but;

Is this the right thing to do (I mean; extending the table directly) OR should I create a separate table and hold the extra user data, there?How can I see these custom database fields as properties in code completion? example: membershipuser.FirstName;

View 4 Replies

SQL Server :: Alter Tables Structure In Database?

Dec 28, 2010

i have one database named as sampleDB its having more than 100 tables. this database running on production. here we have one requirement need to add companyid feild all the tables in our sampleDb. is it possible to write query to alter all the table.

View 3 Replies

SQL Server :: Copy Tables From 1DataBase To Another DataBase?

Oct 28, 2010

I have a Table in SQL Server DataBase with 200 + Rows

OriginDest(OID, DID)

I want to Copy all the row from OriginDest Table, DataBase1. To OrginDest, DataBase2 with Same Name

View 4 Replies

SQL Server :: Use ASPNETDB.MDF To Add Own Tables Or Create A Separate Database?

Dec 6, 2010

I'm working on a new asp.net 4.0 resume web site. I'm starting off with SQL Server Express 2005 and using the standard security and login features given with ASPNETDB.mdf. My site will be hosted on GoDaddy.com.

Quesiton. Should the tables that will contain the information that users will be putting in like resumes, contact information and such go into ASPNETDB.mdf or should it go into a separate database.

View 2 Replies

ADO.NET :: Need To Query Atleast 35 Tables Using Linq To Sql(SQL Server Database?

Aug 27, 2010

I am a little new to this concept so bear with me.1) I need to query atleast 35 tables using linq to sql(SQL server database) . I am not able to add all the database entities in Linq to sql classes?

2)(View Model issue) When I use List<Reportcollection> and also List<Receipt> to convert the result then its giving an error that "Cannot convert list<anonymous> to list<string>"

View 6 Replies

SQL Server :: Database Tables / Have Lost A Bunch Of Memory?

Jan 19, 2011

I used to work in the IT field, but because of an accident and meds I have lost a bunch of my memory. So, I'm in need of relational database help..I've got a web site I want to put up that will sell books. I'll be using SQL server 2008. I'll be using Pay Pal's Cart, etc, so I just have to put up some buttons on the web site, but I need to track, display, etc, the books and properties about the books such as Authors, Paper back or hard cover, first edition, or something else, etc,..I have a table for books obviously, but I'm wondering if I should break out the Authors out of that table? I mean I don't see why except that if I end up with some books that have the same author then there names will be stored more than once, but I will be doing a lot more queries than inserts. I've got Customers, Book Types which is if the book is a hard cover, softcover, first edition, etc,. I will relate the Books to the Book Types of course, but again, should I have an authors table? Hope this makes sense.. I am using Visual Studio 2008 Pro, and want to do my relations there, so I thought I'd do so in the IDE if possible? I can't remember, but I thought it was possible?

View 6 Replies

SQL Server :: Query To Select Data From Multiple Tables And A Different Database?

Dec 1, 2010

Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.

My current statement is as follows (there are alot more fields but I have shortened it ):

SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........

View 4 Replies

SQL Server :: How To Copy A Database And Also Include New Columns

Feb 18, 2011

I am in a situation where, I have to copy a databse with records and also want to include new columns in it?

Or can I copy a db schema and later on include new cloumns and then copy a records from old database?

I am using SQL Server 2008 Enterprise Edition R2.

View 3 Replies

SQL Server :: Database Design / Create A Separate Table Which Will Contain The Translations For All 50 Tables?

Sep 28, 2010

I am working on a multi-lingual application Assume the following:

Database has 50 tables and application has to support 5 languages

Which is the best way to design the database:

1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)

2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.

Which is more efficient out of the above two.

View 3 Replies

SQL Server :: Returning A Certain Number Of Characters From A Database Entry

Feb 17, 2011

I have an entry from a database that has 500 characters. But when i display it i only want to return 200 charcters. How do I do that. I use Sql Server.

View 3 Replies

SQL Server :: Import All The Columns And Rows In An Excel File To A Database?

Aug 31, 2010

im using sqlbulkcopy to import all the columns and rows in an excel file to a database. My question is, if my database has 1 more extra column which i have to map it to a session variable and that extra column in the database is not found in the excel, isit possible to do something like dat?

View 3 Replies

C# - Create A Database That Can "add", "remove" And "edit" Tables And Columns?

Oct 19, 2010

What would be the best database/technique to use if I'd like to create a database that can "add", "remove" and "edit" tables and columns? I'd like it to be scaleable and fast. Should I use one table and four columns for this (Id, Table, Column, Type, Value) - Is there any good articles about this. Or is there any other solutions? Maybe three tables: One that holds the tables, one that holds the columns and one for the values?

Maybe someone already has created a db for this purpose? My requirements is that I'm using .NET (I guess the database don't have to be on windows, but I would prefer that)

View 1 Replies

ADO.NET :: Linq On Multiple Tables With Same Columns

Aug 17, 2010

I have a partitioned db where several tables have the exact same structure. I'm able to query the tables using linq, but only by quering the individual tables 1 at a time and by using the explicit table name. For example at the moment, I have 8 tables so I have something similar to the following:

[Code]....

Is there any way, that based on a certain value (stringValue), I could determine which table to query and then code the linq query just once?

View 2 Replies

ADO.NET :: Compare Columns In Two Data Tables

Dec 3, 2010

is there an easy way to compare two columns in two datatable to see if they match? I need to check if the values in column["x"] of datatable1 occur in column ["y"] of datatable2, without iterating through both tables (for each value in column of dt1, check column of dt2). I tried:

foreach (DataRow dr in dt1.rows)

if (dt2.rows.find(dr["x"]) but this checks the whole row and if finds an "x" in any column, "if" condition is true. I need to only check one column of dt2. Tables have different columns but the same primary column and that's what I need to check

View 10 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved