Inserting Data Into SQL Server
Jun 1, 2000
declare @counter int
select @counter=300000
while @counter > 0
begin
insert into Revenue (Instr_type, Tel_no, Phone_Id, Rpt_date, Pay_mode)
values("PP0073", @counter, "080464", "19990901", 1)
select @counter=@counter-1
end
HI there,
I run the above statement in Query Analyzer and the expected result should be 300,000 records inserted into Revenue table. But unfortunately the actual records inserted were less than 300,000. I also realise that it insert different amount of record each time I run it. Can anyone please tell me why?
Thanks,
Will
View 2 Replies
ADVERTISEMENT
Nov 11, 2014
I have 2 tables in my database.
one is Race table and 2nd one is Age Range.
I want to write a query where I can see all races and age range as column.
TblRace
ID, RaceName
TblAgeRange
ID,AgeRange.
There is no connection between this two table. I need to display result like below.
Race 17-20 21-30 31-40
A
B
I
W
How do i get this kind of empty data set so that I can fill it out in front end or any better solution. The age range will be displayed as many row as they have. It's not static. Above is just an example.
View 1 Replies
View Related
Oct 8, 2007
I am trying to transition from Access to MS SQL. I downloaded and installed MS SQL 2005 Express and the Server Management Studio Express. Keep in mind that I am a total newbie to this database since I've always used Access. My question is, how do I insert data manually into my tables? I figured out how to set up a table and query a table, but is there somewhere I can just plug in data? In Access, I just open the table and type it in. Also, how do you set an auto increment numeric field in a table?- Jason
View 4 Replies
View Related
Jan 21, 2001
Hi...
I have some problems with inserting data from one SQL Server to another SQL Server in a scheduled time...
Please help me......
Eva
View 1 Replies
View Related
Sep 22, 2000
Hi, Everybody:
Could anyboby please tell me any way which can quickly inserting large data to SQL Server except using cursor?
Every morning, I use DTS to transfer around 100,000 data from foxpro to SQL Server 7.0 temporary table. Then I use cursor to check if the data already exist in the SQL Server table, then I do update; if the data does not exist in the SQL Server table, then I do insert into. In SQL Server database, each table already has over million record, also I have 12 table with the same situation.
Now I find cursor very slow to do above, can anybody tell me any way which can quickly to do update and insert?
Thank you very much.
View 3 Replies
View Related
Jul 16, 2007
Hello all,
I'm using sqlserver 2005 express edition. I'm working in an application which has the functionality of inserting datas from the excel file to sql server 2005 database.
Can anyone please guide me for performing this task.
Thanks in advance.
Ravirajdanasekaran
View 1 Replies
View Related
Mar 12, 2008
Hi,
Just look at my Code:protected void Button1_Click(object sender, EventArgs e)
{SqlConnection Conn = new SqlConnection("MyConnectionString");
SqlCommand Cmd = new SqlCommand();string linktext,headline, quote, para1, para2, para3;
linktext = this.TextBox1.Text;headline = this.TextBox1.Text;
quote = this.TextBox2.Text;para1 = this.TextBox3.Text;
para2 = this.TextBox4.Text;para3 = this.TextBox5.Text;Cmd.CommandText = "insert into desieyenews(linktext,newsheadline,quote,para1,para2,para3) values ("+linktext+","+headline+","+quote+","+para1+","+para2+","+para3+")";
Cmd.Connection = Conn;
Conn.Open();
Cmd.ExecuteNonQuery();
Conn.Close();
}
Details: In the above code I am inserting data from 5 textbox to my databse. It works fine but when I am trying to insert text like Tom's..., problem occurs. Whenever I am trying to insert some text with a single quote, the problem arises. Although the datatype of my database is text in MS SQL Server 2005.
Please give me some solution so that I can get rid of this problem....
Thanks in advance.
Tapas
View 4 Replies
View Related
Oct 23, 2006
Hi everyone!Hope that someone can help me solving this problem.I have a form where the user can register by putting his private data. Each time that he submits his data, if he is using Internet Explorer, it will insert blank data into sql server database. But if user is using Firefox, everything is working well, and all data is inserted.What seems to be the problem?Why in IE, data is inserted as blank?!Thanks for your possible help and attention to this issue.Hope that someone can help me.Best regards,Mesk
View 2 Replies
View Related
May 31, 2007
hi
I want to read data from XML file and insert that data from XML file into the Database Table From ASP.NET page.plz give me the code to do this using DataAdapter.Update(ds)
View 1 Replies
View Related
Mar 21, 2004
Tryinna insert a new row
This is my code:
Dim myConn As SqlConnection
Dim mycmd As SqlCommand
myConn = New SqlConnection("Initial Catalog=science;" & _
"Data Source=localhost;Integrated Security=SSPI;")
mycmd = New SqlCommand("INSERT into STEP1(firstname) VALUES('Amin')", myConn)
myConn.Open()
mycmd.ExecuteNonQuery()
myConn.Close()
This is the error message I get:
The name 'firstname' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
View 9 Replies
View Related
Jan 8, 2008
I am wanting to insert the data from a table in access into a table in an SQL database. I am using VB.Net 2005.
Any idea's, cheers, Darren.
View 5 Replies
View Related
Oct 23, 2006
Hi All,
I am manually replicating parts of a SQL Server CE database (running windows mobile 5.0) to a centralized SQL Server 2000 database.
My program is throwing an exception whenever I try to insert an image data type into the 2000 server from the PDA. I am using parameterized queries.
Error is as follows:
[error]
System.Data.SqlClient.SqlConnection.OnError()
at
System.Data.SqlClient.SqlInternalConnection.OnError()
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at
System.Data.SqlClient.TdsParser.Run()
at
System.Data.SqlClient.ExecuteReader()
at
System.Data.SqlClient.ExecuteNonQuery()
at
PDASync.Database.ExecuteIDRemote()
[/error]
The code for my ExecuteIDRemote method works fine for other queries. It also works if I remove the image column from the offending query.
Does anyone have any suggestions? Thanks.
View 1 Replies
View Related
Dec 19, 2007
Hi to all..
I am new to ASP.Net, I want coding for inserting data in to SQL server 2005 that code contain the following criteria.
1.ASP.Net using C#.Net.
2.Using Stored Procdure.
3.the connetion string ,command , Data reader is in the same class. this class will be reusable for other page also without modifying any thing in it.
Please Help me.
Advance thanks.
View 2 Replies
View Related
Feb 2, 2008
Hi,
I have a scenario where I want the current User to add details regarding their house in to my 'Property' table in my database and also store their uploaded picture in the same tabe when they press the 'Add Property' button. I also want to store the current Users ID in the 'Property' table so the property being added is assigned to the current user. Can anyone help me with the implementation of this? Here is the code I have so far:
property.aspx page:
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<span style="font-size: 16pt; font-family: Bradley Hand ITC"><strong>Add Property</strong></span><table style="border-right: silver 3px outset; border-top: silver 3px outset; left: 337px;
border-left: silver 3px outset; border-bottom: silver 3px outset; position: relative;
top: 9px">
<tr>
<td colspan="2">
<strong><span style="font-size: 14pt; font-family: Bradley Hand ITC">
Address</span></strong></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="TownLabel" runat="server" Font-Bold="False" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Town:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="TownTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="CityLabel" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="City:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="CityTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="CountyLabel" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="County:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="CountyTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="CountryLabel" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Country:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="CountryTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="PostcodeLabel" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Postcode:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="PostcodeTextBox" runat="server"></asp:TextBox></td>
</tr>
</table>
<asp:Button ID="AddButton" runat="server" Text="Add Property" style="left: 378px; position: relative; top: 66px" /><tablestyle="border-right: silver 3px outset; border-top: silver 3px outset; left: 648px;
border-left: silver 3px outset; border-bottom: silver 3px outset; position: relative;
top: -190px">
<tr>
<td style="width: 186px">
<span style="font-size: 14pt; font-family: Bradley Hand ITC"><strong>Property Description</strong></span></td>
</tr>
<tr>
<td style="width: 186px">
<asp:TextBox ID="DescriptionTextBox" runat="server" Height="172px" Width="233px" TextMode="MultiLine"></asp:TextBox></td>
</tr>
</table><asp:FileUpload ID="PropertyPicture" runat="server" Style="left: 356px; position: relative;
top: -214px" />
<asp:SqlDataSource ID="AddProperty" runat="server" ConnectionString="<%$ ConnectionStrings:My Property PortfolioConnectionString %>"ProviderName="<%$ ConnectionStrings:My Property PortfolioConnectionString.ProviderName %>"
InsertCommand="INSERT INTO Property(User_ID, Property_type, Property_Name, Number_of_Rooms, Sleeps, Town, City, County, Country, Postcode, Description, Facility1, Facility2, Picture)
VALUES (@User_ID, @Property_type, @Property_Name, @Number_of_Rooms, @Sleeps, @Town, @City, @County, @Country, @Postcode, @Description, @Facility1, @Facility2, @Picture)">
<InsertParameters>
<asp:SessionParameter Name="User_ID" />
<asp:ControlParameter ControlID="TypeDropDownList" Name="Property_type" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="PropertyNameTextBox" Name="Property_Name" PropertyName="Text" />
<asp:ControlParameter ControlID="NoOfRoomsDropDownList" Name="Number_of_Rooms" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="SleepsDropDownList" Name="Sleeps" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TownTextBox" Name="Town" PropertyName="Text" />
<asp:ControlParameter ControlID="CityTextBox" Name="City" PropertyName="Text" />
<asp:ControlParameter ControlID="CountyTextBox" Name="County" PropertyName="Text" />
<asp:ControlParameter ControlID="CountryTextBox" Name="Country" PropertyName="Text" />
<asp:ControlParameter ControlID="PostcodeTextBox" Name="Postcode" PropertyName="Text" />
<asp:ControlParameter ControlID="DescriptionTextBox" Name="Description" PropertyName="Text" />
<asp:ControlParameter ControlID="Facility1DropDownList" Name="Facility1" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="Facility2DropDownList" Name="Facility2" PropertyName="SelectedValue" />
<asp:Parameter Name="Picture" />
</InsertParameters>
</asp:SqlDataSource>
<table style="left: 12px; position: relative; top: -411px; border-right: silver 3px outset; border-top: silver 3px outset; border-left: silver 3px outset; border-bottom: silver 3px outset;">
<tr>
<td colspan="2">
<strong><span style="font-size: 14pt; font-family: Bradley Hand ITC">
Property Details</span></strong></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="PropertyName" runat="server" Font-Bold="False" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Property Name:" Width="101px"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="PropertyNameTextBox" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="NoOfRooms" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="No of Rooms:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:DropDownList ID="NoOfRoomsDropDownList" runat="server">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
<asp:ListItem>6</asp:ListItem>
<asp:ListItem>7</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="Sleeps" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Sleeps:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:DropDownList ID="SleepsDropDownList" runat="server">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
<asp:ListItem>6</asp:ListItem>
<asp:ListItem>7</asp:ListItem>
<asp:ListItem>8</asp:ListItem>
<asp:ListItem>9</asp:ListItem>
<asp:ListItem>10</asp:ListItem>
<asp:ListItem>11</asp:ListItem>
<asp:ListItem>12</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="Type" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Type:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:DropDownList ID="TypeDropDownList" runat="server">
<asp:ListItem>Bungelow</asp:ListItem>
<asp:ListItem>Appartment</asp:ListItem>
<asp:ListItem>Flat</asp:ListItem>
<asp:ListItem>Studio</asp:ListItem>
<asp:ListItem>Cottage</asp:ListItem>
<asp:ListItem>House</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="Facility1" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Facility 1:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:DropDownList ID="Facility2DropDownList" runat="server">
<asp:ListItem>Air conditioning</asp:ListItem>
<asp:ListItem>Dishwasher</asp:ListItem>
<asp:ListItem>En-suit</asp:ListItem>
<asp:ListItem>Garage</asp:ListItem>
<asp:ListItem>Garden</asp:ListItem>
<asp:ListItem>Internet</asp:ListItem>
<asp:ListItem>Pool</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td style="width: 100px"><asp:Label ID="Facility2Label" runat="server" Height="23px" Style="vertical-align: middle;
text-align: right; font-family: 'Goudy Old Style';" Text="Facility 2:" Width="97px"></asp:Label></td>
<td style="width: 100px">
<asp:DropDownList ID="Facility1DropDownList" runat="server">
<asp:ListItem>Pool</asp:ListItem>
<asp:ListItem>Air conditioning</asp:ListItem>
<asp:ListItem>Dishwasher</asp:ListItem>
<asp:ListItem>En-suit</asp:ListItem>
<asp:ListItem>Garage</asp:ListItem>
<asp:ListItem>Garden</asp:ListItem>
<asp:ListItem>Internet</asp:ListItem>
</asp:DropDownList></td>
</tr></table>
</asp:Content>
property.aspx.vb page:Partial Class Default2
Inherits System.Web.UI.PageProtected Sub AddButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddButton.Click
AddProperty.Insert()End Sub
End Class
Many Thanks
View 2 Replies
View Related
Mar 30, 2007
Hello all,
I am having problems running a stored proc from an aspx.cs file. Basically I want to extract data from webForm controls and create a new record in a DB table. I have watched the "Getting Started" videos on thi site, and the only difference between my code and the code of the demonstrator is the connection string. My conn string:- dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;Demonstrator conn string:- dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings("ProjectTblConnString");When I debug with the string as shown by the demonstrator the error list reports that ConnectionStrings is a property and I am trying to use it as a mothod, which is fair enough, but I am just confused as how it worked for the demonstrator and not myself. When I debug with the code I used above I get no error, but nothing is inserted in the DB.Also, it looks as if the only class in my aspx.cs file that is actually being executed is PageLoad() - the remainder of the code seems to be ignored. Below is the entired aspx.cs file:- 1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11
12 public partial class CreateProject : System.Web.UI.Page
13 {
14 protected void Page_Load(object sender, EventArgs e)
15 {
16
17 if (User.Identity.IsAuthenticated == false)
18 {
19 Server.Transfer("Default.aspx");
20 }
21
22 if (chkbox_startDate.Checked == true)
23 {
24 txtbox_startDate.ReadOnly = true;
25 txtbox_startDate.Text = (System.DateTime.Now.ToString());
26 }
27
28 }
29
30 protected void btn_create_Click(object sender, EventArgs e)
31 {
32 //connection string for connecting to SQL Server DB
33 SqlDataSource dataSrc = new SqlDataSource();
34 dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;
35
36
37 //insert data in table using the CreateNewProject stored proc in the DB
38 dataSrc.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
39 dataSrc.InsertCommand = "CreateNewProject";
40 dataSrc.InsertParameters.Add("Project_Title", txtbox_title.ToString() );
41 dataSrc.InsertParameters.Add("Description", txtbox_desc.ToString() );
42 dataSrc.InsertParameters.Add("Start_Date", txtbox_startDate.ToString() );
43 dataSrc.InsertParameters.Add("Primary_Dev_Lang", list_devLang.ToString() );
44 dataSrc.InsertParameters.Add("Dev_Environment", list_devEnv.ToString() );
45 dataSrc.InsertParameters.Add("No_Junior_Devs", txtbox_juniorDevs.ToString() );
46 dataSrc.InsertParameters.Add("No_Senior_Devs", txtbox_seniorDevs.ToString() );
47
48 int rowsAffected = 0;
49 try
50 {
51 rowsAffected = dataSrc.Insert();
52 }
53 catch (Exception ex)
54 {
55 Server.Transfer(Error.aspx);
56 }
57 finally
58 {
59 dataSrc = null;
60 }
61
62 if (rowsAffected != 1)
63 {
64 label_confirm.Text = "Error, Contact system admin";
65 }
66 else
67 {
68 label_confirm.Text = "Success";
69 }
70
71 }//end btn_create
72
73 //if cancel is clicked set all values back to default
74 protected void btn_cancel_Click(object sender, EventArgs e)
75 {
76 txtbox_title.Text = "";
77 txtbox_desc.Text = "";
78 txtbox_startDate.Text = "";
79 txtbox_seniorDevs.Text = "";
80 txtbox_juniorDevs.Text = "";
81 list_devEnv.SelectedIndex = 0;
82 list_devLang.SelectedIndex = 0;
83 chkbox_startDate.Checked = true;
84 label_confirm.Text = "";
85 }
86
87 //if checked the current dateTime is inserted into txtbox
88 protected void chkbox_startDate_CheckedChanged(object sender, EventArgs e)
89 {
90 if (chkbox_startDate.Checked == true)
91 {
92 txtbox_startDate.ReadOnly = true;
93 txtbox_startDate.Text = (System.DateTime.Now.ToString());
94 }
95 else
96 {
97 txtbox_startDate.ReadOnly = false;
98 txtbox_startDate.Text = "";
99 }
100 }//end chkox
101
102
103 }//end class
Any help anyome can give is greatly appreciated. This is part of my Final Year College Dissertation which is due in 3wks !!!!
Sláinte á chaire,
Seán
View 2 Replies
View Related
Nov 26, 2007
Hi Friends,
I am Ravi, I need a help.
My case is like.. i need to upload data from csv file into sql server 2005 data table.
but before that I need to check integrity of data
for example:
let us say csv data is like
ISD CODE,STATE,NAME,QUALIFICATION
91,AP,KIRAN,MCA
01,MC,MIKE,MS
here i have to check that, wether there is an entry in ISD codes table for 91 and 01 (india and us)
similarly AP , MC (Andhra Pradesh and MISSICippi)
please suggest me a nice approach, no of records in ISD codes and States will 350-450 records.
thanks in advance
Ravi K
View 3 Replies
View Related
Oct 15, 2007
Hi All,
I am working on SQL Server 2000 ver 7.0. The Collation set for my Database Server is Latin.
I want some way by which i can insert Japanese Characters in Database. Is it related to change the Collation or any other encoding format of database.
Suppose the table 'Person' has fields id, Name, city
If i enter name in a japanese characters, then while storing it does not recongnises this format.
insert into person values(8,'満員','osaka')
id name city
8 ?? osaka
At the place of name '??' is displayed.
Please sugggest me a solution for this.
Thanks in Advance Manohar
View 11 Replies
View Related
Mar 19, 2015
From my query I am getting results like below in one of the column:
'immediate due 14,289.00
04/15/15 5,213.00
05/15/15 5,213.00
06/15/15 5,213.00
07/15/15 5,213.00
08/15/15 5,213.00
09/15/15 5,213.00
10/15/15 5,213.00
11/15/15 5,210.00'
this same type of many rows are there (i just mentioned one) but having same pattern with tabs as delimiter in between dates and amount.
I need something that shows Date on one side representing particular amount on the other
For Immediate Due it will be current date and the amount besides it.
how can I achieve this.
View 8 Replies
View Related
Nov 11, 2015
Is it possible to force row level locking in Sql server 2015 before inserting the data and release the same afterwords..find the code for which we would like to impliment the same
DECLARE @TravelAgentid Varchar(20)
DECLARE @Date DATETIME2(7)
DECLARE @InsDate DATETIME2(7)
set @TravelAgentid ='A101'
[code]....
View 11 Replies
View Related
Dec 10, 2005
4 Layered Web Application for Inserting data into a database using sql server as the back end and a web form as the front end using C# .
Can someone provide with code as I am new to this architecture and framework.
Better send email.
Thanks In Advance,
A New Bie
View 1 Replies
View Related
Nov 14, 2006
hi guys!
i have this task to do, well lets say i have a DB in a Server lets say Server1 and i want to copy or insert this data to the Server2.
Is there any easy way to do this? copying the Keys automaticly? What is the best way to copy the data?
Thanks a lot. novelle
View 6 Replies
View Related
May 28, 2008
Dear all,
we have tables with many image columns. We fill these image columns via ODBC and SQLPutData as described in MSDN etc (using SQL_LEN_DATA_AT_EXEC(...), calling SQLParamData and sending the data in chunks of 4096 bytes when receiving SQL_NEED_DATA).
The SQLPutData call fails under the following conditions with sqlstate 08S01
- The database resides on SQL Server 2000
- The driver is SQL Native Client
- The table consists e.g. of one Identity column (key column) and nine image columns
- The data to be inserted are nine blocks of data with the following byte size:
1: 6781262
2: 119454
3: 269
4: 7611
5: 120054
6: 269
7: 8172
8: 120054
9: 269
The content of the data does not matter, (it happens also if only zero bytes are written), nor does the data origin (file or memory).
All data blocks including no 7 are inserted. If the first chunk of data block 8 should be written with SQLPutData the function fails and the connection is broken. There are errors such as "broken pipe" or "I/O error" depending on the used network protocol.
If data no 7 consists of 8173 bytes instead of 8172 all works again.
(Changing the 4096 chunk size length does not help)
Has anybody encountered this or a similar phenomenon?
Thank you
Eartha
View 7 Replies
View Related
Nov 24, 2006
hi there!
Well i have two Servers on this two Servers i have the Database with the same Tables. But the Database in the Server_2 consists no data, I want to fill the Tables in Server_2 from the Data in Server_1.
What i want to do is to is liked this.
-- I performing this on the second Server.
SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] ON
INSERT INTO [Database].[user].[Table]({COLUMN_NAMES})
SELECT *
FROM [Server_1].[Database].[user].[Table]
WHERE id=25
SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] OFF
This did not work and i have the following Error Message its in German but the ERRORCODE is 7391. I already check out the help section in MSDN but it doesnt really helps... Any Ideas? Thanks
Die Operation konnte nicht ausgeführt werden, da der OLE DB-Provider 'SQLOLEDB' keine verteilte Transaktion beginnen konnte.
[OLE/DB provider returned message: Die neue Transaktion kann im angegebenen Transaktionskoordinator nicht eingetragen werden. ]
OLE DB-Fehlertrace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
View 15 Replies
View Related
Oct 10, 2007
I am trying to insert data into two different tables. I will insert into Table 2 based on an id I get from the Select Statement from Table1.
Insert Table1(Title,Description,Link,Whatever)Values(@title,@description,@link,@Whatever)Select WhateverID from Table1 Where Description = @DescriptionInsert into Table2(CategoryID,WhateverID)Values(@CategoryID,@WhateverID)
This statement is not working. What should I do? Should I use a stored procedure?? I am writing in C#. Can someone please help!!
View 3 Replies
View Related
Feb 23, 2015
I am trying to insert bulk data into main table from staging table in sql server 2012. If any error comes, this total activity is rollbacked. I don't want that to happen. I want to know the records where ever the problem persists, and the rest has to be inserted.
View 2 Replies
View Related
Jan 22, 2001
Hi everybody,
In our datbase we have a table with text data type.Help me if anybody knows how to insert text data into text data type of sql server.
i am able to modify and retrive but i am not able to insert text. please if u have idea, please give me reply asap.
Thanks,
Giri
View 1 Replies
View Related
Sep 17, 2004
I have some website work lined up and it involves some simple modifications to a MS SQL 2000 server. What I'll need to do is add some new data fields and insert some data.
I have some experience with databases - MS Access and MySQL, but I have never used or seen MS SQL 2000. My question is, is this a relatively simple thing to do for someone who hasn't used it before? I can do these things quite simply in Access or MySQL, so is MS SQL 2000 going to be any different?
Also, does anyone know of any free tutorials online that would help me out?
Thanks
View 1 Replies
View Related
Aug 7, 2007
Hello friends....
I am looking for 2 things(using c#.net or vb.net and sql svr 2000)
1.convert data from sql server 2000 database (say customers table from northwinds database) to a text file(separated by commas or just plain space)
2.Insert the data from text file back to database.
Can someone pls give me the detailed code to achieve this....really need this on urgent basis.......Thank You.
View 10 Replies
View Related
Sep 11, 2006
Hi,I m using Microsoft Visual Studio 2005 and SQL server 2000. I have 2 textboxes and a button, what i wanna do is, when i hit the button, the values in textboxes should be inserted into DB. Would you please help me? Thanks in advance.
View 1 Replies
View Related
May 5, 2007
Hi friends,I have one text box on my form.i need to insert the data from tat text box to DB without clicking on any button.Now i have written the code under text changed event of that text box.So it is inserting whenever i click on that form.Besides this i need to insert data when i close tat window.But it is not inserting when i close tat window.Plse help me.Thanks in advance
With RegardsLijo Rajan
View 1 Replies
View Related
Jun 6, 2007
I have created a form with several fields etc and validation.
After pressing the submit button i have a
if Page.IsValid then .....etc
But in this then bit I want to do a
INSERT the form details to the db.
I have done inserts etc via gridView etc but I just need a form that lets someone enter info and submit etc, so do not now where to or how to place this code to connect then insert etc
thanks
View 3 Replies
View Related
Dec 6, 2005
Hi all,
I'm having a problem saving the information from my web form into my sql database when I clicked on the 'Submit' button.
This is the error message
Server Error in '/Helpdesk' Application.
ExecuteNonQuery: Connection property has not been initialized.
I've attached my code below. Please advise me on what is wrong... How should I initialise the ExecuteNonQuery.
========= start code ====================
Dim MySQL As String
MySQL = ""
Dim MyConn As SqlConnection = New SqlConnection()
Dim MyCmd As SqlCommand = New SqlCommand()
MyConn.ConnectionString = "Server=ESAWEB2;Database=Helpdesk;Trusted_Connection=True;"
MySQL = "INSERT INTO TBL_TROUBLE_TICKET (Priority) values (' ddlpriority ')"
MyConn.Open()
MyCmd.ExecuteNonQuery()
MsgBox("Record Inserted")
=======end code ===============
View 1 Replies
View Related
Mar 27, 2006
I am not looking for free code but this is driving me out of my mind. I'm a pretty proficient PHP programmer and have been dealing with a form that I was made to program in ASP.Net due to my employer's preferences. I can't attach the code for the form so I have cut and pasted it below. I am needing to know whow do I code this so that the data will go into a MS SQL 2005 database? I already have some coding in it but I don't know if it's correct and any help in getting this fixed would be great as it is slowly driving me up the wall. Thanks!
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Button_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim conebackups As SqlConnection
Dim strInsert As String
Dim cmdInsert As SqlCommand
conebackups = New SqlConnection("Server=localhost;UID=sa;pwd=kitten33;database=ebackups")
strInsert = "INSERT cust_info ( cust_name, cust_contact, cust_phone, cust_analyst, install_date, cust_username, cust_password, account_request_type, quickbooks_check, peachtree_check, mssba_check, goldmine_check, act_check, mail_info, db_info, mapped_info, mobile_data, mail_option, db_option, mapped_option, mobile_option, backupexec_option ) Values ( 'cust_name, 'cust_contact', 'cust_phone', 'cust_analyst', 'install_date', 'cust_username', 'cust_password', 'account_request_type', 'quickbooks_check', 'peachtree_check', 'mssba_check', 'goldmine_check', 'act_check', 'mail_info', 'db_info', 'mapped_info', 'mobile_data', 'mail_option', 'db_option', 'mapped_option', 'mobile_option', 'backupexec_option' )"
cmdInsert = New SqlCommand(strInsert, conebackups)
conebackups.Open()
cmdInsert.ExecuteNonQuery()
conebackups.Close()
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Weston Backup Questionnaire</title>
<script language="javascript" type="text/javascript">
</script>
</head>
<body>
<form id="westonquest" runat="server">
<div>
<div style="border-left-color: black; border-bottom-color: black; border-top-color: black;
text-align: center; border-right-color: black" title="Weston Backup Questionnaire">
<table>
<tr>
<td colspan="3" style="width: 540px; height: 30px; text-align: center">
<span style="font-size: 14pt; font-family: Verdana">Weston Online Backup Questionnaire</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 10px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Please fill out the following information
as accurately as possible. Any incorrect information may affect the customers online
backup in a serious manner. All of the following fields require an answer before
you can submit the form.<br />
</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px">
<br />
<span style="font-size: 14pt; font-family: Verdana">Customer and Analyst Information</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Customer Name:<br />
</span>
<asp:DropDownList ID="cust_name" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="232px" DataSourceID="SqlDataSource1" DataTextField="cust_name" DataValueField="cust_name">
<asp:ListItem>Select Customer Name.....</asp:ListItem>
<asp:ListItem Value="WestonANC">Weston - ANC</asp:ListItem>
<asp:ListItem Value="WestonBND">Weston - BND</asp:ListItem>
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ebackupsConnectionString %>"
SelectCommand="SELECT [cust_name] FROM [backup_info]"></asp:SqlDataSource>
<span style="font-size: 8pt; font-family: Verdana">
<br />
<br />
Customer Contact:
Customer Phone Number:<br />
<asp:TextBox ID="cust_contact" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="190px"></asp:TextBox>
<asp:TextBox ID="cust_phone"
runat="server" Font-Names="Verdana" Font-Size="X-Small" Width="146px"></asp:TextBox><br />
<br />
Analyst:
Today's Date: (mm/dd/yyy format)<br />
<asp:DropDownList ID="cust_analyst" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="162px">
<asp:ListItem>Select Analyst.....</asp:ListItem>
<asp:ListItem>Brock McFarlane</asp:ListItem>
<asp:ListItem>Cameron Farrally</asp:ListItem>
<asp:ListItem>Eric Spinney</asp:ListItem>
<asp:ListItem>Greg Freeman</asp:ListItem>
<asp:ListItem>Kevin Mark</asp:ListItem>
<asp:ListItem>Mark Anderson</asp:ListItem>
<asp:ListItem>Mike Murphy</asp:ListItem>
<asp:ListItem>Tim Elder</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="install_date" runat="server" Font-Names="Verdana" Font-Size="X-Small"></asp:TextBox><br />
<br />
Customer E-Backup Username:
Customer E-Backup Password:<br />
<asp:TextBox ID="cust_username" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="150px"></asp:TextBox>
<asp:TextBox ID="cust_password" runat="server" Font-Names="Verdana" Font-Size="X-Small"
Width="150px" TextMode="Password"></asp:TextBox><br />
<br />
<asp:RadioButtonList ID="account_request_type" runat="server" Font-Names="Verdana" Font-Size="X-Small"
RepeatDirection="Horizontal" Width="430px">
<asp:ListItem Value="New">New Account</asp:ListItem>
<asp:ListItem Value="Change">Account Change</asp:ListItem>
<asp:ListItem Value="Delete">Account Deletion</asp:ListItem>
</asp:RadioButtonList></span><br />
</td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: center;">
<span style="font-size: 14pt; font-family: Verdana">Financial / CRM Programs</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Does the customer use any of the
following financial / CRM products?<br />
<br />
Quickbooks<asp:CheckBox ID="quickbooks_check" runat="server" />
Peachtree Accounting<asp:CheckBox ID="peachtree_check"
runat="server" />
MS Small Business Acct<asp:CheckBox ID="mssba_check"
runat="server" />
<br />
Sage Goldmine<asp:CheckBox ID="goldmine_check" runat="server" />
Sage ACT!<asp:CheckBox ID="act_check" runat="server" /><br />
<br />
<br />
</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<span style="font-size: 14pt; font-family: Verdana">BackupExec / NTBackup</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Does the customer use BackupExec,
NTBackup or any other backup software? </span><span style="color: #ff0066"><span
style="font-size: 8pt; font-family: Verdana">(Important!)<br />
<br />
</span>
<asp:RadioButtonList ID="backupexec_option" runat="server" Font-Names="Verdana" Font-Size="X-Small"
ForeColor="Black" RepeatDirection="Horizontal" Width="127px">
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:RadioButtonList></span><span style="font-size: 8pt; font-family: Verdana">If "Yes"
which program do they use for backups? <asp:TextBox ID="backup_program" runat="server"
Font-Names="Verdana" Font-Size="X-Small" Width="200px"></asp:TextBox><br />
<br />
<br />
</span>
</td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<span style="font-size: 14pt; font-family: Verdana">Mail Server Backup</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Does the customer want to backup
their E-Mail system?<br />
<br />
</span>
<asp:RadioButtonList ID="mail_option" runat="server" Font-Names="Verdana" Font-Size="X-Small"
RepeatDirection="Horizontal" Width="127px">
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:RadioButtonList><span style="font-size: 8pt; font-family: Verdana">If "Yes" what
e-mail server software does the customer use?
<asp:TextBox ID="mail_info" runat="server" Font-Italic="False" Font-Names="Verdana"
Font-Overline="False" Font-Size="X-Small" Width="171px"></asp:TextBox><br />
<br />
<br />
</span>
</td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<span style="font-size: 16pt; font-family: Verdana">Database Backup</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 30px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Does the customer have a SQL, Access
or other RDMS that they wish to have backed up?<br />
<br />
</span>
<asp:RadioButtonList ID="db_option" runat="server" Font-Names="Verdana" Font-Size="X-Small"
RepeatDirection="Horizontal" Width="128px">
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:RadioButtonList><span style="font-size: 8pt; font-family: Verdana">If "Yes" please
list the databases the customers needs to have backed up.<br />
<asp:TextBox ID="db_info" runat="server" Height="102px" Width="321px"></asp:TextBox><br />
<br />
<br />
</span>
</td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<span style="font-size: 16pt; font-family: Verdana">Network Drives</span></td>
</tr>
<tr>
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt"><span style="font-family: Verdana">Does the customer want
any shared or mapped drives backed up? </span><span style="color: #ff0066"><span
style="font-family: Verdana">(Important!)</span><span style="color: #000000"><span
style="font-family: Verdana">
<br />
<br />
</span>
<asp:RadioButtonList ID="mapped_option" runat="server" Font-Names="Verdana" Font-Size="X-Small"
RepeatDirection="Horizontal" Width="126px">
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:RadioButtonList></span></span></span><span style="font-size: 8pt; font-family: Verdana">If
"Yes" please list the mapped or network drive the customer wishes to backup.<br />
<asp:TextBox ID="mapped_info" runat="server" Height="101px" Width="321px"></asp:TextBox><br />
<br />
</span>
</td>
</tr>
<tr style="color: #000000">
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<span style="font-size: 16pt; font-family: Verdana">Mobile Users</span></td>
</tr>
<tr style="color: #000000">
<td colspan="3" style="width: 540px; height: 21px; text-align: left">
<hr />
<span style="font-size: 8pt; font-family: Verdana">Does the customer have mobile users
that they wish to have data backed up for?<br />
<br />
</span>
<asp:RadioButtonList ID="RadioButtonList1" runat="server" Font-Names="Verdana" Font-Size="X-Small"
RepeatDirection="Horizontal" Width="121px">
<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
</asp:RadioButtonList><span style="font-size: 8pt; font-family: Verdana">If "Yes" please
enter the username and machine name for mobile user as well as when they will be
in the office for remote install of software.<br />
<asp:TextBox ID="TextBox1" runat="server" Height="101px" Width="321px"></asp:TextBox><br />
<br />
</span>
</td>
</tr>
<tr style="color: #000000">
<td colspan="3" style="width: 540px; height: 21px; text-align: center">
<asp:Button ID="Button" runat="server" Text="Submit Form For Processing" /></td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
View 5 Replies
View Related