141 reputation
16
bio website naya-tech.co.il
location Israel
age 24
visits member for 1 year, 5 months
seen 6 hours ago

hi my name is Shimon, I am a SqlServer DBA in a large organization, i am experienced with MongoDB MySql C# JS vb.net vba html css TSQL and performance tuning

i'm not crazy, my mother had me tested --sheldon cooper


Jun
30
comment how to write code in order to update stock after we sell a product
U can insert nothing to the table and it wont matter, but when there are values they will be inserted to the table as well and everybody is happy... or use a stored procedure that gets all the required parameters and call it from your php code, its a safer and better solution and my favorite!
Jun
30
comment how to write code in order to update stock after we sell a product
so you are fine.
Jun
29
comment how to write code in order to update stock after we sell a product
read this.. its secure but not enough stackoverflow.com/questions/6366428/…
Jun
29
comment how to write code in order to update stock after we sell a product
your code is not secure for injections!
Jun
25
comment Should I add it as an additional column or a seperate table?
you can make it accept nulls, or insert the division before the region. its more a question of how you use it and write to the db..
Jun
24
answered How to print ORDER wise using LEFT JOIN in SQL?
Jun
24
answered Save different account types in a database
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
and you should check to see if its really damages the performance because you cant guess stuff like that without making a real check
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
so you need to use a stored procedure or collect the table data once on each run to a local db and run the query there
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
run the cte/query for each one of the inputs you have and you will get correct results
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
you cant use it with in(value1,value2,...)
Jun
24
revised how to select column3 from rec1 value which is matched to column1 val in rec2
added 139 characters in body
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
thats not a stored procedure... and you dont need the create table / drop table / insert parts of the code because you allready have the data and table
Jun
24
answered how to select column3 from rec1 value which is matched to column1 val in rec2
Jun
24
revised Should I add it as an additional column or a seperate table?
deleted 2 characters in body
Jun
24
answered Should I add it as an additional column or a seperate table?
May
16
awarded  Popular Question
Apr
22
answered Query multiple rooms with different conditionals (Adults, Children)
Apr
22
answered ORM for Image model
Apr
22
accepted Is it impossible to store 2^266 records on a database of some kind?