MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 

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?

  •  

     
    Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

    (c) 1997, 2010 Bits on the Wire, Inc