• Case sensitive variables in SQL Server 2008

    Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...

    ITKE342,775 pointsBadges:
  • SQL Query

    Employee: EmpID Name Company MGR_ID Date_of_Joining 1 Bhaskar A3 3 1-Jan-13 2 Ujin A1 3 1-Jan-13 3 Rex A6 NULL 1-Jan-13 Model: ID Model_Name Company Model_Type Harddisk OS RAM 1 750 Dell PC 600 GB WIN 7 4 GB 2 650 HP LAPTOP 400 GB WIN 7 6 GB 3 350 DELL LAPTOP 300 GB WIN 7 4 GB System: ASSET_ID...

    InformaticanSQL10 pointsBadges:
  • Can you create an Active Directory users group in SQL Server 2008?

    I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...

    Chris Leonard4,300 pointsBadges:
  • About database connection

    How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?

    mahajan5 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • What does this controller error mean?

    I have an HP Pavilion Laptop running Windows 7. I recently discovered an error in the Event Viewer: The driver detected a controller error on DeviceIdeIdePort1. (more details): - System - Provider [ Name] atapi - EventID 11 [ Qualifiers] 49156 Level 2 Task 0 Keywords 0x80000000000000 - TimeCreated...

    ITKE342,775 pointsBadges:
  • Class definition

    Class is a collection or blueprint of object. But below: class A { public static void main(String args[]) { System.out.println("Hello"); } } Here is no any type object so how is (class A) a class, otherwise its not a complete class?

    iamstudentofcsebtech5 pointsBadges:
  • Estimate Multi Browser testing

    How do you estimate multi-browser testing ? please give me some idea .

    Deveshbansal5 pointsBadges:
  • Is this code spinning it’s wheels

    I have a piece of code which gets a transaction approval from a server which handles bank transactions. The code is supposed to be checking a returned base16 byte array to make sure all of the characters are valid. I do no believe the code does anything except check 1 character in the array. Please...

    CarlCioffi345 pointsBadges:
  • C# override all labels, textboxes etc

    Hi I have an application with many controls on it, is there anyway to override the base System.Controls label, textbox, etc, as I wish to do some changes to the methods without inheriting from it. The reason is I do not want to replace every instance of the control Hope that makes sense. Thanks...

    Cwi30 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE342,775 pointsBadges:
  • Web site

    I am using filezilla to edit and update a website. Is it safe to transfer files to a live website. Thank you very much.

    mfranmustang15 pointsBadges:
  • Help files

    What is custom HTML code in help file software, such as helpndoc? What is meant by insert/remove anchor ribbon menu in the same?

    sejithanjan5 pointsBadges:
  • Did the Database Designer change for Visual Studio 2012?

    I've recently installed Visual Studio and SQL Server 2012 onto my machine. I've noticed the Database Designer isn't as 'friendly' as the old version. Here are some of the changes I've noticed:It creates .SQL scripts instead of automatically saving my changes.I have to update different things in...

    ITKE342,775 pointsBadges:
  • How do I add items to a listbox while the script is still being processed

    I have a script that goes out and downloads files from a url. In my form I have a listbox that I use like a message queue. After each download I send a completion notice to the listbox. The problem I am having is the messages only get sent at the end of my script. In short, I download several...

    TryingHard125 pointsBadges:
  • What comes first? Visual Studio 2012 or SQL Server Management Studio 2012?

    I am preparing a fresh install of SQL Server 2012 onto a Windows 7 x64 development VM. I plan to coordinate this with Visual Studio 2012. Does the install sequence matter? Which of the two should I install first to cut down on issues?

    ITKE342,775 pointsBadges:
  • How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE342,775 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