Hi, I have a C# Windows service that listens to a HTTP port and fires an action upon receiving a HTTP GET request. The action is typically the execution of an application that resides in the same machine (running Windows XP Professional or above). I now have the requirement for the C# Windows service to listen to incoming SQL queries ...
When I start Microsoft SQL Server Management Studio, I get an a .NET Framework error. It was installed as part of SQL Server Express. If I click "Continue", I get the usual "Connect to Server" dialog, but I am unable to connect to the local SQL Server. I am able to connect from Visual Studio, so I know its running. I can't figure out...
Hi , I am going to program windows application with c# and SQL server 2000 The Program use one central Database and all other versions of the program running on other computers in local network use this central Database on the server computer But i have no idea about how to implement client/server application After a lot of searches ...
Hoe to combine rows in sql server 2000 ...
Oracle JDBC driver provides option to do proxy authentication for multi-tier architecture design. Are there any similar/equivalent option available with SQL Server JDBC driver? ...
I found some manual here : http://support.microsoft.com/kb/316898/ru but can't make a step with : The Certificate Request Wizard dialog box opens. Click Next. Select Certificate type is "computer". On "Registration politics" step there is Active Directory registration politic by default and so it requests some registration serv...
I have a table where the data are like Data a b c I need to write a SQL query to bring the following output Data abc How to do the same by using in SQL Server 2000 Thanks ...
I use SSMSE normally yesterday but today when I started the SSMSE together with Adobe Dreamweaver CS3, the SSMSE window show and then exit immediately. I'd tried several times and also open the Event Viewer to see if any error occured but find nothing. I also went to the Add/Remove Programs and tried to "repair" the program but nothin...
i am using a list view for viewing some information to user there i used a hyperlink in each row to show detailed information in a modal popup in the same page what i want on the click of particular hyperlink the detailed report of that row only should display. [ID] is the primary key in my database iam passing that as an object from asp...
Hi there, I have a stored procedure that is throwing an 'Invalid column name' error for 'ContentMarginExVat'; SELECT CategoryTitle, ContentID, ContentTitle, ContentMarginExVat, ContentWeight FROM VWProductsCurrent WHERE ContentID = @ContentID I have checked both the VWProductsCurrents and the associated table that gets the data...
We've recently developed an internal web application for our intranet on top Microsoft's MVC Framework (v2). This seems to work wonderfully, but after some as yet unknown events, we're seeing a situation where database queries appear to yield no results, whilst no exceptions are caught, which has stumped me somewhat. Republishing the ap...
If you have this xml <AssetComponent name="AssetComponent4881" width="300"> <Asset id="5" type="1" /> </AssetComponent> <AssetComponent name="AssetComponent4882" width="300"> <Asset id="5" type="1" /> </AssetComponent> Is it possible to replace all the ids from 5 to 6 in one query? With this sql only one attribute at the time can...
Not being a SQL expert, and also only being semi-competent in CTE, how can I code this statement use the resultset from the following subquery within the main query, as our SQL Server is 2000. declare @subcategoryConcatenate varchar(3999) set @subcategoryConcatenate = '' select @subcategoryConcatenate = @subcategoryConcatenate + pumpCa...
hi, I have a simple stored procedure like so: ALTER PROCEDURE [dbo].[spList_Report] @id INT AS SET NOCOUNT ON SELECT * FROM tblProducts as products WHERE product.intID = @id I have 2 user tables: MainUser and SubUser Both tables have a foreign key column productID which is related to the primary key int...
Is there a way to prevent that a Cursor changes at runtime. If I have a cursor that iterates over all the users and meanwhile, in the processing of each user, I create some additional users, then the Cursor will also iterate over the newly created users... ...
Hi, I have this query but for some reason the StartDate values are not getting filtered. What's wrong with it? Please let me know. SELECT * FROM TableA A WHERE NOT EXISTS( SELECT * FROM TableB B WHERE A.pId = B.pId and A.StartDate >= '20-JUN-10' ) ...
Hi, We have a decent sized, write-heavy database that is about 426 GB (including indexes) and about 300 million rows . We currently collect location data from devices that report to our server every couple of minutes, and we serve about 10,000 devices - so lots of writes every second. The location table that stores the location of each ...
I have a stored proc on SQL Server 2000 that takes 3 parameters. When I call the stored proc from DotNet using SqlCommand.ExecuteReader () it takes about 28 seconds. When I run the same query inside SSMS directly it returns immediately. When I take the query out of the stored proc and run it directly using DotNet it also returns immed...
Hi friends, I am using C#, Asp.net and my Ms Sql server table name is getdetail which contains id(int), name(nvarchar(20)) fields and the table data are 101, bob. Now i want to fetch the name value and assign it to the string datatype variable and show that value in the page. Can anybody give me the code please...? ...
Hello, I am trying to achive this: Initial table: PARM1 |PARM2 |DATE ------------------- VALUE1|VALUE2|DATE1 VALUE3|VALUE4|DATE2 Final result: PARM |DATE1 |DATE2 |... ----------------------- PARM1|VALUE1|VALUE3|... PARM2|VALUE2|VALUE4|... Briefly, I want to convert my parameter names into lines and to have a column for every da...