I need to test the counts shown in SSRS report. The report reads the counts from one of the tables.
I need to verify the counts shown in the report. For this I need to insert bulk records in the table (with different userid, datetime, etc).
How can I do this? I really don't want to do this manually.
i am using a trigger to insert records into my table2 when records inserted in table1 . i am using SSIS to insert records in table1 when inserting records in table1 i need to fire the trigger i created on table1 .But it is not firing . is that because of SSIS inserting bulk records into table1 at one time?. If so how i can fire my trigger and insert records into table2 from table1.
View 3 RepliesWhen i am inserting my data i am getting this error
An explicit value for the identity column in table 'emp' can only be specified when a column list is used and IDENTITY_INSERT is ON.
i have set Identitty specification and is identity of the table as yes so i am getting this problem whenevr i set it to no i am not getting any error,can anyone explain me why i am getting this error??
I have to insert a multiple records under the single table.So i have to execute the command in the frontend for every records.
Inorder to avoid i write the query like this
insert into table1(field1,field2) values('1','Test1'),('2','Test2');
and also i tried
insert into table1(field1,field2)
SELECT "1","Test1"
Union all
SELECT "2","Test2"
But I am getting syntax error.
How to insert a multiple records under the single query?
I have created table into database dynamicaly,while inserting records into that dynamic table i faced problem.
The name "STD000001" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. this error occured.
I created dynamic table by ,
declare @STUDENT_Table varchar(50)
set @STUDENT_Table = [dbo].[GetStudentTable](@SchoolID)
exec (@cmd)
[code]....
this stored procedure.....
Should i give any permission while creating dynamic table.
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesI have got a page in which there is a file upload option where I have to upload/import the csv file. What I want to do is to check if the correct format of file is uploaded for instance if any other than csv file is uploaded, the system should give an error message. Also what I need to do is to check certain fields of the csv file for instance there are some mandatory fields in the csv file which should be there like name , postcode, How can I check that these fields are not empty . After performing these task, the system should automatically upload the csv file onto the sql sever 2008.
View 3 RepliesNow i got it to work but the bulk copy is inserting the rows twice, instead of once
and i know the table has the correct rows because i can see it in the gridview correctly
I FIXED THIS PART
my program works fine when i run it in debug mode but not when i place it on the server, it doesnt run the stored procedure when i put it on my server.
[Code].....
This may not the best place for this question, but I'm going to give it a shot. I have a large (3GB) file that contains maybe 100 fields, CSV. ALL FIELDS are surrounded by double quotes, a standard CSV file. So, it looks like this:
"12345678", "SMITH", "JOHN", "GARLAND, TEXAS", "75043","","","","37" (and so on)
I need to import this into SQL server but have been unable to find any simple way of doing so using the BULK INSERT. I could obviously do it with some coding [a lot, given the number of fields] but one would think a product like MSSQL would have this most basic of functionality built in.
I have a database of members that I would like to add to a asp.net membership. The client records have no username or password currently, just a table with name and email. how I could do a bulk insert and give each client a username and password.
View 2 RepliesI need to update bulk values (more than 20000 each time) from my web form into sql server 2005 .I have a web page , from which when i click submitt button values from the form should be inserted . For that i tried normal method as shown below
[Code]....
But this is also slow (Adding to datatable make its slow I suppose ) .Is there any other method so that my insertion can be made faster .
I'm trying to import csv file that that uses double qoutes from the text qualifer but doesn't use any qualifiers for the numbers or null fields. The data looks like this:
1,"Jack","Smith",23,
2,"Susan","Smith",,
3,"Mike","Smith",,
2,"Chris","Smith", 18,
The command I'm using is:
[Code]....
I keep getting "Bulk load data conversion error (type mismatch or invalid character for the specified codepage)" when it tries to insert null from the csv into a numeric data type.
I tried changing the codepage, datafiletype, fieldterminator, formatfile but I still can't get it to work.
How can I load data from xml file into MSSQL Server using sql xml bulk load? I had try some code but when I ran my application, I encounter below error msg
"Retrieving the COM class factory for component with CLSID ...... failed due to the following error: 80040154"
How can I go about solving this?
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
I was wandering if I can make this faster. I am taking records out of Oracle and putting them into a SQL Server. btw, I am inserting into the Identity column
[Code]....
the application which i created is a web application which doesnt need much of a database,so i am just using the sql express free version which allows 4 gb of data,to avoid disasters iw ould like to delete records which are very old like,1 month,2 months old etc,how can i do this periodically should i do this on client side or the server side...
what id there are 100000 records and if we put this in page load or some method,it could take some time to delete,which i dont want..... how i can automate this process at the server side only
how to insert bulk data into Sql Server. Suppose I have a dataset contaning 5000 rows in it. I want to save all records to db. How it can be done and what can be best way for this.
View 2 Replieswhen i upload a file i need to insert the data into sql server data (file will be in comma separated with different extension .ord) in vb.net file will be stored on server in a folder
View 3 RepliesI am using VWD 2010 with SqlServer 2008. I would like to make an exact copy of my database for testing purposes only so I can test my site before I publish it, make sure everything works so I do not have to reset any tables in my main db.
View 1 RepliesMy application works locally, but when I upload it to my remote server some of the components do not work. If I use the microsoft chart control it blows the hole page up and it works locally. Does anyone know how to test stuff locally that would be exactly like what is on the remote server? I think it has to do with my hosting service. How could you test if this was true? Just upload to another remote server?
View 2 RepliesI have data in database and that database is in the ip address .this ip address includes the data when i run the application it will give me all records but after the publish it will show me less data.
View 1 RepliesI want some tips regarding sending mail ,I want to send bulk mail from my web application in c#. so ,what should be the best code for this and also what should be the best configuration used in the smtp server. because my current system fails to send 100 mails out of 400 mails in smtp server. I aslo used theading for sending this mail in batch of 30 mails in every 20 minute but it is not working . I want solution of both in my c# code and smtp and also is there any new solution in new technology like web services or any other option .
View 1 RepliesI want to Upload bulk images from client to server using web service...
I already create web service for uploading images but it does not support well.. i have used byte array for that..
I am new to Wordpress so what I did was to setup up everything through Microsoft Webmatrix. Everything installed find for my Local Host Server. As long as I load up the Webmatrix program first I can put the "localhost" adress in my browser and my Wordpress theme will load up fine. The next step I did was to try to edit my theme via Dreamweaver CS5. I followed all the Adobe on-line instructions for setting everything up. Nevertheless when I press the live view button Dreamweaver keeps asking for the Texting Server which I thought I already had setup. I pointed the "testing server" folder to the same folder as Wordpress (where the theme is also located via "My Websites." Everything else seems to work and I followed all the instructions given by Adobe. See: [URL] Nevertheless when I press the Live View button Dreamweaver keeps begging for the teasting server. I have the "server model" set to PHP MySQL.
View 5 RepliesI need a book to recommend strategies for load-testing an ASP.NET application with SQL Server backend.Some info that may be useful:how to write a load test planwhat perfmon counters to use andtypical threshold valuesfinding bottleneck various load testing tools
View 2 Replies