sql server - Prevent INSERT of NULL values for Stored Procedure -

-

i'm working on stored procedure supposed update table order_truckdelivery info table basket_truckdelivery if second table has data. there 2 columns in each of tables: int id , datetime column called truckdeliverydate. if basket_truckdelivery has date stored current basket id, insert date order_truckdelivery table.

right now, insert execute regardless if there in basket_truckdelivery table, , results in null value truckdelverydate column in order_truckdelivery column. want prevent happening not entirely sure how. basically, want perform , insert order_truckdelivery table if value of truckdeliverydate in basket_truckdelivery not empty or null.

this have far...i have not done work stored procedures, not sure i've missed....

alter procedure [dbo].[savetruckintoorder]     @basketid int,      @orderid int begin    -- set nocount on added prevent result sets    -- interfering select statements.    set nocount on;     -- insert statements procedure here    declare       @truckdeliverydate datetime     if(exists(select uidbasket [basket_truckdelivery] [uidbasket] = @basketid))    begin          select             @truckdeliverydate = [truckdeliverydate]                       [basket_truckdelivery]                       [uidbasket] = @basketid    end     begin        insert [order_truckdelivery] ([uidorder], [truckdeliverydate])        values (@orderid, @truckdeliverydate)    end end 

alter procedure [dbo].[savetruckintoorder] @basketid int     ,@orderid int begin     set nocount on;      declare @truckdeliverydate datetime      if (             exists (                 select uidbasket                 [basket_truckdelivery]                 [uidbasket] = @basketid                 )             )     begin         select @truckdeliverydate = [truckdeliverydate]         [basket_truckdelivery]         [uidbasket] = @basketid     end      if (             @truckdeliverydate not null             , @truckdeliverydate != ''             )     begin         insert [order_truckdelivery] (             [uidorder]             ,[truckdeliverydate]             )         values (             @orderid             ,@truckdeliverydate             )     end end

Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple ...
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e...
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </...
Read more