March 2008 - Posts

4
Comments

MS SQL resetting the auto increment by stoian bucovich

Have you ever wondered how to reset the auto increment in SQL table? Well I did, and here is how to achive this: DBCC CHECKIDENT('test', RESEED, 0) ; where 'test' is the tables name we want to reset. There is a trick if you already have some date into...
2
Comments

Getting the number of rows for todays date in MS SQL by stoian bucovich

Great in this example I am going to show you how you can get the rows from sql table (lets say you want to get the number of records that your users had made). For this purpose I will call our sql table just "table" and will make a field called "PostDate...
1
Comments

User profile by stoian bucovich

Well this time I am going to show how to save values in user profile with asp.net membership provider. - first we have to decide what we want to save in our users profile let's say first name, last name and telephone number. To achive this task we have...
More Posts