sql server - In stored procedure if null value found it should skip that insert query -


i have 2 tables 1 

peson contains(personid identity, firstname,lastname,placeofbirth,gender)

and 

education contains (eduid identity, egreename,boarduniver,yearofpassing,obtainedmarks, personid)

now problem each person have more 1 degree, have 1 or 2 degree, how can skip insert queries?

first table

create table person(personid int identity(1,1) primary key, firstname nvarchar(40), lastname nvarchar(40), placeofbirth nvarchar(40), gender nvarchar(10))

second table

create table education(eduid int identity(1,1) primary key, degreename nvarchar(40), boarduniver nvarchar(40), yearofpassing nvarchar(40), obtainedmarks numeric(10,2), personid int,  constraint fk_eduperson foreign key (personid) references person(personid))

procedure store information

create procedure empdetails (     @firstname nvarchar(40),  @lastname nvarchar(40), @placeofbirth nvarchar(40), @gender nvarchar(8),      @degreename0 int, @boarduniver0 nvarchar(40), @yearofpassing0 nvarchar(20), @obtainedmarks0 int,     @degreename1 int, @boarduniver1 nvarchar(40), @yearofpassing1 nvarchar(20), @obtainedmarks1 int,     @degreename2 int, @boarduniver2 nvarchar(40), @yearofpassing2 nvarchar(20), @obtainedmarks2 int,  ) begin declare @personid int insert person(firstname,lastname,placeofbirth,gender) values(@firstname,@lastname,@placeofbirth,@gender) select @personid=@@identity if(@degreename0 !=null)     begin     insert education(degreename,boarduniver,yearofpassing,obtainedmarks, personid) values (@degreename0,@boarduniver0,@yearofpassing0,@obtainedmarks0, @personid)     end if(@degreename1 !=null)   begin     insert education(degreename,boarduniver,yearofpassing,obtainedmarks, personid) values (@degreename1,@boarduniver1,@yearofpassing1,@obtainedmarks1, @personid)   end if(@degreename2!=null)    begin     insert education(degreename,boarduniver,yearofpassing,obtainedmarks, personid) values (@degreename2,@boarduniver2,@yearofpassing2,@obtainedmarks2,@personid)     end end

this not working.. inserts rows empty.. there other solution this? please give suggestion if other..

try is not null instead of != null. in relational databases, comparison operators return false if either input null, if both are. here sql fiddle demonstrating behavior.

(sorry. sql fiddle works.)

admittedly, confusing, fact should mean inserts skipped. don't see here insert empty rows.


Comments

Post a Comment

Popular posts from this blog

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

vb.net - Virtual Keyboard commands -

i wondering difference between virtual these keyboard commands is: keyeventf_extendedkey , keyeventf_keyup is. everywhere have looked gives me description based off integers , not want know each of them does. you've tagged question vb.net, these have nothing @ vb.net. they're constants defined in windows header files, use win32 api functions. as far difference, can't tell looking @ values. individual values not particularly important, that's why named identifiers used. what's important used , documentation functions tells mean. the first one, keyeventf_extendedkey , used keybdinput structure (which used along e.g. sendinput function) pass information synthesized keyboard input. if flag used, means scan code should interpreted extended key. technically, means scan code preceded prefix byte value 224 (&he0 in hexadecimal notation). the second one, keyeventf_keyup , 1 of flags available use structure. means key being released (going up)...
Read more

How to get multiresult with multicondition in Sql Server -

i need solve this. hopefully can giving me advices. for sample, i've got data : proclib.march 1 first 10 rows flight date depart orig dest miles boarded capacity ----------------------------------------------------------------- 114 01mar94 7:10 lga lax 2475 172 210 202 01mar94 10:43 lga ord 740 151 210 219 01mar94 9:31 lga lon 3442 198 250 622 01mar94 12:19 lga fra 3857 207 250 132 01mar94 15:35 lga yyz 366 115 178 271 01mar94 13:17 lga par 3635 138 250 302 01mar94 20:22 lga 229 105 180 114 02mar94 7:10 lga lax 2475 119 210 202 02mar94 10:43 lga ord 740 120 210 219 02mar94 9:31 lga lon 344...
Read more