Text Data Types
Jan 2, 2001
Hello all. I am a newbie to the world of setting up SQL databases, so please forgive my ignorance.
I have a nice website for social workers to enter encounters with clients. The social worker has to provide very detailed notes about the encounter. I have set up a textarea to take in all of this information. I am wondering which is the best data type to use for the table that this information will be dumped into. I am currently using text, but I don't want to waste space on the server with whitespace. Is this the best way to go? It is not uncommon for upwards of 5000 characters to be entered. This site is powered by ColdFusion, if that makes any difference.
Thanks in advance,
Adrian Miller
View 1 Replies
ADVERTISEMENT
Apr 25, 2006
I get this error:
The data types text and text are incompatible in the equal to operator.
when trying to execute this query
SELECT id FROM users WHERE username=@userName
Any Ideas?
View 3 Replies
View Related
Jan 2, 2014
I trying to fully understand when to use different data types in sql server.I want to know what Microdoft means when they say"Varchar is the actual length of the data entered plus 2 bytes".example e.g. what would the storage of varchar (50) be?
View 7 Replies
View Related
Jan 8, 2004
i have created asp.net page, one feild of this page text area.
when i insert some text through this page in "text feild" of SQL server on few words of this feild cut and inserted to text feild of SQL server but all text that i have written in text area feild.
can u please help me how to handle so that i can all text in text feild of SQL server data type text/next.
View 2 Replies
View Related
Jun 24, 2006
The following is the full error message. I am posting the code after.
Server Error in '/XprtDr' Application.
The data types text and nvarchar are incompatible in the equal to operator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The data types text and nvarchar are incompatible in the equal to operator.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): The data types text and nvarchar are incompatible in the equal to operator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +186
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +407
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +149
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +493
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +915
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +179
System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) +1197
System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +545
System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +163
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +118
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +177
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +242
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3838
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
--------------------------------------------------------------------------------------------------------------------------
<%@ Page Language="VB" AutoEventWireup="true" CodeFile="CompanyDetails.aspx.vb" Inherits="CompanyDetails" %>
<%@ Register Assembly="EasyListBox" Namespace="ELB" TagPrefix="ELB" %>
<!--
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If User.Identity.IsAuthenticated = False Then
Server.Transfer("login.aspx")
Else
Me.uId.Text = Membership.GetUser().ToString()
End If
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:TextBox ID="uId" runat="server" Style="z-index: 100; left: 456px; position: absolute;
top: 512px" Visible="False" Width="4px"></asp:TextBox>
<table style="z-index: 101; left: 24px; width: 572px; position: absolute; top: 44px;
height: 404px">
<tr>
<td style="width: 2px; height: 10px">
</td>
<td style="width: 651px; height: 10px">
</td>
<td style="width: 5px; height: 10px">
</td>
</tr>
<tr>
<td style="width: 2px; height: 435px">
</td>
<td style="width: 651px; height: 435px">
<asp:FormView ID="FormView1" runat="server" BackColor="White" BorderColor="#DEDFDE"
BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="indexNo" DataSourceID="CompanyDetails_MainForm"
ForeColor="Black" GridLines="Vertical" Height="500px" Style="z-index: 32; left: 12px;
position: absolute; top: 28px" Width="600px">
<FooterStyle BackColor="#CCCC99" />
<EditRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<EditItemTemplate>
<asp:Label ID="TitleLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 20px" Text='Name:' Width="100px" ></asp:Label>
<asp:label ID="TitleTextBox" runat="server" Style=" z-index: 100; left: 120px; position: absolute;
top: 20px" Text='<%# Bind("Title") %>' Width="450px"></asp:label>
<asp:Label ID="YearEstLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 50px" Text='Established:' Width="100px" ></asp:Label>
<asp:TextBox ID="yearEstTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 50px" Text='<%# Bind("yearEst") %>' Width="50px" ></asp:TextBox>
<asp:Label ID="EmployeeCountLabelEdit" runat="server" Style="z-index: 100; left: 375px; position: absolute;
top: 50px" Text='No. of Employees:' Width="140px" ></asp:Label>
<asp:TextBox ID="employeeCountTextBox" runat="server" Style="z-index: 100; left: 535px; position: absolute;
top: 50px" Text='<%# Bind("employeeCount") %>' Width="35px" ></asp:TextBox>
<asp:Label ID="Address1LabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 80px" Text='Address:' Width="100px" ></asp:Label>
<asp:TextBox ID="Address_1TextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 80px" Width="450px" Text='<%# Bind("Address_1") %>'></asp:TextBox>
<asp:Label ID="Address2LabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 110px" Text='Address2:' Width="100px" ></asp:Label>
<asp:Label ID="Adress2OptionalLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 125px" Text='(Optional):' Width="100px" ></asp:Label>
<asp:TextBox ID="Address_2TextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 110px" Width="450px" Text='<%# Bind("Address_2") %>'></asp:TextBox>
<asp:Label ID="ContactsLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 160px" Text='Contacts:' Width="100px" ></asp:Label>
<asp:TextBox ID="ContactsTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 160px" Width="450px" Text='<%# Bind("Contacts") %>'></asp:TextBox>
<asp:Label ID="TelNosLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 190px" Text='Telephone Nos.:' Width="115px" ></asp:Label>
<asp:TextBox ID="TelNosTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 190px" Width="450px" Text='<%# Bind("TelNos") %>'></asp:TextBox>
<asp:Label ID="FaxNosLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 220px" Text='Fax Nos.:' Width="100px" ></asp:Label>
<asp:TextBox ID="FaxNosTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 220px" Width="450px" Text='<%# Bind("FaxNos") %>'></asp:TextBox>
<asp:Label ID="EmailLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 250px" Text='E-mail:' Width="100px" ></asp:Label>
<asp:TextBox ID="emailAddressesTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 250px" Width="450px" Text='<%# Bind("emailAddresses") %>'></asp:TextBox><br />
<asp:Label ID="WebsiteLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 280px" Text='Website:' Width="100px" ></asp:Label>
<asp:TextBox ID="WebsiteTextBox" runat="server" Style="z-index: 100; left: 120px; position: absolute;
top: 280px" Width="450px" Text='<%# Bind("Website") %>'></asp:TextBox>
<asp:Label ID="ManufacturingSectorLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 310px" Text='Manufacturing' Width="100px" ></asp:Label>
<asp:Label ID="ManufacturingSubSectorsLabel2Edit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 325px" Text='Sub-sectors:' Width="100px" ></asp:Label>
<asp:Label ID="ServicesSubSectorsLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 355px" Text='Services' Width="100px" ></asp:Label>
<asp:Label ID="ServicesSubSectorsLabel2Edit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 370px" Text='Sub-sectors:' Width="100px" ></asp:Label>
<asp:Label ID="ImportSourcesLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 390px" Text='Import Sources:' Width="100px" ></asp:Label>
<asp:Label ID="ExportDestinationsLabelEdit" runat="server" Style="z-index: 100; left: 5px; position: absolute;
top: 420px" Text='Export Destinations:' Width="100px" ></asp:Label>
<asp:LinkButton ID="UpdateButton" runat="server" style="z-index: 100;left: 5px; position:absolute; top: 460px" CausesValidation="True" CommandName="Update"
Text="Update"></asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" style="z-index: 100;left: 70px; position:absolute; top: 460px" CausesValidation="False" CommandName="Cancel"
Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<RowStyle BackColor="#F7F7DE" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<InsertItemTemplate>
indexNo:
<asp:TextBox ID="indexNoTextBox" runat="server" Text='<%# Bind("indexNo") %>'>
</asp:TextBox><br />
userName:
<asp:TextBox ID="userNameTextBox" runat="server" Text='<%# Bind("userName") %>'>
</asp:TextBox><br />
Title:
<asp:TextBox ID="TitleTextBox" runat="server" Text='<%# Bind("Title") %>'>
</asp:TextBox><br />
yearEst:
<asp:TextBox ID="yearEstTextBox" runat="server" Text='<%# Bind("yearEst") %>'>
</asp:TextBox><br />
employeeCount:
<asp:TextBox ID="employeeCountTextBox" runat="server" Text='<%# Bind("employeeCount") %>'>
</asp:TextBox><br />
Address_1:
<asp:TextBox ID="Address_1TextBox" runat="server" Text='<%# Bind("Address_1") %>'>
</asp:TextBox><br />
Address_2:
<asp:TextBox ID="Address_2TextBox" runat="server" Text='<%# Bind("Address_2") %>'>
</asp:TextBox><br />
Contacts:
<asp:TextBox ID="ContactsTextBox" runat="server" Text='<%# Bind("Contacts") %>'>
</asp:TextBox><br />
TelNos:
<asp:TextBox ID="TelNosTextBox" runat="server" Text='<%# Bind("TelNos") %>'>
</asp:TextBox><br />
FaxNos:
<asp:TextBox ID="FaxNosTextBox" runat="server" Text='<%# Bind("FaxNos") %>'>
</asp:TextBox><br />
emailAddresses:
<asp:TextBox ID="emailAddressesTextBox" runat="server" Text='<%# Bind("emailAddresses") %>'>
</asp:TextBox><br />
Website:
<asp:TextBox ID="WebsiteTextBox" runat="server" Text='<%# Bind("Website") %>'>
</asp:TextBox><br />
ManufacturingSubSectors_id:
<asp:TextBox ID="ManufacturingSubSectors_idTextBox" runat="server" Text='<%# Bind("ManufacturingSubSectors_id") %>'>
</asp:TextBox><br />
ServicesSubSectors_id:
<asp:TextBox ID="ServicesSubSectors_idTextBox" runat="server" Text='<%# Bind("ServicesSubSectors_id") %>'>
</asp:TextBox><br />
ExportDestinations_id:
<asp:TextBox ID="ExportDestinations_idTextBox" runat="server" Text='<%# Bind("ExportDestinations_id") %>'>
</asp:TextBox><br />
ImportSources_id:
<asp:TextBox ID="ImportSources_idTextBox" runat="server" Text='<%# Bind("ImportSources_id") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
Title:
<asp:Label ID="TitleLabel" runat="server" Text='<%# Bind("Title") %>'></asp:Label><br />
yearEst:
<asp:Label ID="yearEstLabel" runat="server" Text='<%# Bind("yearEst") %>'></asp:Label><br />
employeeCount:
<asp:Label ID="employeeCountLabel" runat="server" Text='<%# Bind("employeeCount") %>'></asp:Label><br />
Address_1:
<asp:Label ID="Address_1Label" runat="server" Text='<%# Bind("Address_1") %>'></asp:Label><br />
Address_2:
<asp:Label ID="Address_2Label" runat="server" Text='<%# Bind("Address_2") %>'></asp:Label><br />
Contacts:
<asp:Label ID="ContactsLabel" runat="server" Text='<%# Bind("Contacts") %>'></asp:Label><br />
TelNos:
<asp:Label ID="TelNosLabel" runat="server" Text='<%# Bind("TelNos") %>'></asp:Label><br />
FaxNos:
<asp:Label ID="FaxNosLabel" runat="server" Text='<%# Bind("FaxNos") %>'></asp:Label><br />
emailAddresses:
<asp:Label ID="emailAddressesLabel" runat="server" Text='<%# Bind("emailAddresses") %>'></asp:Label><br />
Website:
<asp:Label ID="WebsiteLabel" runat="server" Text='<%# Bind("Website") %>'></asp:Label><br />
ManufacturingSubSectors_id:
<asp:Label ID="ManufacturingSubSectors_idLabel" runat="server" Text='<%# Bind("ManufacturingSubSectors_id") %>'></asp:Label><br />
ServicesSubSectors_id:
<asp:Label ID="ServicesSubSectors_idLabel" runat="server" Text='<%# Bind("ServicesSubSectors_id") %>'></asp:Label><br />
ExportDestinations_id:
<asp:Label ID="ExportDestinations_idLabel" runat="server" Text='<%# Bind("ExportDestinations_id") %>'></asp:Label><br />
ImportSources_id:
<asp:Label ID="ImportSources_idLabel" runat="server" Text='<%# Bind("ImportSources_id") %>'></asp:Label><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit"></asp:LinkButton>
</ItemTemplate>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
</asp:FormView>
<asp:SqlDataSource ID="CompanyDetails_MainForm" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString_companyDetails %>" DeleteCommand="DELETE FROM [companyDetails] WHERE [indexNo] = @original_indexNo AND [userName] = @original_userName AND [Title] = @original_Title AND [yearEst] = @original_yearEst AND [employeeCount] = @original_employeeCount AND [Address_1] = @original_Address_1 AND [Address_2] = @original_Address_2 AND [Contacts] = @original_Contacts AND [TelNos] = @original_TelNos AND [FaxNos] = @original_FaxNos AND [emailAddresses] = @original_emailAddresses AND [Website] = @original_Website AND [ManufacturingSubSectors_id] = @original_ManufacturingSubSectors_id AND [ServicesSubSectors_id] = @original_ServicesSubSectors_id AND [ExportDestinations_id] = @original_ExportDestinations_id AND [ImportSources_id] = @original_ImportSources_id"
InsertCommand="INSERT INTO [companyDetails] ([indexNo], [userName], [Title], [yearEst], [employeeCount], [Address_1], [Address_2], [Contacts], [TelNos], [FaxNos], [emailAddresses], [Website], [ManufacturingSubSectors_id], [ServicesSubSectors_id], [ExportDestinations_id], [ImportSources_id]) VALUES (@indexNo, @userName, @Title, @yearEst, @employeeCount, @Address_1, @Address_2, @Contacts, @TelNos, @FaxNos, @emailAddresses, @Website, @ManufacturingSubSectors_id, @ServicesSubSectors_id, @ExportDestinations_id, @ImportSources_id)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [indexNo], [userName], [Title], [yearEst], [employeeCount], [Address_1], [Address_2], [Contacts], [TelNos], [FaxNos], [emailAddresses], [Website], [ManufacturingSubSectors_id], [ServicesSubSectors_id], [ExportDestinations_id], [ImportSources_id] FROM [companyDetails] WHERE ([userName] = @userName)"
UpdateCommand="UPDATE [companyDetails] SET [yearEst] = @yearEst, [employeeCount] = @employeeCount, [Address_1] = @Address_1, [Address_2] = @Address_2, [Contacts] = @Contacts, [TelNos] = @TelNos, [FaxNos] = @FaxNos, [emailAddresses] = @emailAddresses, [Website] = @Website, [ManufacturingSubSectors_id] = @ManufacturingSubSectors_id, [ServicesSubSectors_id] = @ServicesSubSectors_id, [ExportDestinations_id] = @ExportDestinations_id, [ImportSources_id] = @ImportSources_id WHERE [indexNo] = @original_indexNo AND [userName] = @original_userName AND [Title] = @original_Title AND [yearEst] = @original_yearEst AND [employeeCount] = @original_employeeCount AND [Address_1] = @original_Address_1 AND [Address_2] = @original_Address_2 AND [Contacts] = @original_Contacts AND [TelNos] = @original_TelNos AND [FaxNos] = @original_FaxNos AND [emailAddresses] = @original_emailAddresses AND [Website] = @original_Website AND [ManufacturingSubSectors_id] = @original_ManufacturingSubSectors_id AND [ServicesSubSectors_id] = @original_ServicesSubSectors_id AND [ExportDestinations_id] = @original_ExportDestinations_id AND [ImportSources_id] = @original_ImportSources_id">
<DeleteParameters>
<asp:Parameter Name="original_indexNo" Type="Int32" />
<asp:Parameter Name="original_userName" Type="String" />
<asp:Parameter Name="original_Title" Type="String" />
<asp:Parameter Name="original_yearEst" Type="Int32" />
<asp:Parameter Name="original_employeeCount" Type="Int32" />
<asp:Parameter Name="original_Address_1" Type="String" />
<asp:Parameter Name="original_Address_2" Type="String" />
<asp:Parameter Name="original_Contacts" Type="String" />
<asp:Parameter Name="original_TelNos" Type="String" />
<asp:Parameter Name="original_FaxNos" Type="String" />
<asp:Parameter Name="original_emailAddresses" Type="String" />
<asp:Parameter Name="original_Website" Type="String" />
<asp:Parameter Name="original_ManufacturingSubSectors_id" Type="String" />
<asp:Parameter Name="original_ServicesSubSectors_id" Type="String" />
<asp:Parameter Name="original_ExportDestinations_id" Type="String" />
<asp:Parameter Name="original_ImportSources_id" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="userName" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="yearEst" Type="Int32" />
<asp:Parameter Name="employeeCount" Type="Int32" />
<asp:Parameter Name="Address_1" Type="String" />
<asp:Parameter Name="Address_2" Type="String" />
<asp:Parameter Name="Contacts" Type="String" />
<asp:Parameter Name="TelNos" Type="String" />
<asp:Parameter Name="FaxNos" Type="String" />
<asp:Parameter Name="emailAddresses" Type="String" />
<asp:Parameter Name="Website" Type="String" />
<asp:Parameter Name="ManufacturingSubSectors_id" Type="String" />
<asp:Parameter Name="ServicesSubSectors_id" Type="String" />
<asp:Parameter Name="ExportDestinations_id" Type="String" />
<asp:Parameter Name="ImportSources_id" Type="String" />
<asp:Parameter Name="original_indexNo" Type="Int32" />
<asp:Parameter Name="original_userName" Type="String" />
<asp:Parameter Name="original_Title" Type="String" />
<asp:Parameter Name="original_yearEst" Type="Int32" />
<asp:Parameter Name="original_employeeCount" Type="Int32" />
<asp:Parameter Name="original_Address_1" Type="String" />
<asp:Parameter Name="original_Address_2" Type="String" />
<asp:Parameter Name="original_Contacts" Type="String" />
<asp:Parameter Name="original_TelNos" Type="String" />
<asp:Parameter Name="original_FaxNos" Type="String" />
<asp:Parameter Name="original_emailAddresses" Type="String" />
<asp:Parameter Name="original_Website" Type="String" />
<asp:Parameter Name="original_ManufacturingSubSectors_id" Type="String" />
<asp:Parameter Name="original_ServicesSubSectors_id" Type="String" />
<asp:Parameter Name="original_ExportDestinations_id" Type="String" />
<asp:Parameter Name="original_ImportSources_id" Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="uId" Name="userName" PropertyName="Text" Type="String" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="indexNo" Type="Int32" />
<asp:Parameter Name="userName" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="yearEst" Type="Int32" />
<asp:Parameter Name="employeeCount" Type="Int32" />
<asp:Parameter Name="Address_1" Type="String" />
<asp:Parameter Name="Address_2" Type="String" />
<asp:Parameter Name="Contacts" Type="String" />
<asp:Parameter Name="TelNos" Type="String" />
<asp:Parameter Name="FaxNos" Type="String" />
<asp:Parameter Name="emailAddresses" Type="String" />
<asp:Parameter Name="Website" Type="String" />
<asp:Parameter Name="ManufacturingSubSectors_id" Type="String" />
<asp:Parameter Name="ServicesSubSectors_id" Type="String" />
<asp:Parameter Name="ExportDestinations_id" Type="String" />
<asp:Parameter Name="ImportSources_id" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</td>
<td style="width: 5px; height: 435px">
</td>
</tr>
<tr>
<td style="width: 2px">
</td>
<td style="width: 651px">
</td>
<td style="width: 5px">
</td>
</tr>
</table>
</form>
</body>
</html>
View 5 Replies
View Related
Jul 12, 2006
I have to run a dynamic sql that i save in the database as a TEXT data type(due to a large size of the sql.) from a .NET app. Now i have to run this sql from the stored proc that returns the results back to .net app. I am running this dynamic sql with sp_executesql like this..
EXEC sp_executesql @Statement,N'@param1 varchar(3),@param2 varchar(1)',@param1,@param2,GO
As i can't declare text,ntext etc variables in T-Sql(stored proc), so i am using this method in pulling the text type field "Statement".
DECLARE @Statement varbinary(16)SELECT @Statement = TEXTPTR(Statement)FROM table1 READTEXT table1.statement @Statement 0 16566
So far so good, the issue is how to convert @Statment varbinary to nText to get it passed in sp_executesql.
Note:- i can't use Exec to run the dynamic sql becuase i need to pass the params from the .net app and Exec proc doesn't take param from the stored proc from where it is called.
I would appreciate if any body respond to this.
View 2 Replies
View Related
Jan 3, 2006
Hi, i have a table in sqlexpress named Contacts:
ID (int) -primary key-
name (varchar(30))
lastname (varchar(30))
phone (varchar(15))
fax (varchar(15))
desc (text)
In my default.aspx page, i have a GridView that has the conecction to this table. The GridView has the Editing and Deleting checkbox enabled but my problem is that i can't edit or delete any row when the page is running and the massage is this: "The data types text and nvarchar are incompatible in the equal to operator"
It would have to work, but i don't know what happen, Please, any help!
View 8 Replies
View Related
Dec 2, 2005
I'm currently trying out transactional replication with updatable subscriptions across two 2005 servers.
View 3 Replies
View Related
Oct 20, 2007
Hi,
I´m exporting an ms-excel file, then I use a lookup transformation to get a field from a SQL Server 2005 table. The Lookup transformation editor, after selecting the table, shows a warning that says:
at least one mapping between a column from available input columns ans a column from available lookup columns must be defined on the columns page.
So I try to make a relationship in the Lookup transformation editor's column tab where I find the Available input columns and the available lookup columns but I get the following error:
The following columns cannot be mapped:
[Department, DEP_CLEGALCODE]
One or more columns do not have supported data types, or their data types do not match.
The field in SLQ Server is varchar(10) and the input field is a derived column transformation; I have tried different Data Types but I always have the same error.
The DataFlow is: ExcelSource --> Derived Column --> Lookup --> Flat file destination
thanks.
View 6 Replies
View Related
Jun 11, 2015
I am trying to find a reference for a client that lists the fields available to be substituted into a data driven subscription from the query, along with the expected data types.  For example, the field on whether or not to include a link to the report seems to be expecting a bit data type.I have searched and can't seem to find anything.  I guess I could walk through the interface and try different data types, but if  a list exists, that would be better.Â
View 4 Replies
View Related
Oct 14, 2005
Does anyone know of any cross-references between SQL Server data types and the new data types introduced with SQL Server Integration Services?
View 6 Replies
View Related
Sep 16, 2015
One of my report has different data types like decimal,percentage and integer values.
When I exported the report to excel , all the values are showing as "general" data type.
How to get excel data type same as ssrs report data type by default when exported to excel?
View 2 Replies
View Related
Jun 10, 2015
I Have a table with #Sample like below
=================================
#Sample
id int,
SSN varchar(20),
State varchar(2)
Â
Sample Data:
ID SSN STATE
1 999-000-000 AB
2 979-000-000Â BC
3 995-000-000Â CD
=================================
We used filter logic based on the SSN & State.
We are passing these values through variables like
Declare @State varchar(2)
Declare @SSN varchar(20)
While run time these values are lets suppose @SSN = '999-000-000' & @State='ABC'
Now the Result is displayed with the state data Like 'AB' only.
Output: 1 999-000-000 AB
instead it should give system generated error.
Here I have 2 Questions:
1. Why it is taking 1st 2 Charecters?
2. Why it does not have any system generated for length?
I can do validation with Length function for these 2 variables however if have 100 variables then it should not feasible case. So, what is the reason behind?Â
View 5 Replies
View Related
Apr 16, 2014
I have an source file and i have to load it into the data base by changing datatype of the columns in ssis
View 1 Replies
View Related
Mar 13, 2008
I'm in the process of converting a rather huge VSAM database into a set of SQL tables.
I am using the same data names from the mainframe (like XDB-NAME to RDB-NAME).
I load the files using Import Export Data and it makes the tables with such column names as col001, col002, col003, etc... and always sets the data types to varchr(255).
And I have to cut and paste the data names from the manframe side to the server side (and the data types to.)
So, is there an easier way to do this? Or am I doomed to cut-n-paste my days away...
Thanks for any help.
View 2 Replies
View Related
May 26, 2005
SQL Server 2000, ASP.Net 1.1
I've been writing this stuff for a while, and can't seem to come to the
conclusion of how I should be retrieving data and assigning this data
to variables.
Since i'm using SQL Server, I'm convinced that I should be using the
datareaders GetSqlDouble (or whatever) function, but this would mean i
need my local variables to be one of the SQL types. The problem
with that is, that there will have to be lots of conversions done by me
to be able to use a SQL type in my application.
For instance, I have a class where i'm retrieving dates. In order
to retrieve them correctly (Null values included), I need to retrieve
them with GetSqlDateTime(), then when it comes time to display the date
in a table, i must first check for nulls, then convert to a
string. This seems to be very cumbersome. Would I be better
off just using GetDateTime(), and the .ToString method, and ignoring
Sql Types all together?
so, basically, how are you guys using your sql server data? with
the supplied sql types, and doing all of the post-processing work
manually? I feel like i'm having trouble conveying my
issue...hopefully someone knows what i mean....i'd just like some
direction to save trouble in the long run, since i feel like there's
got to be a better way...
Confused!
Thanks,
JJ
View 1 Replies
View Related
Mar 30, 2007
Is it possible to easily copy data from one table to another if the data types don't match. I know you can do a INSERT INTO table1(col1,col2) SELECT (col2,col7) FROM table2 if the data types match but is there a way to do this if they don't. I'm not trying to copy date times into bit fields or anything. I just have an old table that I built when I really didn't know what I was doing now I at leastthink I have a better understanding of what data types to use, so I was wanting to move the data in the orignal table to my new one. Most of the fields in the olddatabase are text datatypes and the new database is nvarchar(50) data types. Thanks for any suggestions.
View 4 Replies
View Related
Dec 29, 2004
Hello,
I have a really dumb question regarding SQL data types. I have a couple columns in a table that are specified as MONEY. These columns are being read from my web app and displayed on the website for reference when filling in other information.
My problem is that when it is displayed on the website it give four decimal places instead of two. For example I want it to report $33,000.29 but what is actually displayed is $33,000.2965.
How can I set up either SQL or my web app so that it only displays the two decimal places? I've looked into changing the datatype already but SMALLMONEY and MONEY have the same type of decimal values.
Thanks!
View 3 Replies
View Related
Aug 29, 2001
I am looking for a chart of SQL Server data types and information about them, such as usage, constraints, etc. Could anyone point me in the right direction?
Thanks
View 1 Replies
View Related
Oct 2, 2000
I'm just getting used to using SQL 7 Database and am looking for some recommendations on what DATA TYPES to use when designing tables.
The site I am working on now uses cold fusion to enter, update, and insert mainly text and articles. Now the problem with the articles is that some of them are pretty big. And when inserting or updating them, if they go over the limit of characters I get an error.
I know in access I used to use the data type "MEMO" and be able to put a large piece of info in that field.
What's the equivalent for SQL server databe?
What are the most used/common or recommended data types that should be used when putting tables together?
Thanks
George
View 2 Replies
View Related
Nov 21, 2003
hi, i'm trying to build an online forum using sql server 2000 and coldfusion mx.
could anybody help me as to what datatypes i should use for my database fields?
i'll be using 2 simple tables to start with, ie TOPICS and POSTS. each will contain fairly basic information such as name of poster, time, data, title, message etc.
any help would be greatly appreciated.
thanx, zaffi.
View 4 Replies
View Related
Jun 9, 2004
Which data type do I need to assign to my field to let users enter characters such as +=-_| etc....pretty much every single character from a standard keyboard....
thanks
View 2 Replies
View Related
May 10, 2007
Hi,
I am pretty new with SQL and was dabbling in a test database that is linked with a software application.
I made a change to a table - Lets call this (Table1).
Table1 has a multiple columns.
Column1 is defined as numeric(9)
Column2 is defined as varchar(20)
In this case, I wanted to make all values in Column2 = Column1 that did not have a value defined so I ran the following query:
update Table1 set Column2 = Column1 where Column2 = ''
This took effect but the particular software application doesn't recognize these values because they are the wrong data type.
How can I convert all data in a column to varchar(20) if it is another data type (i.e. in this case numeric(9))?
I've tried in Enterprise manager to redesign the table and adjusted the length to 21 and then back and saved it but this did not work. I was looking at Convert and Cast functions but don't know how to write one to accomplish what I need to do here.
Half of the data in Column2 is varchar(20) and half is numeric(9).
I want all to be varchar(20).
Thanks,
asyncd
View 1 Replies
View Related
Feb 14, 2008
Im comparing values. if i add the values which is numeric or monetary in the column and if it is greater than zero it will insert to a table, but the datatype of my column([Day 30 AMT] etc. is char. i want to implement like these like these because it cant return a result if i query..
FROM tbl1 a LEFT OUTER JOIN tb2 b
ON a.ID = b.ID
WHERE b.ID IS NULL AND
a.[Day 30 AMT] + a.[Day 60 AMT] + a.[Day 90 AMT] + a.[Day 120 AMT] + a.[Day 150 AMT] + a.[Day 180 AMT] + a.[Day 210+ AMT]) > 0
View 8 Replies
View Related
Mar 13, 2008
What is the difference between int and numeric data type in sql server 2000. When I should use which?
View 2 Replies
View Related
Jul 20, 2005
what is the equivalent data type of autonumber of access in sql server?
View 2 Replies
View Related
Sep 6, 2006
Hi,
I want to store a decimal value which I get from an execute sql task into a package variable. Which data type should I specify when creating the package variable?
Thanks,
Tom
View 8 Replies
View Related
Jan 4, 2007
I have successfully made a couple of SSIS packages to read data from a legacy AS400 to SQL Server 2005. These are working fine. I am now working on one that is trying to pull some financial data and I keep getting the following error for the decimal columns:
"The component ciew is unavailable. Make sure the component view has been created. The input column "input column AMT1 (2870) cannot be mapped to "external metadata column AMT1(2852) because they have different data types."
Now I made sure that the data sitting on the AS400 is of type decimal and the SQL server column is the same. What else do I need to look for?
Thanks for the information.
View 3 Replies
View Related
Oct 19, 2006
Hello, I am following this article about building an ASP.Net application which uses SQL Express 2005. The document calls for building a couple of tables. One column is identified with data type of "Byte" which are is available for selection within the Visual Studio 2005 interface. The following values show in the drop down of data type in VS2005:
Bigint
Binary(5)
Bit
Char(10)
DateTime
Decimal (18,0)
Float
Image
Int
Money
NChar(10)
NText
Numeric(18,0)
Nvarchar(50)
Nvarchar(max)
Real
SmallDateTime
SmallInt
SmallMoney
Sql_Variant
Text
Timestamp
TinyInt
UniqueIdentifier
Varbinary(50)
VarBinary(max)
varchar(10)
Varchar(max)
XML
I choose Char with a size of 1. Would this be correct, or am I missing something?
Thanks in advance for your assistance!!
View 1 Replies
View Related
Dec 5, 2005
Is there some type of resource that tells you what all the Data types are and what they are used for. For example, whats the diffrence between Nvarchar and Char? Things like that. Thanks!
View 1 Replies
View Related
Jul 3, 2007
Having a slight problem. For whatever reason I had a column setup for nvchar but the only data i have in there is dates (MM/DD/YY) and a whole bunch of NULLs. I wanted to change the datatype to datetime but it gave me an error. I thought it was due to all the NULLs, so I removed all the nulls. It still doesn't work. I get the error : Conversion failed when converting datetime from character string.
I don't belive its because I have the data in mm/dd/yy format. I created another table and populated it with mm/dd/yy data as nvchar (50) and then converted to datetime and it worked fine.
any ideas?
View 4 Replies
View Related
Oct 16, 2007
Hey guys,
I have a table with the following information.
A1,A2,A3,A10,A11,A12,A14,A20,A21B1,B2,B3,B10,B11,B12,B14,B20,B21C1,C2,C3,C10,C11,C12,C14,C20,C21Now if I assign this field as a char,varchar,text field then when sorting it turns outA1,A10,A11,A12,A14,A2,A20 etc. So in order to go around this issue, I placed a blank ' ' (space) before the items that are less than 10 so that it'll sort as' A1', ' A2', ' A3' , 'A10' etc. However, now the problem is since the B and C series also have this space it actually sorts as' A1', ' A2', ' A3', ' B1', ' B2' ... 'A11','A12' etc. Now, I know why it is doing that. I'm trying to figure out if there is a solution to this issue. I've considered having two fields instead, one for the letter and another for the number, However, I need to display them together and I also need to do some reporting on these figures, so even if i concatenate the two fields together, it'll be a string field and sort by the same way. Any ideas?
View 1 Replies
View Related
Sep 11, 2004
I've inherited a monster database that needs updating. It has a field called Birthdays that has been a text field and I want to convert it to datetime. The data entry people have been sloppy from time to time and some of the values generate errors when you try and change datatypes. Is there a way to change the datatype and have the oddball values left blank without bombing out the conversion process?
Thanks
View 1 Replies
View Related
