Search results for query: *

Hi, I am new to T-SQL and I am trying to use "declare" in a stored procedure. I am getting a syntax error not sure why, any help appreciated. Here's the code :- ALTER PROCEDURE [dbo].[TOTALCOUNT] @StartDate DateTime, @EndDate DateTime AS BEGIN SET NOCOUNT ON; DEclare @TOTALPEOPLE int...

Hi, I am trying to do the following query and I get a Syntax error Query: SELECT COUNT[D1.*) AS [Col1] FROM Database1 AS D1 INNER JOIN Database2 AS D2 ON D1.CoL1 = D2.CoL1 Error: incorrect syntax near '*' What am I missing. Thank you.

Can I use "IF" in a Select stmt e.g. SELECT Db1.Value1, IF (Db1.Value2 != 'good','bad','ok') FROM Database1 as Db1 I am getting a syntax error on IF any help appreciated.

Hi, I need to move a SQL server 2005 database nearly 9 GB to another machine on a different domain. What is the best way to do this ? I tried taking a backup then do a restore on the new machine and it failed with an "Access denied error". thanks for your help.

I am new to t-SQL and was looking for some help. Is there a way to display a "space" or Null value in a column when no data is returned for a query. E.g. If I run the query below SELECT EMPNAME, EMPMIDDLE Where EMPName='bob' When I run this query and if there is no Empname as 'bob' then at...

Can anybody tell me what is the best way to change the attribute value on a particualar node in a axml file ? Thank you. <Vehicle> <Cars> <Hybirds id='Toyota' cost='2500'>Available</Hybrids> <Hybrids id='Honda' cost='3500'>Available</Hybrids> </Cars> I want to change the value for cost where...

Hi, I am new to TSQL and have a problem with temp tables CREATE TABLE #TCOUNT( PASSED INT, FAILED INT ) INSERT INTO #TCOUNT(PASSED,FAILED) VALUES (SELECT count(ID) FROM ExamResults er WHERE (er.[lastresult] = @mark1) AND ( er.[curresult] = @mark3 or er.curresult= @mark4 or er.[curresult]...

Has anybody used C# to register for Windows device events? I am trying to capture "CMP_WaitNoPendingInstallEvents" is there a way to do this in in C#. Any help appreciated.

How can I convert a C# dll to a COM object, so I can use it in VBScript or JavaScript. Thank you.

Hi, I have a C# dll, that needs to call a form. I have included the form as a separate class in the dll. But when I use formName.Visible in the dll, it frozes, the form details are not shown. Any idea why? Thank you.

Does anybody know how to Sign a VB 6.0 exe? Thank you.

Hi, Does anybody have code to create the following xml file. <CODE> <Main> <Class> <RooM id=1> <windows></windows> <Doors>/Doors> </RooM> <Room id=2> <windows></windows> <Doors>/Doors> </Room> </Class> <Teacher> <Name id=1> <Last></Last> <First></First> </Name> <Name id=2> <Last></Last>...

Hi, I am building a dll (DLLA), that adds functionality to an existing Managed Dll (DLLB). In other words DLLA references DLLB. If I add DLLA to an application, is there a way to reference functions in DLLB, without adding DLLB as a reference to the Application? Only DLLA will be added as a...

Is there are free utility to compoileunix scripts on Windows. I am new to unix please help

When you run the command "del C:\SomeFolder" it asks for "do u really want to delete?". Now that second prompt can be excluded if I used the "/q" switch. But there are some commands that do not have the "/q" switch, is there any way I can pass the "Y" to the prompt? any help appreciated.

I have created a Dictionary Object using Dictionary<string,string> DictList = new Dictionary<string,string>(); The object is populated. How do I dynamically loop through it and read the keys and values ? Please let me know. Thank you.

I am using a unmanaged dll in my project. I converted the dll to a Managed dll using tlbimp <code> filename.dll /out:NetFileName.dll /transform:dispret <\code> The project compiles fine on my machine. But when I move the exe to the server, it crashes giving the...

Does anybody know of a WMI class on the Central site server,that will give me the primary site server for a particular client? Thank you.

Is there a way to return a blank value for uint datatype? Also can I convert uint to String or vice versa? Thank you

I want to get the year, date and time from a string in the format "2006-11-12 13:00:00.0000". This string comes from a SQL server table. How do I do this? I refered to thread 732-1210422 which talks about using the SQLparameter class? Are there any examples of this? Thank you.