SQL Server: Misc Commands

May 29, 2008 11:51 by moses.yap

Resetting Identity Column: You can use the DBCC CHECKIDENT statement, if you want to reset or reseed the identity column. For example, if you need to force the current identity value in the jobs table to a value of 100, you can use the following: DBCC CHECKIDENT (jobs, RESEED, 100)

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:
Categories: SQL Server
Actions: E-mail | Permalink | Comments (0) | Comment RSS RSS comment feed

SAP B1: Creating a User Defined Table using C#

May 20, 2008 07:02 by moses.yap

User defined tables are used to store custom information in SAP B1. A user define table is a tabular container that can contain multiple user defined fields and can be grouped together to form a User Defined Object (UDO). A user defined table can be of type Master Data, Master Data Row... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

SAP B1: Connecting to the DI Server

May 17, 2008 03:51 by moses.yap

The DI (Data Integration) Server exposes services and APIs for a developer to interact with the business objects and eventually the data store of SAP Business One. This article is about connecting to the DI Server, first using Single Sign On, which uses the instance of an already running SAP B... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

CodeSmith: Simple example on generating an update SQL from a database table

May 4, 2008 14:51 by mosesyap

This example isn't so original. In fact, its taken from two sources: Building a template to generate stored procedures http://community.codesmithtools.com/blogs/tutorials/archive/2006/02/15/StoredProcedures.aspx and Video Tutorial http://community.codesmithtools.com/blogs/videotutor... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:
Categories: CodeSmith
Actions: E-mail | Permalink | Comments (1) | Comment RSS RSS comment feed

C#: Creating a Singly Linked List using Generics

May 4, 2008 14:03 by mosesyap

This is more for exercise more than anything else. By the way, in .NET 3.5, the System.Collection.Generics has a LinkedList<T> class that represents a doubly linked list. I wanted to test out some stuff in this practice. Using an indexer and using an enumerator. Here's... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

C#: Reversing the order of the letters on each words in a sentence

May 4, 2008 13:23 by mosesyap

Here is a simple exercise. We have a sentence and we want to reverse the order of the characters on each word without reversing the order of the words in the sentence. I think I read this before from the net as a Microsoft Interview question or something of that line. Ex. Input: The qu... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

C#: Converting an Array of String to an Array of int

May 1, 2008 17:32 by MosesYap

This post is about converting an array of a particular datatype to another array of a different type. The title is a bit misleading in that the procedures described below can be used to convert from an array of any datatype to an array of any datatype.Converting a delimited string to an int ar... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

SQL Server: Misc Commands

SAP B1: Creating a User Defined Table using C#

SAP B1: Connecting to the DI Server

CodeSmith: Simple example on generating an update SQL from a database table

C#: Creating a Singly Linked List using Generics

C#: Reversing the order of the letters on each words in a sentence

C#: Converting an Array of String to an Array of int

Search

Tags

Categories

Archive

Blogroll

Disclaimer