Click here to Skip to main content
15,907,233 members
Home / Discussions / C#
   

C#

 
GeneralGenerics - How to implement Compare Methods Pin
gunner_uk200019-Dec-07 2:27
gunner_uk200019-Dec-07 2:27 
GeneralRe: Generics - How to implement Compare Methods Pin
OsoreWatashi19-Dec-07 2:52
OsoreWatashi19-Dec-07 2:52 
GeneralRe: Generics - How to implement Compare Methods Pin
LongRange.Shooter19-Dec-07 11:18
LongRange.Shooter19-Dec-07 11:18 
QuestionCapturing messeges from other program Pin
OsoreWatashi19-Dec-07 2:14
OsoreWatashi19-Dec-07 2:14 
AnswerRe: Capturing messeges from other program Pin
TJoe20-Dec-07 3:11
TJoe20-Dec-07 3:11 
GeneralRe: Capturing messeges from other program Pin
OsoreWatashi28-Dec-07 3:45
OsoreWatashi28-Dec-07 3:45 
General[Message Deleted] Pin
eyeseetee19-Dec-07 1:02
eyeseetee19-Dec-07 1:02 
GeneralRe: strange problem with stored procedure Pin
Pete O'Hanlon19-Dec-07 1:18
mvePete O'Hanlon19-Dec-07 1:18 
Jamie1985 wrote:
CREATE PROCEDURE create_temp_itemschedule AS

CREATE TABLE temp_itemschedules (
Item_Schedule_ID int,
Item_Ref nvarchar (10),
room_code nvarchar (14),
instance_variant int,
ignore_flag nvarchar (1),
Qty_New int,
ADB19_2_Qty int,
Qty_Trans int,
Revision_Version nvarchar (50),
Revision_By nvarchar (50),
Revision_Date smalldate (4),
Revision_Source Ntext,
Notes Ntext)
GO


Jamie - the way to test something like this is to take the statements out and attempt them by yourself in SQL Server. If you had done this, you would have found the reason in a matter of seconds, namely that there is no smalldate datatype in SQL Server (and you need to remove the size of the same field as well - if it's a date it doesn't need a size specifying).

Deja View - the feeling that you've seen this post before.

My blog | My articles



GeneralRe: Deleted Message Pin
Paul Conrad24-Dec-07 19:44
professionalPaul Conrad24-Dec-07 19:44 
QuestionC#:Doubt in event handler? Pin
kssknov19-Dec-07 0:14
kssknov19-Dec-07 0:14 
GeneralRe: C#:Doubt in event handler? Pin
Giorgi Dalakishvili19-Dec-07 0:25
mentorGiorgi Dalakishvili19-Dec-07 0:25 
GeneralRe: C#:Doubt in event handler? Pin
Xmen Real 19-Dec-07 3:41
professional Xmen Real 19-Dec-07 3:41 
GeneralEntering null values from ComboBox Pin
AndrusM18-Dec-07 23:57
AndrusM18-Dec-07 23:57 
QuestionC#: How to change the color of a disabled textbox? Pin
kssknov18-Dec-07 22:45
kssknov18-Dec-07 22:45 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Pete O'Hanlon18-Dec-07 23:02
mvePete O'Hanlon18-Dec-07 23:02 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
kssknov19-Dec-07 0:12
kssknov19-Dec-07 0:12 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Paul Conrad24-Dec-07 19:47
professionalPaul Conrad24-Dec-07 19:47 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Pete O'Hanlon19-Dec-07 0:51
mvePete O'Hanlon19-Dec-07 0:51 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Kalvin @ Work19-Dec-07 3:17
Kalvin @ Work19-Dec-07 3:17 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Xmen Real 19-Dec-07 3:47
professional Xmen Real 19-Dec-07 3:47 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
V.19-Dec-07 4:26
professionalV.19-Dec-07 4:26 
GeneralRe: C#: How to change the color of a disabled textbox? Pin
Dan Neely19-Dec-07 5:00
Dan Neely19-Dec-07 5:00 
GeneralArray list implementation in .Net Framework Pin
King Shez18-Dec-07 22:37
King Shez18-Dec-07 22:37 
GeneralRe: Array list implementation in .Net Framework Pin
Giorgi Dalakishvili18-Dec-07 22:46
mentorGiorgi Dalakishvili18-Dec-07 22:46 
GeneralRegular expression - problem! Pin
Kolo18-Dec-07 21:39
Kolo18-Dec-07 21:39 

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.