• 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.

    ITKE828,735 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?

    ITKE828,735 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?

    ITKE828,735 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!

    ITKE828,735 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!

    ITKE828,735 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....

    ITKE828,735 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!

    ITKE828,735 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.

    srithea360 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...

    ITKE828,735 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.

    ITKE828,735 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...

    ITKE828,735 pointsBadges:
  • Create SQL script for insert statements / table having blob data

    How can I create a SQL script for insert statement / table having blob data?

    sushantmane15 pointsBadges:
  • SQL Server: List of column names in a table

    For SQL Server, can I have a list of the names of the columns in my table? Do I have to use a third party product for this? Thank you for all your help.

    ITKE828,735 pointsBadges:
  • Should I use TRUNCATE before DROP in SQL Server?

    Currently in my SQL Server system, I'm working on a ton of stored procedures / SQL scripts that are making use of temp tables. When I'm done with the tables, I usually drop them. This is what I've been using: TRUNCATE TABLE #mytemp DROP TABLE #mytemp So, I usually use DROP TABLE for my scripts but...

    ITKE828,735 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