Another great post by the SQL Server Memory Guru: here
Also check out this suggestion coming from Greg Low (MVP). Although it is a feature in Oracle I still think it is a great idea :-) Being able to define your variable type as the column type gets rid of the sometimes painful type mismatches between parameters/variables and column data types. Having the wrong datatype can cause very odd behavior from the Query Optimizer. It also saves you a lot of work when you change the datatype of a specific column. Go VOTE :-D
From the suggestion: DECLARE @TradingName dbo.Customers.TradingName
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment