sql-server-2005 (672)

  1. alter table add column with default value in sql - Add a column with a default value to an existing table in SQL Server
  2. how to insert data into temp table from stored procedure in sql server - Insert results of a stored procedure into a temporary table
  3. update query with inner join in sql server - How can I do an UPDATE statement with JOIN in SQL?
  4. sql-server - sql check if table exists before creating - Check if table exists in SQL Server
  5. update query with inner join in sql server - SQL update query using joins
  6. sql-server - drop temp table if exists sql server 2016 - Check if a temporary table exists and delete if it exists before creating a temporary table
  7. sql-server - sql insert multiple rows from select - How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?
  8. select top 1 from each group sql server 2008 - Get top 1 row of each group
  9. sql-server - how to truncate table with foreign key constraint in sql server 2012 - Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

  10. sql-server - sql server index include all columns - Why use the INCLUDE clause when creating an index?
  11. sql-server - connect to sql server management studio with port number - How do you specify a different port number in SQL Management Studio?
  12. sql count distinct group by - SQL Server query - Selecting COUNT(*) with DISTINCT
  13. sql group_concat - Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  14. sql - nvarchar(max) performance - Are there any disadvantages to always using nvarchar(MAX)?
  15. c# - how to declare double datatype in sql server - What represents a double in sql server?
  16. sql-server - close all connections to database sql server 2014 - How do you kill all current connections to a SQL Server 2005 database?
  17. divide by zero error encountered in sql server stored procedure - How to avoid the “divide by zero” error in SQL?
  18. drop all tables sql - Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  19. cancel take database offline - Extreme wait-time when taking a SQL Server database offline
  20. how to assign the top 1 value to a variable+sql - Dynamic SELECT TOP @var In SQL Server