View Complete Post
Hello All experts there,
I need to insert some csv file data into sql server 2008. but there are multiple tables created in sql server and I need to check some conditions before data insertion and based on the condition value, sql script should insert the data in to specific table.
in other words I need to insert data from one csv file to different tables based on some condition.
is it possible? if yes then can anyone please give me an idea on how can we do that?
Thanks in advance
I need to know how to show top 30 records from four table
with fastest speed.. in ms sql server 2005..
hope You do the needfull
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;
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.
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.
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
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.
we are doing our cms migration. both cms's have their own articleID/contentID, we have a lookup table that contain the article URL and its content id. Now we want to query that table on every single click to get its respective id.
How and where i can implement this?