SQL Server FAQ
SQL Server Development FAQ
Can I work with registry from within T-SQL?
How can I check from the SQL Server whether the file exists or not?
How can I copy text or image into or out of SQL Server?
How can I create extended stored procedures?
How can I decrypt a SQL Server stored procedure?
How can I delete duplicate rows?
How can I edit the system tables manually?
How can I enforce to use particular index?
How can I export a query result set into file?
How can I get only the specified number of rows from my query?
How can I make database to be read only?
How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?
How can I return from within a T-SQL the list of all available OLE DB providers?
How can I return from within a T-SQL the list of all character sets and code pages?
How can I return from within a T-SQL the list of server's DSNs?
How can I return from within a T-SQL the list of server's hard drives?
How can I return from within a T-SQL the list of Windows NT/2000 groups?
How can I select only date/time part of a datetime value?
How can I send a message to user from the SQL Server?
How can I set database to a single user mode?
How can I use a variable for the columns/tables in the select statements?
How do I add 'n' working days to the given date and get the result date?
How do I delete a particular value for a key in the registry via Transact-SQL?
How do I delete an entire key from the registry via Transact-SQL?
How do I execute an operating-system command via Transact-SQL?
How do I get the date the object was created?
How do I get working days between two dates?
How do I move tables from one filegroup to another?
How do I perform the same actions for all databases?
How do I perform the same actions for all tables in a database?
How do I read from the registry via Transact-SQL?
How do I return the first day of the month for the given date?
How do I reset the identity column?
How do I return the last day of the month for the given date?
How do I run a DTS package from the Query Analyzer or stored procedure?
How do I run a T-SQL script through SQL-DMO?
How do I run SQL script located on the disk file, using Transact-SQL?
How do I write to the registry via Transact-SQL?
How to install SQL scripts and import data to SQL Server from the command line?
Is it possible to work with COM objects from within T-SQL?
Why SELECT INTO statement does not work?