I cannot write null values to database where field is expecting an integer.
ASSUMPTION: All data, code and database stored procedure is correct except line specified below!!!
I have the followi...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20949595.html
Zones:
.NETDate Answered: 04/11/2004 Grade: B Views: 0
i want to insert User.Identity.Name into my database.
in visual studio web developer i have this options under parameter source
profile
form
querystgring
session
cookie
control
which...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_22632076.html
yes I am trying to import a parameter
ImportRecommend.Parameters.Add("@SLQty", SqlDbType.Numeric, "SLQty")
but I get an error saying Numeric is not a member of system.data.SqlDbType
Is t...
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_23492952.html
Yes i am trying to import a paramter that is numeric.
keep getting an error
Cast from string "SLQty" to type 'Integer' is not valid.
and the stored procedure add parameter is @SLQty Numeric,
http://www.experts-exchange.com/Microsoft/Development/.NET/Visual_Studio_.NET_2003/Q_23534...
I am creating a stored proc that accepts as parameters @Tablename, @ColumnNames and @Values:
CREATE PROC sp_Insert
@TableName varchar
@ColumnNames longstring
@Values longstring
AS
INSERT @Tablenam...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10108291.html
Hello,
I'm using Crystal Reports version 8.5.
Is there a way of putting a parameters value
into the SQL Query(this is accessed through
Database/Show SQL Query)?
My SQL Statement in crys...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20862858.html
Hello,
I'm trying to run this query:
DECLARE @table_name char( 32 )
SET @table_name = 'L1s'
insert into @table_name ( left_part, right_part ) values( 1, 2 )
SELECT @@IDENTITY
and get this...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21800712.html
I know this is probably easy, but I'm having some issues. I'm trying to set up a SQL insert statement to work with my VS .net 2.0 project, so I'm not sure where the error might be, however if someo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21987792.html
Hello all!
I have a script written which takes data out of an excel spreadsheet and deposits it into an Access database table. This script worked great with a different excel and access table, ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21691033.htm...
Zones:
ASPDate Answered: 01/16/2006 Grade: B Views: 0
When I open my report it prompts the user for a start date and an end date, and it prints my records accordingly to those dates. How can I get the start date and the end date that the user inputs ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20404752.html
Zones:
MS AccessDate Answered: 11/26/2002 Grade: C Views: 0
