“select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005

by

sp_refreshview to fix the view, or use WITH SCHEMABINDING in the view definition

If a view is not created with the
SCHEMABINDING clause, sp_refreshview
should be run when changes are made to
the objects underlying the view that
affect the definition of the view.
Otherwise, the view might produce
unexpected results when it is queried.

More Related Contents:

  1. Get top 1 row of each group
  2. Insert results of a stored procedure into a temporary table
  3. Referring to a Column Alias in a WHERE Clause
  4. Convert Month Number to Month Name Function in SQL
  5. SET versus SELECT when assigning variables?
  6. How important is the order of columns in indexes?
  7. Generate a resultset of incrementing dates in TSQL
  8. Getting result of dynamic SQL into a variable for sql-server
  9. How to get difference between two rows for a column field?
  10. Better techniques for trimming leading zeros in SQL Server?
  11. How to print VARCHAR(MAX) using Print Statement?
  12. What’s the best way to select the minimum value from several columns?
  13. Concatenate values based on ID
  14. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  15. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  16. Splitting delimited values in a SQL column into multiple rows
  17. varbinary to string on SQL Server
  18. Dynamic SQL to generate column names?
  19. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. SQL Server 2005 ROW_NUMBER() without ORDER BY
  22. How to find consecutive rows based on the value of a column?
  23. Can an INNER JOIN offer better performance than EXISTS
  24. How to escape square brackets inside square brackets for field name
  25. How do you copy a record in a SQL table but swap out the unique id of the new row?
  26. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  27. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  28. Is there a quick way to check if ANY column is NULL?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment