Click here to Skip to main content
15,921,884 members
Home / Discussions / Database
   

Database

 
Generalsql dmo quest Pin
ranjjj19-Nov-03 18:28
ranjjj19-Nov-03 18:28 
GeneralRe: sql dmo quest Pin
Johnny Go-Lightly20-Nov-03 14:34
sussJohnny Go-Lightly20-Nov-03 14:34 
QuestionHow does DataView.RowFilter works? Pin
Alexandru Savescu19-Nov-03 7:11
Alexandru Savescu19-Nov-03 7:11 
AnswerRe: How does DataView.RowFilter works? Pin
Husein23-Nov-03 2:51
Husein23-Nov-03 2:51 
GeneralSelect reads from XML file in ado.net Pin
imran_shahid@msn.com18-Nov-03 21:24
imran_shahid@msn.com18-Nov-03 21:24 
Questionhow to apply filter to Master/Detail records in dataset Pin
imran_shahid@msn.com18-Nov-03 21:19
imran_shahid@msn.com18-Nov-03 21:19 
AnswerRe: how to apply filter to Master/Detail records in dataset Pin
gokselm22-Nov-03 14:31
gokselm22-Nov-03 14:31 
GeneralCursor Pin
Anonymous18-Nov-03 4:42
Anonymous18-Nov-03 4:42 
When I run cursor I am getting results in a separate results rows.
I need to get all results row as one big results. What should I do?
DECLARE @DateEntered as smalldatetime
Declare @SID as varchar(10)
Declare @TranID as numeric
Declare @TType as varchar(1)
DECLARE MaxDate CURSOR FOR
select a.SID,a.TranID,a.DateEntered,TType
from table1 a join
(SELECT sid,MAX(DateEntered) DateEntered FROM table1
group by sid) b
on a.sid = b.sid
and a.DateEntered=b.DateEntered
OPEN MaxDate
FETCH NEXT FROM MaxDate
INTO @sid,@TranID, @DateEntered, @TType
WHILE @@FETCH_STATUS = 0
BEGIN
if @TType='E'
Begin
select *
from table2
where sid= @sid
and TranID=@TranID
End
Else
Begin
select *
from table3
where sid= @sid
and TranID=@TranID
End
FETCH NEXT FROM MaxDate
INTO @sid,@TranID, @DateEntered, @TType
END
CLOSE MaxDate
DEALLOCATE MaxDate
GeneralRe: Cursor Pin
Jeff Varszegi18-Nov-03 5:34
professionalJeff Varszegi18-Nov-03 5:34 
Generalcall ado nextrecordset failed Pin
zhangxinghai17-Nov-03 21:52
zhangxinghai17-Nov-03 21:52 
Questionhow to store xml data from xml file in database table Pin
Kris{PL}17-Nov-03 11:55
Kris{PL}17-Nov-03 11:55 
GeneralBorland C++ Builder DB usage Pin
EricCartman17-Nov-03 5:43
EricCartman17-Nov-03 5:43 
GeneralSQLObjectListPtr Pin
ranjjj17-Nov-03 3:14
ranjjj17-Nov-03 3:14 
GeneralSQLObjectListPtr Pin
ranjjj17-Nov-03 3:14
ranjjj17-Nov-03 3:14 
Generalsqldmo.tlh Pin
ranjjj16-Nov-03 22:33
ranjjj16-Nov-03 22:33 
Generallistdatabasepermissions Pin
ranjjj15-Nov-03 23:53
ranjjj15-Nov-03 23:53 
GeneralLoad a file into a binary column in SQL server Pin
CillyMe15-Nov-03 17:32
CillyMe15-Nov-03 17:32 
GeneralRe: Load a file into a binary column in SQL server Pin
mhmoud rawas15-Nov-03 18:39
mhmoud rawas15-Nov-03 18:39 
GeneralRe: Load a file into a binary column in SQL server Pin
CillyMe16-Nov-03 22:32
CillyMe16-Nov-03 22:32 
GeneralLoad a file into a binary column in SQL server Pin
CillyMe15-Nov-03 17:31
CillyMe15-Nov-03 17:31 
GeneralRe: Load a file into a binary column in SQL server Pin
Jeff Varszegi18-Nov-03 5:38
professionalJeff Varszegi18-Nov-03 5:38 
GeneralSQL Server Date Problem Pin
sim_san15-Nov-03 1:16
sim_san15-Nov-03 1:16 
GeneralRe: SQL Server Date Problem Pin
Mike Dimmick15-Nov-03 1:55
Mike Dimmick15-Nov-03 1:55 
GeneralRe: SQL Server Date Problem Pin
sim_san17-Nov-03 6:40
sim_san17-Nov-03 6:40 
GeneralRe: SQL Server Date Problem Pin
Mike Dimmick17-Nov-03 6:54
Mike Dimmick17-Nov-03 6:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.