What is the common way to show archives in weblog?
i want to create my own blogin c# and i m starting to design sql tables and
i want to show months in that way,
Juli 2006(2) here 2 is the total post of blog articles in July.
and so on...
Here my blog table...
create table tblWeblog (
LId int IDENTITY(1,1) primary key,
LUserId int not null,
LCategoryId int null,
LCaption nvarchar(50) null,
LBody ntext null,
LTime datetime not null default(getdate()),
LMonth as datename(m,Logtime),
LYear as datename(yy,Logtime),
LIsActive bit null
--Question 1)In Lmonth it comes with month name in english,how can i change to german in sqlserver 2000, or do i have to do in c# function?
--Question 2)do i need LMonth and LYear columns ? What is the common way? is Ltime column enough for that? for example, c# datetime functions may accomplish this task.
Any help greatly appreaciated.