Click here to Skip to main content
15,920,618 members
Home / Discussions / Database
   

Database

 
Generalretrieve current week's data Pin
SeeSharp18-Mar-08 20:07
SeeSharp18-Mar-08 20:07 
GeneralRe: retrieve current week's data Pin
Krish - KP19-Mar-08 0:19
Krish - KP19-Mar-08 0:19 
GeneralRe: retrieve current week's data Pin
SeeSharp20-Mar-08 0:09
SeeSharp20-Mar-08 0:09 
GeneralDouble Click options in SQL 2005 editor Pin
pmpdesign18-Mar-08 12:43
pmpdesign18-Mar-08 12:43 
GeneralReporting services--Problem with the subreport Pin
Payal_e_m18-Mar-08 10:50
Payal_e_m18-Mar-08 10:50 
GeneralRe: Reporting services--Problem with the subreport Pin
pmarfleet18-Mar-08 11:10
pmarfleet18-Mar-08 11:10 
GeneralRe: Reporting services--Problem with the subreport Pin
Payal_e_m18-Mar-08 13:02
Payal_e_m18-Mar-08 13:02 
General@@Identity & Scope_Identity() returning null. Pin
Mustafa Ismail Mustafa18-Mar-08 10:36
Mustafa Ismail Mustafa18-Mar-08 10:36 
Ok, I'm tried and I'm making mistakes, but for the life of me I don't see what's wrong with the following sproc. I even ran it and then tried an external Select @@Identity which did return a value, but not the sproc.

SPROC:
@CourseNumber int OUTPUT,
	@CourseName nvarchar(100),
	@College int,
	@Department int,
	@Description nvarchar(500)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    INSERT INTO Course
		(CourseName, College, Department,Description)
	VALUES
		(@CourseName, @College, @Department,@Description)

	SELECT @CourseNumber = @@IDENTITY


"Every time Lotus Notes starts up, somewhere a puppy, a kitten, a lamb, and a baby seal are killed. Lotus Notes is a conspiracy by the forces of Satan to drive us over the brink into madness. The CRC-32 for each file in the installation includes the numbers 666." Gary Wheeler

"The secret to a long and healthy life is simple. Don't get ill and don't die." Pete O'Hanlon, courtesy of Rama

"I realised that all of my best anecdotes started with "So there we were, pissed". Pete O'Hanlon

GeneralRe: @@Identity & Scope_Identity() returning null. Pin
pmarfleet18-Mar-08 11:13
pmarfleet18-Mar-08 11:13 
GeneralRe: @@Identity & Scope_Identity() returning null. Pin
Mustafa Ismail Mustafa18-Mar-08 12:20
Mustafa Ismail Mustafa18-Mar-08 12:20 
QuestionHow do I update an XSL stylesheet, stored in a field of type XML Pin
totig18-Mar-08 7:20
totig18-Mar-08 7:20 
Generalerror connecting to SQL2005 Express Pin
Anoop Brijmohun18-Mar-08 4:50
Anoop Brijmohun18-Mar-08 4:50 
GeneralRe: error connecting to SQL2005 Express Pin
John_Adams19-Mar-08 3:09
John_Adams19-Mar-08 3:09 
GeneralRe: error connecting to SQL2005 Express Pin
Anoop Brijmohun19-Mar-08 3:48
Anoop Brijmohun19-Mar-08 3:48 
GeneralSSRS headache Pin
Vodstok18-Mar-08 4:47
Vodstok18-Mar-08 4:47 
GeneralRe: SSRS headache Pin
pmarfleet18-Mar-08 11:03
pmarfleet18-Mar-08 11:03 
GeneralReporting Services 2000 Pin
imnotso#18-Mar-08 4:13
imnotso#18-Mar-08 4:13 
Questionconvert EMPTY fields to NULL? Pin
John Sundar18-Mar-08 1:35
John Sundar18-Mar-08 1:35 
GeneralRe: convert EMPTY fields to NULL? Pin
Krish - KP18-Mar-08 1:43
Krish - KP18-Mar-08 1:43 
GeneralRe: convert EMPTY fields to NULL? Pin
Krish - KP18-Mar-08 2:01
Krish - KP18-Mar-08 2:01 
GeneralRe: convert EMPTY fields to NULL? Pin
John Sundar23-Mar-08 19:51
John Sundar23-Mar-08 19:51 
GeneralRe: convert EMPTY fields to NULL? Pin
SeeSharp18-Mar-08 21:10
SeeSharp18-Mar-08 21:10 
GeneralRe: convert EMPTY fields to NULL? Pin
John Sundar23-Mar-08 19:49
John Sundar23-Mar-08 19:49 
GeneralGetting StartDate and EndDate using SQL query Pin
meeram39518-Mar-08 0:08
meeram39518-Mar-08 0:08 
GeneralRe: Getting StartDate and EndDate using SQL query Pin
Krish - KP18-Mar-08 1:29
Krish - KP18-Mar-08 1:29 

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.