Click here to Skip to main content
15,499,046 members
Home / Discussions / Database
   

Database

 
GeneralRe: while poop in stored procedure Pin
Christian Graus10-Oct-07 20:31
mveChristian Graus10-Oct-07 20:31 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 20:40
MemberSonia Gupta10-Oct-07 20:40 
GeneralRe: while poop in stored procedure Pin
Joe10-Oct-07 21:04
Member Joe10-Oct-07 21:04 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 21:27
MemberSonia Gupta10-Oct-07 21:27 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h10-Oct-07 23:54
MemberN a v a n e e t h10-Oct-07 23:54 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta11-Oct-07 0:43
MemberSonia Gupta11-Oct-07 0:43 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h11-Oct-07 1:39
MemberN a v a n e e t h11-Oct-07 1:39 
GeneralRe: while poop in stored procedure Pin
joemonvarghese10-Oct-07 20:48
Memberjoemonvarghese10-Oct-07 20:48 
hi
here is an example..fore more details on Cursor you can check help of Sql server 2000..



declare @EMpname as nvarchar(100)
declare emp_cursor cursor for
select name from employee

open emp_cursor
fetch next from emp_cursor into @EMpname
while(@@FETCH_STATUS=0)
begin
< update Statements>
fetch next from emp_cursor into @EMpname
end
close emp_cursor
deallocate emp_cursor





Regards

JOE
Questionan intersting sql problem Pin
richardye10-Oct-07 19:46
Memberrichardye10-Oct-07 19:46 
AnswerRe: an intersting sql problem Pin
GuyThiebaut10-Oct-07 23:53
professionalGuyThiebaut10-Oct-07 23:53 
AnswerHow to shrink a transaction log - and make sure that it actually shrinks. Pin
GuyThiebaut11-Oct-07 0:04
professionalGuyThiebaut11-Oct-07 0:04 
QuestionSQL Server Replication Pin
Anilkumar K V10-Oct-07 19:10
MemberAnilkumar K V10-Oct-07 19:10 
QuestionProblem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 18:52
MemberAavesh Agarwal10-Oct-07 18:52 
AnswerRe: Problem Regarding trigger Pin
joemonvarghese10-Oct-07 20:29
Memberjoemonvarghese10-Oct-07 20:29 
GeneralRe: Problem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 21:15
MemberAavesh Agarwal10-Oct-07 21:15 
QuestionTrying to figure out how to secure the db better. Starting with:Limit user access. Pin
foolios10-Oct-07 16:46
Memberfoolios10-Oct-07 16:46 
Questionmultiple threads accesing msAccess Pin
dsovino10-Oct-07 15:42
Memberdsovino10-Oct-07 15:42 
Questionhow can i insert mpeg files to DB? Pin
ebtihal10-Oct-07 14:25
Memberebtihal10-Oct-07 14:25 
AnswerRe: how can i insert mpeg files to DB? Pin
Christian Graus10-Oct-07 15:07
mveChristian Graus10-Oct-07 15:07 
GeneralRe: how can i insert mpeg files to DB? Pin
Vidhya Sagar10-Oct-07 17:27
MemberVidhya Sagar10-Oct-07 17:27 
QuestionTable Column Decimal Value Pin
Brendan Vogt10-Oct-07 6:22
MemberBrendan Vogt10-Oct-07 6:22 
AnswerRe: Table Column Decimal Value Pin
pmarfleet10-Oct-07 6:36
Memberpmarfleet10-Oct-07 6:36 
Questiona problem about m_pConnection->Execute Pin
nibabug10-Oct-07 5:31
Membernibabug10-Oct-07 5:31 
QuestionBulk insert - Fewer fields than in DB Pin
clint198210-Oct-07 5:17
Memberclint198210-Oct-07 5:17 
GeneralRe: Bulk insert - Fewer fields than in DB Pin
PIEBALDconsult10-Oct-07 7:30
professionalPIEBALDconsult10-Oct-07 7:30 

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.