Thursday, April 2, 2020

English to Bangla Digit Conversion and vice-versa

Sunday, March 22, 2020

This simple php script will help to display bangla date in following format. e.g. আজঃ ১৭-পৌষ-১৪২৬ (বুধবার)

Use

include_once("./BanglaDate.php");
$bdate = new BanglaDate();

echo "".$bdate->PrintEngDate()."<br />";
echo "".$bdate->PrintBanglaDate()."<br />";

Just write down the PrimaryTableName

and execute below query.

SELECT OBJECT_NAME (FK.referenced_object_id) 'Referenced Table', 

OBJECT_NAME(FK.parent_object_id) 'Referring Table', 

FK.name 'Foreign Key', 

COL_NAME(FK.referenced_object_id, 

FKC.referenced_column_id) 'Referenced Column',

 COL_NAME(FK.parent_object_id,FKC.parent_column_id) 'Referring Column'

FROM sys.foreign_keys AS FK

INNER JOIN sys.foreign_key_columns AS FKC 

ON FKC.constraint_object_id = FK.OBJECT_ID

WHERE OBJECT_NAME (FK.referenced_object_id) = 'PrimaryTableName'

If you want to check multiple Primary Table then just replace 

OBJECT_NAME (FK.referenced_object_id) = 'PrimaryTableName' by 

OBJECT_NAME (FK.referenced_object_id) in 

('PrimaryTable1','PrimaryTable2','PrimaryTable2')