• Exporting stored procedure results into an XML file in SQL Server

    I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • naming column returned from FOR XML EXPLICIT query in SQL Server 2005

    Is there a way to name the column returned from a query that includes a for xml explicit? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I'd like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into...

    Cramhead15 pointsBadges:
  • How to create table using a subquery in SQL Server

    Hi everybody, Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server. In Oracle I tried as "create table table1 as select * from table2" My requirement is to create dynamic tables in stored procedure based on existing tables. I'm so desperate, I...

    Carbuncle0 pointsBadges:
  • Why can’t I connect to SQL Server 2005 through ODBC?

    Hello people, the situation is this: we have 2 computers, one is for local store (let's call it backend) and the other is a web server (let's call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS...

    MrGeorge65 pointsBadges:
  • Cloud Computing market: Blip or trend?

    Based up on the Q1 reports, expert David Linthicum says that while some public cloud providers (such as Amazon) continue to show growth, others are starting to see their sales either stall or even decline. Do you think this is the beginning of a trend for cloud companies? Or could it just be a blip...

    Michael Tidmarsh25,225 pointsBadges:
  • Access SQLServer remotely.

    Can somebody tell me how can I access the SQL Server instance which is running on a different network? I'm developing a website which should access the instance of sql server running on user's computer. The user can be on a different network. I'm not able to find a way to achieve this.

    ITKE54,755 pointsBadges:
  • Storing images in SQL Server 2005 and retrieving them from VB.NET

    How can I store images in SQL Server 2005 and retrieve them from VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why shouldn’t I use immutable POJOs instead of JavaBeans?

    I have implemented a few Java applications now, only desktop applications so far. I prefer to use immutable objects for passing the data around in the application instead of using objects with mutators (setters and getters), also called JavaBeans.But in the Java world, it seems to be much more...

    snehalmasne15 pointsBadges:
  • Facebook oauth

    Sir, My Question is:- I am using facebook oauth on my site: just like -login with facebook-fetch the detail like name ,email,lastname etc. and fill on my aspx page. and I am using the code-- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;...

    1223fb5 pointsBadges:
  • Calling RPGLE Procedure returning 10 length char value from Java

    Hi, I need to call a RPGLE procedure which is in a NOMAIN module and returning a 10 char. Example of the procedure I need to call is as follows: PRtvChgDesc       B                   Export dRtvChgDesc       PI            10 d  P_Name         ...

    ROYB95 pointsBadges:
  • how can i retrieve the data from sql-server2005 from multiple tables in two combo-boxes in vb6.0 using programming code

    how can i retrieve the data from sql-server 2005 from multiple tables in two combo-boxes in vb6.0 using programming code

    Narendar30 pointsBadges:
  • Making a POS form for a pharmacy program

    I need to make a POS frame for a pharmacy automation program am working on. >need to add data from a field in access in which it searches while I type. >when I select the name, the data from the access corresponding the name selected should be added in my flexgrid list and should be asked to...

    josewan5 pointsBadges:
  • Retrieving and storing an image in SQL Server

    How can I retrieve and store an image in SQL Server using Visual Basic 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER 2005-MAX FUNCTION

    I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...

    Beginner in IT5 pointsBadges:
  • Access rights in SQL Server 2005 users

    Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1 and...

    DetayMan5 pointsBadges:
  • shredding xml in sql server 2005

    In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...

    Skidancer5 pointsBadges:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • How to build a career in IT if the person is from commerce field

    Hello, I'm from commerce but now I'm joining a course on software testing. Please suggest to me how I can build my knowledge in Software Testing and I'm also joined one software company as a trainee but I'm not fully knowledgeable yet. Please suggest to me on how to star my work. Thanks!

    seeds15 pointsBadges:
  • HTTP vs. http

    What is the difference between HTTP & http...or is there one? If there is no difference, why is it that one acronym is in lower case and the other in upper case? A very basic query, I realize.

    JanuaryGirl5 pointsBadges:
  • SQL Server does not exist or Access Denied Error

    I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use...

    Sanisto45 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following