Articles by zvin (Tip/Tricks: 4)

No articles have been posted.

No blogs have been submitted.

Database Development
SQL Server	Passing a datatable to a Stored Procedure in SQL Server 2008 [Tip/Trick] 21 Jun 2011 Updated: 25 Jun 2011 Rating: 4.70/5 Votes: 11 Popularity: 4.70 Licence: CPOL Views: 134,501 Bookmarked: 20 Downloaded: 0 Please Sign up or sign in to vote. Passing a datatable to a Stored Procedure in SQL Server 2008 which helps improve performance.
	Trailing spaces are ignored in SQL Server 2008 [Tip/Trick] 23 Jun 2011 Updated: 23 Jun 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 16,390 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. When comparing data stored in databases, you don't need to use RTRIM()
	Best practice when getting the structure of the resulting query or table. [Tip/Trick] 29 Jun 2011 Updated: 29 Jun 2011 Rating: 4.71/5 Votes: 3 Popularity: 2.25 Licence: CPOL Views: 16,380 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Use the SET FMTONLY ON and OFF option
Programming Languages
T-SQL	Yet another string splitter [Tip/Trick] 28 Sep 2011 Updated: 2 Oct 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,580 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Splits string using TSQL, but a very simple technique using the XML datatype.