• How to convert XML data into tabular form in SQL Server 2005

    Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!

    Shama5 pointsBadges:
  • Do I need SQL?

    DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

    0 pointsBadges:
  • T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.

    We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What's the "condition" selected and how's the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any...

    CHENS265 pointsBadges:
  • Microsoft SQL Server BCP Utility password

    I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments. I am looking for a method...

    Redwine20 pointsBadges:
  • SBS monitoring

    Hello We have a customer running SBS 2003 sp2. We can't access the monitoring and reporting through server manager. When Monitoring and Reporting is clicked it just displays a - The Webpage cannot be found HTTP 400 page and when Setup Monitoring and Reports is clicked an error box comes up reading:...

    Swandigital5 pointsBadges:
  • SSRS Report Export to Excel

    When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.

    Radhikavarshit5 pointsBadges:
  • Blocking the use of web proxies.

    Currently we are using a filter by 8e6 technologies called the R3000. The device works great accept for the fact that users can go to a web proxy and get to blocked web sites bypassing our filter. Is there a way to block the proxy traffic as well? Or do I have to manually block the access to the...

    Skepticals0 pointsBadges:
  • null v/s ” “(empty string) in Java

    what is the difference between null string and emty string(" " ) in java? String name; if(name == null || name == "") { } wat is the meaning of the abouve if statement?

    Prcvjr220 pointsBadges:
  • SQL Server 2005 License

    This question is not about doing something illegal toward the SQL Server Licensing; on the other hand it is about knowing relationship between Licensing and hardware. Question: I have SQL Server 2005 licensed for 2 physical CPUs. Recently, I bought a system with 4 CPUs to replace the old machine. I...

    Vahemelikian10 pointsBadges:
  • Application not responding in Windows XP Professional

    How do I determine what is causing a "Not Responding" status in Windows Task Manager when running my application? It changes back and forth from "Running" to "Not Responding". It is very slow but eventually finishes. Using Windows XP Professional and SQL Server 2000.

    Smythprog30 pointsBadges:
  • Copy BLOB to BLOB using TSQL

    Is there a way I can copy a BLOB from one column to another using TSQL ?

    Prototyper5 pointsBadges:
  • How to write text into word doc using SQL 2000 query analyzer

    how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

    Pkaur65 pointsBadges:
  • Is it safe to delete SQL Server Transaction Log?

    In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but I want to make sure that...

    Vahemelikian10 pointsBadges:
  • Can I direct query the Oracle database with SQL Plus?

    I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

    Mikecold10 pointsBadges:
  • How to secure MySql server?

    How to secure a MySql server for webhosting?

    Ashishagw5 pointsBadges:
  • Help running a CmdEXEC from the SQL Server

    I am trying to run a CmdEXEC from the SQL Server- script c:userspublicdocuments The process could not be created for step 1 of job 0xAA781DCB64C4D84392B6730923A77C3D (reason: The system cannot find the file specified). The step failed any help?

    Tocken10 pointsBadges:
  • How to update data for one column in MS SQL?

    Hi, I have a table column named "Question" that stores the question without space.For example "Who are you" is stored as "whoareyou".Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already...

    Santhoshnk735 pointsBadges:
  • How to write text into textfile using SQL 2000

    can I use exec sp_OAMethod 'c:osqloutput.txt', 'WriteLine', Null, 'hello' to write something on file using sql2000

    Pkaur65 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