all groups > dotnet ado.net > august 2003 > threads for friday august 15
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Oracle or SQLServer - .NET or J2EE?
Posted by Syed Mudussir Husain at 8/15/2003 10:50:42 AM
Hello,
I am doing a very large web based database project.
Over the period of 5 years, "more than 100, 000 Books" will be stored in a
Database along with a LARGE amount of book attributes majorly consists of
very large amount of people reviews about a book.
We then need to analyze or gene... more >>
enforcing FK constraints on datatables that are not in a DS
Posted by Sankar Nemani at 8/15/2003 10:25:19 AM
Hi All,
I've created two datatables dtCountries and dtCities in
memory. I am able to create a FK constraint on dtCities
without adding these datatables to a dataset. But unless I
add them to a dataset I am not able to enforce the
constraint. Is there any way to enforce FK constraint
with... more >>
Returning a cursor from a stored procedure
Posted by arne at 8/15/2003 9:49:56 AM
How do I capture a resultset from a stored procedure with
ado.net code?
ALTER PROCEDURE dbo.sp_ins_contacts
(
@FName nvarchar(50),
@LName nvarchar(50),
@Initials nvarchar(50),
@IntakeDate smalldatetime,
@SSN nchar(10),
@Advisor nvarchar(50 )
AS
SET NOCOUNT OFF;
INSERT INTO tbl_... more >>
Returning a cursor from a stored procedure
Posted by arne at 8/15/2003 9:49:51 AM
How do I capture a resultset from a stored procedure with
ado.net code?
ALTER PROCEDURE dbo.sp_ins_contacts
(
@FName nvarchar(50),
@LName nvarchar(50),
@Initials nvarchar(50),
@IntakeDate smalldatetime,
@SSN nchar(10),
@Advisor nvarchar(50 )
AS
SET NOCOUNT OFF;
INSERT INTO tbl_... more >>
What happens when you delete a DataRow ?
Posted by Terry Burns at 8/15/2003 8:31:27 AM
I know that the state is changed to deleted, but what else happens ?, does
the table make a new version of itself each time or the row ?
The reason i'm asking is because I'm have a tough time understanding how
making changes to more than one row ( but not more than one change per row )
and the... more >>
|