• Select reserved words in Oracle

    How can I select reserved words in Oracle. For example: In T-SQL, I'm able to select a column that's called table by using Select [table] from tablename. But I can't figure out how to do it with Oracle. Thank you very much.

    ITKE409,390 pointsBadges:
  • T-SQL: Split numbers into a table

    For T-SQL, I have to split 1,2,3,4,5,6,7,8,9,10 9 into a table (also comma delimited). How can I do that? Is there some sort of function that I can return each one in a row? Thank you so much.

    ITKE409,390 pointsBadges:
  • A01 Extension File

    Hi, It is some kind of DB file which has extension .a01. But I can't read the file because it's not clear. When I open it in notepad, it displays ASCII (Encrypted Format) only.

    Rupees15 pointsBadges:
  • How to read PDF file in Windows Form applications, files saved in SQL Server database

    How can I read a PDF file in Windows Form applications, files saved in SQL Server database?

    DotnetLearner5 pointsBadges:
  • SQL Server: Getting the identity from an inserted row

    For SQL Server, how can I get the identity of an inserted row? Do I have to use @@IDENTITY or IDENT_CURRENT? Thanks so much for your help.

    ITKE409,390 pointsBadges:
  • SQL Server: Should I use SELECT*?

    Particularly in SQL Server, I'm wondering if I should use SELECT*. My friend told me that it's necessarily good practice and it has caused several performance problems for his database. Should I use it? If so, how should I go about it?

    ITKE409,390 pointsBadges:
  • How do I update existing record in CildTable with NEWID while creating new record in ParentTable with same GUID

    First, let's insert a record into ChildTable: INSERT INTO ChildTable (DataCol3, DataCol4) VALUES ('Rec2-1','Rec2-2') As indicated in your article, ChildKey PK populates automatically. When I try to create a new record in ParentTable that is linked to the record previously created in ChildTable I'm...

    Exsellerate5 pointsBadges:
  • Clustered or non-clustered primary key in SQL Server?

    For SQL Server, I'm creating a test database and I'm debating if I should use NONCLUSTERED or CLUSTERED primary key. What's the difference between the two? Is there a preference of one over the other?

    ITKE409,390 pointsBadges:
  • How to compare fingerprint images in VB.NET

    I'm working on FINGERPRINT RECOGNITION SYSTEM. I'm using VB.NET as front end and SQL Server 2000 as back end. I had saved fingerprint images in sql server using image datatype, now I need suggestion on how to compare fingerprint images.

    Dlfshweta5 pointsBadges:
  • Setup query execution plan for stored procedure in SQL Server

    I'm currently using SQL Server and I need to setup a query execution plan for my stored procedure. How can I go about this? Can I use SSMS? Thanks!

    ITKE409,390 pointsBadges:
  • How to send stored procedure parameter to Trigger?

    I am sending a parameter from ASP.NET web API to a stored procedure. Now how do I send that SP parameter to Trigger?

    AnshuRishiPratapReddy5 pointsBadges:
  • SQL Server: How do I add an identity to my existing column

    On SQL Server, I'm trying to change the primary key of my table to an identity column. But there's already a number of rows in the table. I created the script so the IDs all start at 1. Is there a command that can alter the column to have a identity property? Thanks!

    ITKE409,390 pointsBadges:
  • Reinstall SQL Server on Samsung Medison EKO7 machine

    How do I reinstall SQL Server on Samsung Medison EKO7 machine?

    AdewaleAdebayo5 pointsBadges:
  • SQL Express 2008: Gain administration rights

    Recently, I got a Windows 7 PC from a friend that has an existing instance of SQL Express 2008. I already have local administration rights but I don't know the SA password. So I can't create databases or modify the password. How can I get SYSAdmin privileges? I tried using SSMS but it didn't work....

    ITKE409,390 pointsBadges:
  • Connecting to SQL Server 2005 database through JavaScript

    I'm using a SQL Server 2005 (don't worry, we're upgrade to 2008 really soon) but can I connect to the database from JavaScript locally? Is there a specific scripting language I have to use? Thanks!

    ITKE409,390 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • User account last login date in SQL Server 2005

    Dear experts, how can I check last login date of user account in SQL Server 2005? Thank you.

    srithea330 pointsBadges:
  • Upgrade from SQL Server 2005 to 2008

    We're in the process of upgrading our servers from SQL Server 2005 to 2008. It's also running on Windows Server 2003 but we're planning a migration on that too. This will include: Log shipping, packages and reporting server. But here's my question: Should we be worried about the risks of this...

    ITKE409,390 pointsBadges:
  • SQL Server 2012: CASE statement evaluates all conditions

    Does anyone know if SQL Server 2012 CASE statement evaluates all WHEN conditions or just exits when it finds the first TRUE condition? So basically, if it goes through all of them, then does the last condition overwrite the first condition? Thank you.

    ITKE409,390 pointsBadges:
  • SQL Server: Create table to hold result of stored procedure

    With SQL Server, I usually write a query like this: create table #table_name ( column1 int, column2 varchar(200) ... ) insert into #table_name execute some_stored_procedure; But here's my issue: When creating a table to have the right syntax as the result of the stored procedure is too long of a...

    ITKE409,390 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.

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

Following