for an given input i need to get desired output Input table1 +----------------------+ id | coursename +-----------------------+ 1 SQL 2 Artificial Intelligence 3 Machine Learning table2 +---------------------------+ id | teachername +----------------------------+ 1 shreya 1 ramya 2 darshan 2 ravi table3…
I published my site on plesk, in login form when I enter username and password I get error. I should say that my login form is based on asp.net configuration and roles and users are set there. System.Data.SqlClient.SqlException (0x80131904): A…
I have a plesk account and an MS SQL database from which I got a dump through this interface they provide: So I downloaded the dump file but it does not come as a .txt file but it comes without…
i upgradefrom php version 2.2 to 2.4 and php 5.6 too. The problem is with the new php the function does not support mssql_connect so i installed the new driver for sqlsvr and when i made the Database connection it…
I want to connect and Request from MSSQL using nodejs to link it with magento. I Am trying to fix it for days now but it ends on the same way... This is my Error Code: Connected { RequestError: Requests…
I have the following table with child parent relationship. ID Title PageID IsParent ParentID IsActive 1 Dashboard 2125 True NULL True 2 Site Analytics 22 False NULL True 3 SEO Management 1 NULL NULL True 4 Mail Management 32 NULL…
I have to access my arvixe.com database in my SQL Server Management Studio 2014. Can Anybody guide me? Screenshot attached. What was the problem with it
I need to write the Titles of songs in a SEO frienly format, following a few rules given to me. The maximum lentgh is 52 characters. Currently the truncation occurs for records that begin with a CL, and that pertain…
I've just taken care of a project that requires converting data from the old website (built in C# web form) to the new one (using PHP). In the old database, there is a product table contains 1600 products that I…
The Situation I come from PHP + MySQL background and I'm migrating an ASP website. I've migrated them a few times before, but in this case I'm encountering a couple of issues that disorient me and are preventing me from…