• Select statement in asp.net

    How can i use ms sql select statement with where clause in asp.net

    Pioneerinaspnet15 pointsBadges:
  • Connecting to a SQL Server 2005 database through LAN

    I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

    Providence15 pointsBadges:
  • SQL SERVER Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • How I can automated process load xml file to SQL server 2008?

    Hello!

    Ana6335 pointsBadges:
  • SQL Server and AntiVirus

    We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?

    Rick Martinez585 pointsBadges:
  • Pagination in SSRS 2005 Reports

    I have several reports in SSRS 2005 that consist of a "report header" area with various textboxes (note this is in the body of the report, not a page header) and then a table -- sometimes a very long table (and then a "report footer" area with some more textboxes, and also a bona fide page footer...

    Groberts3145 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

    We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

    MelanieYarbrough6,345 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • Open PDF with parameters

    I want to open a PDF file with a #page= parameter. This works if I create a fetch link with the full folder string - http://ecm.domain.net/ecm/livelink.exe/fetch/2000/115075//GUIDE.pdf?nodeid=9948579#page=4 ...but does not work if I "Open" the shortlink -...

    Luvdove10 pointsBadges:
  • Looping in SQL

    dear, i have one table with more than (16000) rows. now i should add on column with "computed column" as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain...

    Firasrehawi5 pointsBadges:
  • SQL concatenate results

    Hi Need help here:-  I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS,...

    devan390 pointsBadges:
  • International SQL Server Replication

    I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for...

    MattPoirier15 pointsBadges:
  • Passing an array parameter from crystal reports to a sql stored procedure

    Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I'm getting duplicates. I'm not sure how to set this up in...

    Jeager6640 pointsBadges:
  • SQL reporting

    I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report's status column,the corresponding report should be opened. i am using the following code in the navigation tab-->jump to report....

    SFD15 pointsBadges:
  • Restore SQL Server after OS loss

    I have all datafiles and backups but no OS services. What steps would I take to restore the database

    Grabber60 pointsBadges:
  • Update a subquery with different tables

    I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT ='01' where MVXJDTA.MITMAS.MMITNO =...

    Bartbart50 pointsBadges:
  • Open IT Forum: Security Worst-Cases

    Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the...

    MelanieYarbrough6,345 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