Click here to Skip to main content
12,622,896 members (30,310 online)

Articles by zvin (Tip/Tricks: 4)

Tip/Tricks: 4

RSS Feed
No articles have been posted.
No blogs have been submitted.

Average tips rating: 4.85

Database
General
Posted: 21 Jun 2011   Updated: 25 Jun 2011   Views: 95,911   Rating: 4.70/5    Votes: 11   Popularity: 4.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Passing a datatable to a Stored Procedure in SQL Server 2008 which helps improve performance.
Programming Tips
General
Posted: 23 Jun 2011   Updated: 23 Jun 2011   Views: 10,330   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
When comparing data stored in databases, you don't need to use RTRIM()
Posted: 29 Jun 2011   Updated: 29 Jun 2011   Views: 11,910   Rating: 4.71/5    Votes: 3   Popularity: 2.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Use the SET FMTONLY ON and OFF option
String handling
General
Posted: 28 Sep 2011   Updated: 2 Oct 2011   Views: 4,131   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Splits string using TSQL, but a very simple technique using the XML datatype.
No reference articles have been posted.

zvin
Canada Canada
No Biography provided


Advertise | Privacy | Mobile
Web02 | 2.8.161128.1 | Last Updated 4 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid