View Complete Post
i want to select only 15 words from table , plz reply me how can i do this???
I have a problem with geography data type replication. Any change that is done on a Geography column breaks the replication - the error message is "The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the
article at the Subscriber." I double checked compatibility settings that is suggested here:
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d8e31621-5d43-48cd-bdd3-c02b8a24625c. But both publisher and subscriber are 100RTM.
I checked synchronization logs and found a strange message - attempt to convert varchar to geography. I don't understand from where the varchar data type comes from. Tables at subscriber and publisher has the same format - geometry stored in geography data
2010-09-20 18:36:22.499 The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart
the Merge Agent to apply the DDL changes and synchronize the subscription.
2010-09-20 18:36:22.845 Category:NULL
Source: Merge Replication Provider
In my VB.Net code I am using boolean type and it is later stored through a stored procedure to a MS SQL database table. I have so far allways been using "int" as the column type in database table because there is no Boolean type to choose from when designing the columns of a table in the MS SQL Express?
Is it correct to use the column type int for storing Boolean values?
I need to pass many records with number of fields(i.e 5rows and 5 columns) in either array or table form to oracle for processing. Is it possible to pass array/table from asp.net pages? If no, any solutions for this? I have been thinking of passing it as string concatenated with delimiter and split it. Seems like it is not appropriate as i have to pass 5 strings(5rows) Any better suggestion? Thanks in advance
Getting started with EF and working on getting a basic inheritance set up, but it's not being agreeable. Am I missing something here?
-ContentItem-ContentItemId (PK)TitleDescription...etccontains 2 records, let's say their ContentItemId's are 101 and 102
contains 1 record, with ContentItemId of 101
In the VS2008 EF modeler I've done the following:
-Deleted the original relationship-Made Event inherit from ContentItem-Deleted the ContentItemId from Event and mapped it to the inherited value
then in the code:
public IQueryable<Event> GetCalendar()
var all = from e in context.ContentItem select e;
var query = from e in context.ContentItem.OfType<Event>()
When I break at the return statement I have 2 records in "all" and 0 records in "query"... I would expect their to be 1 record (id 101) in "query", am I missing something here?
Can you please take a look at the question at the following link and try to help me?
I have a custom table with a variable character field storing a date. It is currently in the format YYYY/DD/MM plus a time stamp. I want it in the format MM/DD/YYYY without a time stamp.
I've tried a few CONVERT and UPDATE statements, with no change. The syntax is okay, and in some cases the statement has an effect (such as cutting off all but one character of the time stamp), but does not reformat the date. I've also tried resetting the
fields as DATE fields or SMALLDATETIME fields in the custom table, and I receive errors after doing that.
I'm not sure if this is the place for this question, but here goes.
I am running SQL Server 2005, and I've encountered an issue with view data types. I had a client who asked if they could allow for decimals in a field that was previously an integer. This meant going and changing the column data type on a few
tables from integer to float, and changing some parameters and variables within some stored procs/functions to floats. Somewhere the value is still being rounded down, so I queried the information_schema.columns and found about 60 views in the system
that reference that column and are still being considered an int, from the tables which were already converted to float. I've found that if I simply script the views as alter and run it the column no longer is considered an int in the information schema.
My question is this: Does this seem to be my problem, that when the view is referenced the value is changed to an int? Or does the view simply reflect the table's data type and the information schema is incorrect? If the former, is there a faster way
to update all these views without going one by one and scripting them? Thanks in advance.