Click here to Skip to main content
13,347,168 members (60,564 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: 107,750   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: 12,020   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: 12,790   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,960   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 |
Web02 | 2.8.180111.1 | Last Updated 18 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid