首页 \ 问答 \ 在SQL Server中添加外键约束的问题？(Issues with adding foreign key constraint in SQL Server?)

在SQL Server中添加外键约束的问题？(Issues with adding foreign key constraint in SQL Server?)

 我正在使用SQL Server，我需要将一个外键添加到现有的表中。  
 问题是作为外键的列已经在另一个表中具有一些不一致的值（不作为主键出现）。  
 我想知道，当我改变表并添加外键约束时，具有外键约束的表中的行会发生什么，它具有不一致的值？  
 --Neeraj 

I am using SQL Server, and I need to add a foreign key to an already existing table. 
The issue is the column which will act as the foreign key already has a few inconsistent values (which do not occur as a primary key) in another table. 
I was wondering, when I alter the table and add the foreign key constraint, what will happen to the rows in the table with foreign key constraint , which has inconsistent values?? 
--Neeraj

原文：https://stackoverflow.com/questions/5740339

更新时间：2023-03-29 18:03

最满意答案

 请理解Javascript是客户端代码，PHP是服务器端代码。  
 您可以实现两种可能的方式或方案：  
 
  如果您想在将JS文件发送到客户端之前对其进行操作，则可以将Javascript文件重命名为.php扩展名并编写php代码以提供变量。 对于Ex： 
<?php   
// write php code to create a string of values using a for loop  

$price_array_string = "'&#36; 16.95','&#36; 30.95','&#36; 49.95',
     '&#36; 70.95','&#36; 99.95','&#36; 109.95','&#36; 139.95','&#36; 155.95','&#36; 199.95','&#36; 460.95'";


// Javscript Code var price_arr = new Array(`<?`php echo $price_array_string ?>);
 
  另一种方法是通过向PHP Web服务发出Ajax请求来获得price数组的值。  

Please understand that Javascript is Client Side code and PHP is server side code.  
There can be 2 possible ways or scenarios which you want to achieve: 
 
 If you want to manipulate the JS file before sending it to client, you can rename the Javascript file to have .php extension and write php code to provide a variable. For Ex:
 <?php   
// write php code to create a string of values using a for loop  

$price_array_string = "'&#36; 16.95','&#36; 30.95','&#36; 49.95',
     '&#36; 70.95','&#36; 99.95','&#36; 109.95','&#36; 139.95','&#36; 155.95','&#36; 199.95','&#36; 460.95'";


// Javscript Code var price_arr = new Array(`<?`php echo $price_array_string ?>);
 
 The other alternative is that you get the value of price array by making an Ajax Request to a PHP web service.

在SQL Server中添加外键约束的问题？(Issues with adding foreign key constraint in SQL Server?)

最满意答案

相关问答

javascript变量到php脚本[重复](javascript variable to php script [duplicate])[2019-06-20]

PHP中的Javascript变量(Javascript variable in PHP)[2023-06-27]

使用AJAX通过PHP变量更新URL(Update URL with PHP Variable by AJAX)[2021-12-28]

相关文章

最新问答