tsql 783

  1. How do I UPDATE from a SELECT in SQL Server?
  2. How to check if a column exists in a SQL Server table?
  3. How to return only the Date from a SQL Server DateTime datatype
  4. Insert results of a stored procedure into a temporary table
  5. Inserting multiple rows in a single SQL query?


  6. How do I perform an IF…THEN in an SQL SELECT?
  7. LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
  8. How can I remove duplicate rows?
  9. How can I do an UPDATE statement with JOIN in SQL?
  10. Altering a column: null to not null
  11. Best way to get identity of inserted row?
  12. Check if table exists in SQL Server
  13. Get size of all tables in database
  14. Find all tables containing column with specified name - MS SQL Server
  15. When should I use Cross Apply over Inner Join?
  16. How can foreign key constraints be temporarily disabled using T-SQL?
  17. How do I get list of all tables in a database using TSQL?
  18. Update a table using JOIN in SQL Server?
  19. Should I use != or <> for not equal in T-SQL?
  20. How do I escape a single quote in SQL Server?
  21. Function vs. Stored Procedure in SQL Server
  22. DateTime2 vs DateTime in SQL Server
  23. SQL Server: How to Join to first row
  24. How can I list all foreign keys referencing a given table in SQL Server?
  25. SQL update query using joins
  26. SQL exclude a column using SELECT * [except columnA] FROM tableA?
  27. How can I get column names from a table in SQL Server?
  28. How do I create a unique constraint that also allows nulls?
  29. SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported
  30. T-SQL: Selecting rows to delete via joins
  31. How do I split a string so I can access item x?
  32. Best approach to remove time part of datetime in SQL Server
  33. How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?
  34. Select statement to find duplicates on certain fields
  35. What is the significance of 1/1/1753 in SQL Server?
  36. Select columns from result set of stored procedure
  37. Get top 1 row of each group
  38. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  39. How to do SQL Like % in Linq?
  40. Replace a newline in TSQL
  41. SQL Server SELECT into existing table
  42. Sleep Command in T-SQL?
  43. SQL Server query - Selecting COUNT(*) with DISTINCT
  44. How to select all records from one table that do not exist in another table?
  45. How do I obtain a Query Execution Plan?
  46. SELECT INTO a table variable in T-SQL
  47. T-SQL Cast versus Convert
  48. What is the difference between SQL, PL-SQL and T-SQL?
  49. SQL MAX of multiple columns?
  50. Is it possible to specify condition in Count()?