I am designing an online store (ASP.NET Core 6) for an accounting software (C# Winforms). I started this using ASP.NET Core and Razor pages. I am new and inexperienced in this field. The accounting software has many tables in SQL…
I'm trying to make an autoincrement code with date and it will reset the code on the other day. I have this migration. public function up() { Schema::create('records', function (Blueprint $table) { $table->id(); //other codes here... }); } Then, I…
We have real old server running DTS packages and SSMS 2008 or older. We need to transfer our DB to new server that can also run PHP applications. What do I need to do to set it up? Thank you,
I have an Azure SQL Server resource for which I'm the Azure AD admin. I have provided the resource access "Contributor" to another user who cannot access the database through SQL Server Management Studio as he is receiving the following…
Table: id | name 1 | a,b,c 2 | b Output id | name 1 | a 1 | b 1 | c 2 | b I found this query online and it works fine in mySql Phpmyadmin query editor.…
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 can't connect to database. i have these extension php_pdo_sqlsrv_72_ts_x64.dll, php_sqlsrv_72_ts_x64 and added "extension = php_sqlsrv_72...." line in php.ini file. What am i doing wrong? Unable to connect to your database server using the provided settings. Filename: C:/Apache24/htdocs/smartattendanceciwec/system/database/DB_driver.php Line Number:…
We are developing a site at work for the xmas/new year period where individuals can buy/sell what they want its for charity basically, look at it as a smaller version of ebay. We currently have 15 parent categories, and these…
my target was to moved all the mssql databases from sql server management studio express 2005 server to sql server management studio express 2008 server. For this i first created the databases and the users in the new server via…
I have a .bak file and want to convert it into .sql file to restore it on my Windows shared hosting. How can I do this? I can't restore directly using MSSMS because I get the error user has no…