Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
QuestionSql Stored Procedure Pin
senthilsstil20-May-08 23:58
senthilsstil20-May-08 23:58 
Questionhow to retrive the value of the sp output through execute immediate Pin
lakshmichawala20-May-08 23:08
lakshmichawala20-May-08 23:08 
Questionsql query Pin
Unknown Ajanabi20-May-08 23:02
Unknown Ajanabi20-May-08 23:02 
AnswerRe: sql query Pin
Colin Angus Mackay21-May-08 1:01
Colin Angus Mackay21-May-08 1:01 
AnswerRe: sql query Pin
Michael Potter21-May-08 10:23
Michael Potter21-May-08 10:23 
Questionproblem with SQLparameter? Pin
Mr.Kode20-May-08 22:20
Mr.Kode20-May-08 22:20 
AnswerRe: problem with SQLparameter? Pin
Unknown Ajanabi20-May-08 23:17
Unknown Ajanabi20-May-08 23:17 
GeneralRe: problem with SQLparameter? Pin
Mr.Kode20-May-08 23:20
Mr.Kode20-May-08 23:20 
yes i did, here is the stored procedure:
i create it by command builder

CREATE PROCEDURE dbo.InsertQueryoperation
(
@Award_num int,
@patient_name varchar(40),
@Operation_date smalldatetime,
@Duration smalldatetime,
@Surgean_name varchar(40),
@Type_of_operation varchar(20),
@Anaesthiologist_name varchar(40),
@Type_of_anaesthesia varchar(20),
@ID_num int
)
AS
SET NOCOUNT OFF
INSERT INTO Operation_details
(Award_num, patient_name, Operation_date, Duration, Surgean_name, Type_of_operation, Anaesthiologist_name, Type_of_anaesthesia, ID_num)
VALUES (@Award_num,@patient_name,@Operation_date,@Duration,@Surgean_name,@Type_of_operation,@Anaesthiologist_name,@Type_of_anaesthesia,@ID_num);

SELECT Operation_ID, Award_num, patient_name, Operation_date, Duration, Surgean_name, Type_of_operation, Anaesthiologist_name, Type_of_anaesthesia, surgean_ID, Anaesthiologist_ID, ID_num FROM Operation_details WHERE (Operation_ID = SCOPE_IDENTITY())
GeneralRe: problem with SQLparameter? Pin
Unknown Ajanabi20-May-08 23:50
Unknown Ajanabi20-May-08 23:50 
AnswerCP Ignore Pin
leckey21-May-08 3:20
leckey21-May-08 3:20 
Questiondistinct? Pin
laserbaronen20-May-08 21:40
laserbaronen20-May-08 21:40 
AnswerRe: distinct? Pin
Blue_Boy20-May-08 22:47
Blue_Boy20-May-08 22:47 
QuestionRe: distinct? Pin
laserbaronen20-May-08 22:51
laserbaronen20-May-08 22:51 
AnswerRe: distinct? Pin
Blue_Boy20-May-08 22:53
Blue_Boy20-May-08 22:53 
GeneralRe: distinct? Pin
laserbaronen20-May-08 23:02
laserbaronen20-May-08 23:02 
GeneralRe: distinct? Pin
Blue_Boy20-May-08 23:19
Blue_Boy20-May-08 23:19 
GeneralRe: distinct? Pin
laserbaronen20-May-08 23:31
laserbaronen20-May-08 23:31 
GeneralRe: distinct? Pin
Blue_Boy20-May-08 23:32
Blue_Boy20-May-08 23:32 
QuestionPrimary Keys Pin
MAW3020-May-08 16:50
MAW3020-May-08 16:50 
AnswerRe: Primary Keys Pin
ChandraRam20-May-08 21:00
ChandraRam20-May-08 21:00 
QuestionInner Join to match multiple rows in lookup table Pin
redivider20-May-08 10:59
redivider20-May-08 10:59 
AnswerRe: Inner Join to match multiple rows in lookup table Pin
WoutL20-May-08 20:12
WoutL20-May-08 20:12 
GeneralRe: Inner Join to match multiple rows in lookup table Pin
redivider21-May-08 4:57
redivider21-May-08 4:57 
Questionsql very long?? Pin
foryou20-May-08 1:52
foryou20-May-08 1:52 
GeneralHelp me please. Pin
foryou21-May-08 1:53
foryou21-May-08 1:53 

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.