Click here to Skip to main content
15,511,981 members
Home / Discussions / Database
   

Database

 
AnswerRe: Automate database backup ? Pin
Syed Mehroz Alam14-Jul-08 1:51
Syed Mehroz Alam14-Jul-08 1:51 
AnswerRe: Automate database backup ? Pin
leoinfo14-Jul-08 4:10
leoinfo14-Jul-08 4:10 
QuestionSQL SERVER DATABASE Pin
Anubhava Dimri13-Jul-08 22:54
Anubhava Dimri13-Jul-08 22:54 
AnswerRe: SQL SERVER DATABASE [modified] Pin
Syed Mehroz Alam14-Jul-08 1:42
Syed Mehroz Alam14-Jul-08 1:42 
Questiongeneralized statements for update delete insert Pin
santosh04213-Jul-08 22:37
santosh04213-Jul-08 22:37 
AnswerRe: generalized statements for update delete insert Pin
Ashfield14-Jul-08 2:14
Ashfield14-Jul-08 2:14 
GeneralRe: generalized statements for update delete insert Pin
santosh04214-Jul-08 5:11
santosh04214-Jul-08 5:11 
AnswerRe: generalized statements for update delete insert Pin
leoinfo14-Jul-08 5:27
leoinfo14-Jul-08 5:27 
First,
CREATE PROCEDURE spx_Student_Delete (@rollno INT)
AS 
delete from student where rollno=@rollno;
GO


Then use it like this
EXECUTE spx_Student_Delete 12


and it should work

modified on Monday, July 14, 2008 1:10 PM

Questionconnection string Pin
nelsonpaixao13-Jul-08 16:06
nelsonpaixao13-Jul-08 16:06 
AnswerRe: connection string Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:48
professionalVimalsoft(Pty) Ltd13-Jul-08 16:48 
AnswerRe: connection string Pin
Ashfield13-Jul-08 22:01
Ashfield13-Jul-08 22:01 
GeneralRe: connection string Pin
nelsonpaixao14-Jul-08 14:11
nelsonpaixao14-Jul-08 14:11 
Questionhelp me to write procedure Pin
amistry_petlad13-Jul-08 8:40
amistry_petlad13-Jul-08 8:40 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 14:35
nelsonpaixao13-Jul-08 14:35 
AnswerRe: help me to write procedure Pin
amistry_petlad13-Jul-08 14:41
amistry_petlad13-Jul-08 14:41 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 15:37
nelsonpaixao13-Jul-08 15:37 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 15:47
amistry_petlad13-Jul-08 15:47 
AnswerRe: help me to write procedure Pin
leoinfo13-Jul-08 18:21
leoinfo13-Jul-08 18:21 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:57
amistry_petlad13-Jul-08 18:57 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:06
professionalPaul Conrad13-Jul-08 19:06 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 19:12
amistry_petlad13-Jul-08 19:12 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:16
professionalPaul Conrad13-Jul-08 19:16 
GeneralRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 16:12
nelsonpaixao13-Jul-08 16:12 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:58
amistry_petlad13-Jul-08 18:58 
Questiondecimal not show zero [modified] Pin
tai-fun12-Jul-08 4:38
tai-fun12-Jul-08 4:38 

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.