I am having a problem with some select-join syntax, can someone guide me a bit? DDL: create table Master( keycol char(2) ) creata table SubA ( keycol char(2) , parta char(10) , wasupdated datetime ) creata table SubB ( keycol char(2) , partb varchar(32) , wasupdated datetime ) insert...more >>

I developed an internet application using ASP.NET 2.0 and MSS Express on my PC. It works very well. I copied it in my company where I installed MSS Standard Edition and it doesn't work the db connection. I think the problem is on DB App_Data\aspnetdb.mdf that ASP.NET creates to keep the user...more >>

I have two tables as follows: ====================================== CREATE TABLE [dbo].[Member] ( [memberID] smallint IDENTITY(1, 1) NOT NULL, [familyID] smallint NULL, [memType] smallint NULL, [title] varchar(50) COLLATE Latin1_General_CI_AS NULL, [firstName] varchar(50) COLLATE...more >>

I'm having a problem with the logic in a SQL query that I need to run. I'm selecting 4 columns from an old database and inserting 2 into tableA and 2 into tableB of a new database. TableA and tableB both have identities on with the self-incrementing values, albeit they are starting at differe...more >>

Hi There, i am facing problems while executing the query using ADO.NET,the problem goes below: i am using ExecuteDataset(sqlTran, CommandType.Text, query) and my query is this SELECT * FROM TBL WHERE CreatedDateTime = '1/23/2011 4:38:57.000 PM' and the result set has nothing in it .but ...more >>

I want to change the text within the rich text box control so it removes formatting I don't like. E.g. I want the text to always be Arial size 10, it should always be black text etc. This is the code I am using to strip off the formatting With txtTest RTFSelLength = .SelStart...more >>

Hello, We are packaging SQL Express 2005 with our application, and we are using the RANU feature. The problem, is that I would like to manage the Uninstallation of our application at the SQL level, that is, detaching the database from SQL. I've read that I sould use sp_detach_db to do this, b...more >>

Hello, I would like some help regarding an issue I'm having in SQL Server 2000. I have some tables that represent an inventory of raw materials for remanufacturing and I cannot seem to group my tables properly. Every raw material has a reference (because several suppliers may sell the sa...more >>

Hi there, I am running SQL Express 2005 on my localhost...I also have an Acess database which i've set up as a Linked Server. When I open SQL Server Mangement Studio Express I can query the tables in the linked server with no errors/problems. But, when I run my .NET web application and ...more >>

Hi to all, I have a simple question? Create table test (a int) insert test values (1) insert test values (1) insert test values (1) insert test values (2) insert test values (2) select * from test (nolock) out put: a -- 1 1 1 2 2 Question: I need all the duplicate records fro...more >>

Im trying to write a Stored Procedure tjat will accept a 'string' from a vb.net application. I can execute the stored procedure and ger the results back, but the problem is that i have a variable string in vb that can exceed 20,000 bytes and need to be able to parm this into the stored proc. ...more >>

HI i have two server one is active server called server1 and the other is mirror server called server2 today i am facing a problem. the problem is my all database which is configured for mirroring showing the green up arrow plus this message (Mirror, Synchronized / Restoring...) and i cannot ...more >>

Hi group, I've got a problem with a Update-Statement. My table looks like that: imp_id loc_id ext_id source_id src_system ext_id2 12 4455 1-12-C 25 3 1232 13 4455 1-12-C 34 3 NULL 14 4455 1-12-C 47 3 ...more >>

Is it possible to create one view with schemabinding which has the select query on several tables? Or do I have to have one view with schemabinding per table? Thanks i.e. alter view vwTables with schemabinding as SELECT ActionID, [Action] FROM dbo.tblActions SELECT AuditID,TableID,Actio...more >>

Can some one tel me how a can save a string from a vb.net application into a sql database as this string contains a ' de field is a varchar. ...more >>

Hi There, I need to do something quite simple like export a list of Stored Proceedure, User Defined Functions, tables, etc How can I do this in enterprise manager. Cheers ...more >>

Hallo allemaal, ik zit met een probleem in sql nl. In een vb.net applicatie wordt een string gevuld met tekst die vervolgens weggeschreven wordt naar sql, dat gaat allemaal goed echter op het moment dat de tekst een ' bevat krijg ik een fout melding. ik heb vervolgens de query handmatig op de...more >>