View Complete Post
I have multiple apps running which access a sql server database. I had initially a table set aside for each app but now I was told to put everything into one table and have all apps access the database. I just want to make sure that just changing my connection string for all apps will suffice and that I do not have to make any other changes for all apps to write to one table. Will this be ok? The apps are writing to the database table which has a unique index on one column and a auto incremented primary id key. I changed the stored procedures I had for each app since the connection strings were the same as they access the same database. Just want to make sure there will be no conflict issues when each tries to write to the same table. None of the apps will be querying the table at any time except when I run manual queries myself.
Greetings
i wana know how can i export data from a table to access through a sql job
i am using sql server 2008 and office 2007
thnx
Using SQL Server 2008:
We have a main database - MAIN. For monthly data extracts, I create new tables with relevant data in another database called EXTRACT.
I use SELECT INTO statements to create the tables in the EXTRACT schema. How do I preserve the primary key constraints in the EXTRACT tables? Do I need to write separate queries to set them?
I use SELECT INTO statements to create the tables in the EXTRACT database. How do I preserve the primary key constraints in the EXTRACT tables? Do I need to write separate queries to set them?
I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -
public bool BulkEnterData(DataTable dt, string tblName) { SqlBulkCopy bulk = new SqlBulkCopy(con); bulk.DestinationTableName = tblName; con.Open(); bulk.WriteToServer(dt); con.Close(); return true; }
ERROR Getting-A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
How to resolve the above problem or any other solution is available.
Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.
Julie Lerman
MSDN Magazine August 2010
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
Bob Beauchemin
MSDN Magazine August 2009
There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.
MSDN Magazine May 2009
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.
Kayode Dada
MSDN Magazine April 2002
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
Michael McManus
MSDN Magazine June 2000
I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.
Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.
Regards, thanks for help.
Hello,
I have 2 tables, master, detail. 1.master table have fields (id, username, plan)-->id is primary key (PK) 2. detail table have fields (srNo,id, worksummary, ... )--> srNo is PK.
I have created foreign key relationship from detail to .master table for "id" field.
the code is:
IList<detail> objDetail=new List<detail> (); IList<master> objMaster = new List<master> ();string[] sarray = queryFields.Split('|');// for (int i = 0; i < sarray.Length; i++){ string[] sfields = sarray[i].Split(','); if (sfields[0] != "") { objDetail.Add(new _detail { Id = count , modify = sfields[1].ToString(), verified = sfields[2], I}); } }
I have problem to add fields in "objDetail" using Add method. But I am unable to access the reference field "Id" , rest of the field of detail table can be accessed using objDetail.
How can I access the "Id" field from objDetail object to add in IList.
I want to solve this problem
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend