Viewing 3 posts - 1 through 3 (of 3 total)
Hallo,
very good function often needed.
German SQLservers need adaptation.
Since Wednesday in German "Mittwoch" gets corrupted by the MI=minute mask, some workarounds are necessary. I added month and day without leading zero.
/*
YYYY...
October 18, 2013 at 12:22 pm
simpler statement
select object_name(referenced_object_id) as PrimaryKeyTable
,object_name(parent_object_id) as ForeignKeyTable
,*
fromsys.foreign_keys
whereobject_name(referenced_object_id) like '%mySearchedPrimaryKeyTable%'
order by object_name(referenced_object_id)
,object_name(parent_object_id)...
October 27, 2009 at 8:02 am
drop table Sample_table
CREATE TABLE #Sample_table (Particulars varchar(120))
GO
INSERT INTO #Sample_table VALUES('LDR ; LUC20031026901 ; Vehicle')
INSERT INTO #Sample_table VALUES('LDR ; Consolidated ')
INSERT INTO #Sample_table VALUES('LDR ; SUB35030172701 ; Building')
INSERT INTO #Sample_table VALUES('LDRR...
September 13, 2004 at 4:27 pm
Viewing 3 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy