Viewing 15 posts - 4,066 through 4,080 (of 8,416 total)
AndrewSQLDBA (4/7/2010)
PaulI was not referring to your query. I have not tried that one yet. You posted that while I was typing my last post.
I know - mine is just...
April 7, 2010 at 6:28 am
Paul White NZ (4/4/2010)
There are answers to most connectivity problems on the SQL Server Protocol Team's blog:http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx
...etc.
From earlier. 🙂
Not the same link exactly, but the same blog.
Might have saved...
April 7, 2010 at 6:25 am
David Fulton-420388 (4/7/2010)
April 7, 2010 at 6:22 am
AndrewSQLDBA (4/7/2010)
That one is close, but I would like to know, what the other table name and column name for each primary key listed in the query.
You just want to...
April 7, 2010 at 6:21 am
PaulB-TheOneAndOnly (4/7/2010)
...and as Paul points it out the word "always" you used in a related post is a little too much. This is totally out of context.
That was Jason, but...
April 7, 2010 at 6:17 am
...and for fun value:
SELECT [schema_name] = QUOTENAME(SCHEMA_NAME(KC.[schema_id])),
table_name = QUOTENAME(OBJECT_NAME(KC.parent_object_id)),
constraint_name = QUOTENAME(KC.name),
...
April 7, 2010 at 6:14 am
If you are looking for sys.primary_keys ... it's not there - primary keys are listed together with unique keys under sys.key_constraints
Relationship column details are found in sys.foreign_key_columns
April 7, 2010 at 5:42 am
April 7, 2010 at 5:30 am
chandrasekaran.ganapathy (4/7/2010)
Can you please explain this code little bit?
Links:
Cascading Referential Integrity Constraints
Post back if you have any questions.
April 7, 2010 at 5:16 am
Mr_Bacon (4/7/2010)
April 7, 2010 at 5:11 am
Kingston Dhasian (4/7/2010)
My eyes were wide open for at least 5 seconds as to what i am seeing.:w00t:
Ah, then my work here is done :laugh:
Thanks for opening my eyes, Paul:-)
No...
April 7, 2010 at 5:09 am
David Jackson (4/7/2010)
I have persevered with mine and while it's not as elegant as yours, it seems to do the job, and as...
April 7, 2010 at 5:05 am
If your table is relatively small, something like this is simplest:
DECLARE @test-2
TABLE (
ID INTEGER NOT...
April 7, 2010 at 4:49 am
honza.mf (4/7/2010)[hrThere is only one complication with negative queries I mentioned above. Easy to solve but hard to explain to (some) non-developpers. "I want to see all records that don't...
April 7, 2010 at 4:36 am
Simon_L (4/7/2010)
many thanks Paul ... god I was making life complicated with my code...
No worries, Simon! 😎
Resist the evil lures of the cursor!
April 7, 2010 at 4:32 am
Viewing 15 posts - 4,066 through 4,080 (of 8,416 total)