WHERE x.name = other alternative (which should definitely be considered if dealing with more than one filter criteria) is to use dynamic SQL. Numeric Conversions: SQL Server Use the CONVERT function for conversions to and from numeric values: CONVERT(datatype(length), expression, style) Table. If dealing with a single parameter, using an IF ELSE would perform better: IF = 1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |