Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
SELECT DISTINCT c.TABLE_NAME TableName, i.[name] IndexName, c.CONSTRAINT_NAME ConstraintName, k.COLUMN_NAME ColumnName FROM SYS.INDEXES I INNER JOIN SYS.ALL_OBJECTS O ON I.[OBJECT_ID] = O.[OBJECT_ID] INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS C ON O.NAME = C.TABLE_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE K ON C.TABLE_NAME = K.TABLE_NAME WHERE c.TABLE_NAME NOT IN ('sysdiagrams','dtproperties') ORDER BY C.TABLE_NAME
|2016 SQL Licensing||7||40|
|I'm looking to copy specific data from one SQL table to another, and need help with the query.||5||18|
|Query group by data in SQL Server - cursor?||3||29|
|Update a text value in another table||10||38|