Without seeing the table structure,If you are interested in knowing which columns uniquely identify a row in a table, you can use this system procedure EXEC sp_special_columns table_name...(read more)
A
New
Internet
Library: Add Your Website/Blog
or Suggest A Website/Blog to our Free Web Directory
http://anil.myfunda.net.
Its very simple, free and SEO Friendly. Submit Now....
Its very simple, free and SEO Friendly. Submit Now....
Blog Archive
-
▼
2009
(102)
-
▼
March
(23)
- Filling random passwords - Set based approach
- SQLBits IV
- SQL Solutions OLAP Heartbeat and OLAP Performance ...
- Splitting delimited data to columns - Set based ap...
- Return TOP N rows
- Export to EXCEL with column names
- SQL_VARIANT_PROPERTY function
- Time Calculation on Numbers
- Row_number() Function with no specific order
- Script of DDL triggers
- NULL on joined columns
- Happy New Year
- Compatibility Level of a database
- Find Alphanumerals only
- SQL_VARIANT datatype and behaviour changes
- Beware of the Usage of SET ROWCOUNT
- Which columns uniquely identify a row?
- Behavior Changes to Database Engine Features in SQ...
- BI Survey 8
- Query behaviour when you cross the LowMemoryLimit
- Analysis Services and the System File Cache
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
March
(23)