Click here to Skip to main content

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.87

Database
General
Posted: 21 Jun 2011   Updated: 25 Jun 2011   Views: 58,474   Rating: 4.78/5    Votes: 9   Popularity: 4.65
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   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: 6,370   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
When comparing data stored in databases, you don't need to use RTRIM()
Posted: 29 Jun 2011   Updated: 29 Jun 2011   Views: 9,647   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: 3,265   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
Web03 | 2.8.1411023.1 | Last Updated 28 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid