|
Hi
I need to create an inventory database using sql server 2008 and want to know on how i will proceed, what are the steps,etc ? can someone please provide me with some advice?
Thanks
|
|
|
|
|
0) Download SQL Server 2008 R2 Express[^]
1) Install it
2) Read up on relational database management systems
3) Read up on database normalisation
4) Perform an inventory of what you have and decide how you want to represent it in your database
5) Ask more specific questions in online fora
Really, it depends on what you have and how you picture it in your head.
The more tables the better!
|
|
|
|
|
PIEBALDconsult wrote: The more tables the better
Ehm, only if you really need them...
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
I once inherited a database in whcih the original programmer had created seperate tables for each and every field - eg instead of:
Table "clients":
ID
Name
Address
PostCode
etc
They had:
Table "clients"
ID
Name
Table "addresses"
ClientID
Address
Table "PostCodes"
ClientID
PostCode
etc et-bloody-cetera.... dozens of tables.
You can just imagine the SQL statements....
|
|
|
|
|
If you have a table with very many columns and you often select just a subset of them, then I can understand if you split the table for performance reasons. But what you inherited is just ridiculous.
And it doesn't have anything to do with normalization.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Look here:
Data Models[^]
for database design options.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
thanks that help a lot, cheers
|
|
|
|
|
Hi,
I'm developing a multilanguage web site.(My DB is SQL Server 2008 R2)
Some of its languages are: Chinease, Japanesae, Arabic, Persian, English ....
I know about some collation and datatypes in SqlServer, but I'm ambigious about Collation of DB and about char types.
1. What collation I shoud use for my DB?
2. for char types I shoud use varchar or nvarchar?
Thanks for your attention.
Best wishes
|
|
|
|
|
Mixing cultures in a database are a recipe for severe headache's.
mehrdadc48 wrote: What collation I shoud use for my DB?
The appropriate one for the required sort-method (binary or dictionary? case sensitive, or not?) for the language, they're listed here[^].
mehrdadc48 wrote: for char types I shoud use varchar or nvarchar?
NVARCHAR , NTEXT and/or NCHAR .
Important note;
Windows Unicode-only collations can only be used with the COLLATE clause to apply collations
to the nchar, nvarchar, and ntext data types on column-level and expression-level data; they
cannot be used with the COLLATE clause to change the collation of a database or server instance. Says so here[^]. That page also mentions that there's three different levels where you can manage your collations. I'd like to suggest that you append the collation that's required by the current UI to the query.
Are you also going to store dates from regions where they speak those languages? If that's the case, you'd also need to check whether the datatimes in the database are all stored in the same timezone (using server-time!) or the local users' time. The latter should be entered in the database re-adjusted to the timezone of your server, or, alternatively, stored the timezoneinformation in an accompanying field.
That should be enough to get you up and running. Enjoy
I are Troll
|
|
|
|
|
I am in the process of writing multiple reports for a system developed using Visual Studio 2008 (VB.Net)and running SSRS 2008. Is it possible when you click a "Print" button that rather than the report showing up in the report viewer window first, that the report be sent directly to the printer without viewing it in a window first. Unfortunately, since I am fairly new to Reporting Services, I cannot figure out the process to do this.
So basically, is there a way I can print a report without viewing it first?
Other....
I know the users are going to ask as well as sending the report directly to printer, to save it in a PDF format. Can this be done?
|
|
|
|
|
I am looking for the steps on how to save and how to read images from/to mysql using C#?
Thanks.
|
|
|
|
|
jrahma wrote: I am looking for the steps on how to save and how to read images from/to mysql using C#?
Would a CodeProject article[^] on the subject help?
I are Troll
|
|
|
|
|
hello - how can you configure auto shrink for SQL server Trasnaction log?
Thanks
dev
|
|
|
|
|
EXEC SP_DBOPTION 'MYDBNAME', 'trunc. log. on chkpt', true
modified on Wednesday, November 17, 2010 3:29 AM
|
|
|
|
|
|
hi all
I was wondering if anyone could help, I need to pass 2 variables to a stored procedure that in turn fires off an SSIS job that calls a stored procedure.... (dont ask!). I can get the variables into the stored procedure no problem, but getting them through to the job is proving harder than I would expect. I can set static params through the Set Values option but cannot see a way of making them dynamic ?> any thought greatly appreciated
ta
|
|
|
|
|
Can you post some code from the stored procedure where you "fire off" the SSIS job?
Greetings
Manfred
|
|
|
|
|
ta,
I am sure that there is a way to pass those values though another option that I have used before is to update a parm table with the values from the stored procedure and then kick off the SSIS package which reads the parm table.
I hope that this helps
Robert Ford
|
|
|
|
|
hi... to all..
i've written the code in expression field...
=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")
the code is for printing the number in this format(12,23,23,34,123.00)
now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas
are printed.. i dont want to print the extra commas.. how the word length is there that much it
should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...
i've tried by removing some of the #'s but it is for fixed number..
please help me...
|
|
|
|
|
It is customary to group 3 digits at a time. To achieve that you simply need to use "#,##0.00" as your number format - the result will contain as many ',' characters as necessary e.g.
Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89
|
|
|
|
|
thanku.. for reply
i have just change the language setting..
|
|
|
|
|
please help to update image using c# i'm new to .net
i have successfully inserted image in database but i couldn't update it,using c# if any one finds the answer please let me know it
advance thanks
|
|
|
|
|
chandru222 wrote: i have successfully inserted image in database but i couldn't update it
Why not? Did you get an error? What did it say?
I are Troll
|
|
|
|
|
|
vijay2482 wrote: I would like to know how to retrive data from Access table to a excel spread sheet with a click of a button in the excel spreadsheet.
Using VBA. I don't have the exact code - you'll have to search a bit
I are Troll
|
|
|
|