Celebrities › Re: Davido Vs Burna Boy: Cubana Chief Priest Replies Burna Boy by samm(m): 2:15pm On May 23, 2020 |
|
Travel › Re: Abuja Vs Lagos: Which Is More Advisable For Relocation? by samm(m): 1:12pm On Mar 04, 2020 |
Was in your shoes not so long ago. It’s amusing reading the comments.
Abuja is the smart choice. |
Health › Re: Help. The Vitiligo Spreading On My Lips Is Making Me Suicidal (pics) by samm(m): 4:40pm On Jul 05, 2018 |
|
Programming › Re: Http Request/response Testing by samm(m): 11:33pm On Apr 02, 2017 |
|
Programming › Re: __ by samm(m): 7:48pm On Mar 27, 2017 |
alldbest: No errors actually, SQL server doesn't seem to recognize the exported file as a database backup.... What I'm calling the dump file is the exported copy of the database that is already hosted on plesk. What is the file extension of the exported file? Also, why can't you connect directly to the hosted database server using management studio? |
Programming › Re: __ by samm(m): 7:02pm On Mar 27, 2017 |
alldbest: Please I am having an issue with exported database dump file from plesk control panel..
I used SQL server and ASP.net for my project, I uploaded everything as usual, but now I need to make some modifications to my database definitions and attributes, after exporting the database to my local machine, I am having difficulties re-attaching the dump file to SQL SERVER management studio on my PC. How do I go about this? Thanks What errors are you getting? What exactly are you calling the dump file? |
Programming › Re: SQL Table Problem by samm(m): 8:57pm On Nov 28, 2016 |
I second Larisoft's recommendation as far as computing column B and C.
Select Year(EmploymentDate) - Year(Current_Timestamp) From YourTanleame
If you are already storing Employment Year: Select EmploymentYear - Year(Current_Timestamp) From YourTableName
However if you must store the current year and depending on your DB system (my example is based on MS SQL Server), you can do this:
Alter Table YourTableName Add CurrentYear AS (Year(Current_Timestamp))
Let me know if you need further clarification. |
Programming › Re: SQL Server by samm(m): 8:49pm On Nov 23, 2016 |
|
Programming › Re: SQL Best Design Practice by samm(m): 8:16pm On Sep 17, 2016 |
Optimally, you'll need to normalize your database. You need a single category table and a single product table. I'm assuming a category can have several products, and a product can be in one category. Category Table: category_id, category_name, category_description Product Table: product_id, category_id, product_name, product_description
With this setup, you can easily search for a product: where product_name = @product_name
You can return a product and it's category by joining both tables or even better you can create a view. Let me know if you need more help. |
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 10:02pm On Mar 31, 2015 |
Final result...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 5:57pm On Mar 31, 2015 |
donzie: bro you left sokoto out______APC 671920 PDP 152199 missed it..updated.
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 5:48pm On Mar 31, 2015 |
...so far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 4:09pm On Mar 31, 2015 |
....So far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:58pm On Mar 31, 2015 |
Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:47pm On Mar 31, 2015 |
hillsate: welldone! Would have been more nice if it shows percentage of votes won for States lost. It would have. Unfortunately, I don't have the total votes per state. |
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:29pm On Mar 31, 2015 |
....Results so far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:22pm On Mar 31, 2015 |
Results so far.....
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:11pm On Mar 31, 2015 |
....Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:03pm On Mar 31, 2015 |
youngdoctor: bros.u frget adamawa..APC-374701...PDP-251664. so recalculate Corrected and latest
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 3:02pm On Mar 31, 2015 |
Results so far....
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 2:39pm On Mar 31, 2015 |
...Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 2:38pm On Mar 31, 2015 |
Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 2:33pm On Mar 31, 2015 |
Results so far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 1:02pm On Mar 31, 2015 |
Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 12:38pm On Mar 31, 2015 |
Results so far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 12:09pm On Mar 31, 2015 |
Results so far
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 12:02pm On Mar 31, 2015 |
KeDv: Could someone compute the aggregate? Please. I hate the way this result is being drip fed.
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 12:00pm On Mar 31, 2015 |
Results so far...
|
Politics › Re: Jega's Announcement Of Presidential Election Results 2015: Part 4 by samm(m): 11:53am On Mar 31, 2015 |
Results so far
|
Politics › Re: Jega To Announce Presidential Election Results: Part 2 by samm(m): 9:37pm On Mar 30, 2015 |
Results so far
|
Business › Re: Gtbank's Latest Innovating Is Crazy by samm(m): 10:07am On Jul 02, 2014 |
|
Politics › Re: Stella Damasus And Senator Yerima On Al-jazeera Network THE STREAM by samm(m): 3:43pm On Sep 06, 2013*. Modified: 4:26pm On Sep 06, 2013 |
Why is this being argued only in the court of public opinion? Does it mean that the Federal Republic of Nigeria has accepted that this is legal? Where is the attorney general of the Federal republic of Nigeria?
We are arguing about the constitution on TV, nairaland, twitter, Facebook when we have offices appointed to clarify all laws. So when the dust settles....then what? |