Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SET @SQLString = 'USE ' +'['+ @Database_name +']'+ Char (13 ) +
  2. 'UPDATE STATISTICS ' +LTRIM(RTRIM(@SchemaName)) +'.'+ Ltrim(Rtrim(@TableName)) + ' WITH FULLSCAN'
  3. PRINT @SQLString
  4. EXEC (@SQLString)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement