Viewing 15 posts - 76 through 90 (of 110 total)
Sorry for the previous question.
The point that I had mentioned is that we do not use this statement when working with ADO 2.5 and ADO.NET.
What I missed out there was...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 6:13 am
We never use this option while using the ADO 2.5 or the latest ADO.net. Does this mean that these object libraries do it on their own.
Pay Respect to People on...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 5:50 am
Try this.
select student from
a
where number of tests >=30
group by student,percent
having count(marks)>=2
union
select student from
a
where number of tests >=40
group by student,percent
having count(marks)>=1
Pay Respect to People on your way up. For...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 5:39 am
Have u by any chance set value of IMPLICIT_TRANSACTIONS to on
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 4:45 am
Just a guess.
The user under which the new tables are being created is different then the one previously used.
Pay Respect to People on your way up. For you will meet...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 4:37 am
Since you cannot drop a database when some one is connected to the same, you need to keep the store procedure in some other database and connect to that database.
you...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 3:41 am
Visual Basic Part
=================
on error goto error
Dim oCommand As New Command
oCommand.ActiveConnection = <connectionobject>
oCommand.CommandTimeout = 100
oCommand.CommandType = adCmdStoredProc
oCommand.CommandText = <storedprocedurename>
oCommand.Parameters.Append oCommand.CreateParameter("@status", adInteger, adParamOutput)
oCommand.Execute
Exit Sub
error:
...
He who knows others is learned but the wise one is one who knows himself.
August 18, 2003 at 11:09 pm
Try this out..
select customers.customerID,sum (case when orderdate < '1997-01-01' then 1 else 0 end) as a,
sum (case when orderdate > '1997-01-01' then 1 else 0 end) as b...
He who knows others is learned but the wise one is one who knows himself.
August 18, 2003 at 6:05 am
Are you sure no one else is updating the same set of records during the time you are executing the queries.
I mean in a multi-user scenario this might be the...
He who knows others is learned but the wise one is one who knows himself.
August 18, 2003 at 5:22 am
Firstly I am sure you are connecting to a database other than the database you need to drop while executing the drop command from the front end.
If this is true...
He who knows others is learned but the wise one is one who knows himself.
August 18, 2003 at 4:49 am
If you are using more than one column in the where clause, try using covering indexes
i.e. composite index on both the columns.
Relationships are like Banks.You Invest the Principal and...
He who knows others is learned but the wise one is one who knows himself.
August 18, 2003 at 3:58 am
Sorry for the confusion.
Suppose my text files had this data
1|Deep|5000
2|Anil|5000
....
and so on
I would create a sp like this
create proecure @c1 varchar(8000),@c2 varchar(8000),@c3 varchar(8000)
To this store procedure I would...
He who knows others is learned but the wise one is one who knows himself.
August 14, 2003 at 12:58 am
Recently I had a similar issue. I had to upload around 1 lac record from a text file into the sql server database. I will let you know what I...
He who knows others is learned but the wise one is one who knows himself.
August 14, 2003 at 12:00 am
Have you tried.
sp_help <table_name>
It will return two recordsets. The second recordset will return you column details.
I am not sure whether this will help u?
Relationships are like Banks.You Invest the Principal...
He who knows others is learned but the wise one is one who knows himself.
August 13, 2003 at 11:09 pm
Refer to BOL
It says that
If the compatibility level is 80 or higher, SQL Server allows the update of text, ntext, or image columns through the INSTEAD OF trigger...
He who knows others is learned but the wise one is one who knows himself.
August 13, 2003 at 6:17 am
Viewing 15 posts - 76 through 90 (of 110 total)