sql-server 2351

  1. How do I UPDATE from a SELECT in SQL Server?
  2. Add a column with a default value to an existing table in SQL Server
  3. How to check if a column exists in a SQL Server table?
  4. How to concatenate text from multiple rows into a single text string in SQL server?
  5. How to return only the Date from a SQL Server DateTime datatype


  6. Insert results of a stored procedure into a temporary table
  7. Inserting multiple rows in a single SQL query?
  8. How do I perform an IF…THEN in an SQL SELECT?
  9. LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
  10. How can I remove duplicate rows?
  11. What is the difference between varchar and nvarchar?
  12. Table Naming Dilemma: Singular vs. Plural Names
  13. How can I do an UPDATE statement with JOIN in SQL?
  14. Altering a column: null to not null
  15. Parameterize an SQL IN clause
  16. Best way to get identity of inserted row?
  17. Check if table exists in SQL Server
  18. Get size of all tables in database
  19. How to Delete using INNER JOIN with SQL Server?
  20. Find all tables containing column with specified name - MS SQL Server
  21. What do Clustered and Non clustered index actually mean?
  22. When should I use Cross Apply over Inner Join?
  23. Difference between JOIN and INNER JOIN
  24. How can foreign key constraints be temporarily disabled using T-SQL?
  25. SQL update from one Table to another based on a ID match
  26. How do I get list of all tables in a database using TSQL?
  27. Update a table using JOIN in SQL Server?
  28. Should I use != or <> for not equal in T-SQL?
  29. How do I escape a single quote in SQL Server?
  30. Function vs. Stored Procedure in SQL Server
  31. Count(*) vs Count(1) - SQL Server
  32. DateTime2 vs DateTime in SQL Server
  33. How do I save a stream to a file in C#?
  34. Search text in stored procedure in SQL Server
  35. SQL Server: How to Join to first row
  36. How can I list all foreign keys referencing a given table in SQL Server?
  37. What is “with (nolock)” in SQL Server?
  38. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  39. SQL update query using joins
  40. SQL exclude a column using SELECT * [except columnA] FROM tableA?
  41. How to drop a table if it exists in SQL Server?
  42. How do you clear the SQL Server transaction log?
  43. How can I get column names from a table in SQL Server?
  44. How do I create a unique constraint that also allows nulls?
  45. Solutions for INSERT OR UPDATE on SQL Server
  46. Multiple Indexes vs Multi-Column Indexes
  47. Check if a temporary table exists and delete if it exists before creating a temporary table
  48. What is the best way to auto-generate INSERT statements for a SQL Server table?
  49. Rename column SQL Server 2008
  50. SQL Server: Database stuck in “Restoring” state