.NET, Java, PHP, C/C++, SAP, MainFrames, Testing, SQL Server, MySQL, Oracle Developer Links

SQL Server -- compare and update schema of live database from test database

I have two databses on a SQL Server -- one for development (call it "TestData"), and one for production (call it "LiveData"). I make changes to TestData -- typically adding tables or adding new fiel

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :54 Vote Up: 0 Vote Down: 0

Convert DateTime using SQL

Hi,

I have a DateTime value in a Table as follows:

2011-01-22 14:30:09.043

I need the output of as follows 22-Jan-2011 2:30 AM/PM

How can we convert b

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :176 Vote Up: 0 Vote Down: 0

SQL server 2005 connection problem

I have installed microsoft sql server 2005 with microsoft visual studio 2010, and I also installed Microsoft sql server management studio.

When I open management studio and right-click on database engine,new: se

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :61 Vote Up: 0 Vote Down: 0

Connecting to SQL Server (Local Machine)

Hi all,

Apologies if this is a dumb question, but I'm tearing my hair out over the basics when I should be spending time learning ASP.NET 2.0 and C#. I've searched the archives and a lot of people seem to be g

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :66 Vote Up: 0 Vote Down: 0

Does SqlCE 4.0 have it's own provider? How do I know I've created a SqlCE 4.0 Database?

Hi folks,

If I wish to create a SqlCE 4.0 (sdf) database in my Visual Studio 2010 project, how can I confirm that the sdf is a CE4.0 file? Do I need a particular provider to connect to it? I've downloaded CE4.0

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :110 Vote Up: 0 Vote Down: 0

SQL CE, OleDb, nText, unsupportedconversion

I am trying to do a simple select statement against a sql ce database.

One of the columns is of type ntext and I can't switch it to nvarchar because the data might be too big.

I am using oledb because sq

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :175 Vote Up: 0 Vote Down: 0

Error running unit tests under MbUnit (Gallio)

I'm trying to do a basic Entity Framework CTP5 code first model that publishes to a database. The following exception is showing up in both MS Test and MB Unit Test Frameworks:

System.Refl

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :210 Vote Up: 0 Vote Down: 0

Merge Replication - SQL CE - Urgent

Hi,

I am running SQL Server 2008 and SQL Server CE - using merge replication between the two dbs.

I need to merge different fields from different tables into a single table on the subcriber at SQL Server

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :172 Vote Up: 0 Vote Down: 0

SQL Compact - ISSUE: Not saving data

I have developed a simple app in vs2010 (vb) that save some data to a table.

I know I have the correct file because in the server explorer (design time) I have manually added a few rows of data to the

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :65 Vote Up: 0 Vote Down: 0

SQLCE 3.5 SP2 on Network Share

We have a desktop application that uses sql ce 3.5 SP1 - in the past we have always found that we cannot have the data file located on a network drive.

We recently upgraded our development environment to sql ce

Posted : Jan/22/2011 By: nikhil Category: .NET Total Views :113 Vote Up: 0 Vote Down: 0