Sun Application Server Startup Command: /opt/SUNWappserver/bin/asadmin start-domain --domaindir /opt/SUNWappserver/domains --user admin

Wednesday, January 03, 2007

Add/Update/Delete/Select comment on SQL Server 2000

EXEC sp_addextendedproperty 'MS_Description', 'Employee ID', 'user', dbo, 'table', employee, 'column', empId

EXEC sp_updateextendedproperty 'MS_Description', 'Employee ID', 'user', dbo, 'table', employee, 'column', empId

EXEC sp_dropextendedproperty 'caption', 'user', dbo, 'table', 'employee', 'column', empId

SELECT *
FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'employee', 'column', default)

No comments: