Member Avatar
Hi All, I'm a little stuck with one table's design. I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design: `CB_ID int (PK)` `CB_Mnemonic_ID int (FK)` `CB_Value decimal (18,10)` `CB_Year int` `CB_Quarter int` This table is loaded …
by Stuugie 50 in Databases ()
Member Avatar
Hi There; I have a MS-SQL server and I have Turkish names in my table. User enters names and I send it to SQL server, print result to output. However, my PHP code process and prints text as a UTF-8, and send it to MS-SQL and print it to output.However …
by varoluscu_prens in Web Development ()
Member Avatar
Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a …
by KirstyHunter 1 in Databases ()
Member Avatar
Hi, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names. Schema A A.Customer A.Product A.Invoice Schema B B.Customer B.Product B.Incoive My first problem is actually configuring Replication on the publisher using the …
by KirstyHunter 1 in Databases ()
Member Avatar
What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | …
by BigPandaCake in Software Development ()