Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 1,170 total)

  • RE: Need Help: To read a column value of a SP's result set.

    Hi

    You have more ways. It's one right now on my mind. You could put your code, which selects the 20 rows, in a CTE and with an index for each...

    Igor Micev

    June 4, 2012 at 11:01 am

    #1496636

  • RE: Transactions 3

    Hi,

    If you go five questions back, you'll see a question named "Transactions 2". As I can see nothing different in this one, and the result is the same.

    What is the...

    Igor Micev

    May 30, 2012 at 11:45 am

    #1494815

  • RE: The SSIS service in 2012

    Nice question

    Thanks

    IgorMi

    Igor Micev

    May 27, 2012 at 8:02 am

    #1493590

  • RE: Logical Operators

    paul.knibbs (5/24/2012)

    This is something I pretty much never bother to remember, because if there's any ambiguity I always add parentheses...makes it easier for humans to understand that way.

    I get you,...

    Igor Micev

    May 24, 2012 at 6:42 am

    #1492484

  • RE: Logical Operators

    A good question

    But,

    "Which of the following facts are correct when constructing a WHERE clause with no parenthesis?" ?

    Not all the statements are facts, only one is - "AND has precedence...

    Igor Micev

    May 24, 2012 at 6:34 am

    #1492478

  • RE: Transactions 2

    Nakul Vachhrajani (5/22/2012)

    Good question with a couple of learning points.

    1. By default SQL does not abort the entire transaction if it encounters a statment-level failure. In this case, the primary...

    Igor Micev

    May 23, 2012 at 1:09 am

    #1491579

  • RE: Conversion error when importing data

    deep_kkumar (5/19/2012)

    Hi Thanks for the reply.

    So i cannot insert the value as PM and AM in the datatype column which is defined as "datetime" or Datetime2 in my destination table.

    Please...

    Igor Micev

    May 19, 2012 at 4:42 pm

    #1490158

  • RE: Where can i get a sample database for SQL Server 2008 R2?

    SQLRNNR (5/18/2012)

    You will need to remove the log file from the files to be attached windows.

    Highlight the log file and then click remove. The file should say not found....

    Igor Micev

    May 19, 2012 at 2:08 pm

    #1490153

  • RE: Conversion error when importing data

    deep_kkumar (5/19/2012)

    Hi,

    I am importing data from text file, where the input column value is like

    "02-APR-12 12.49.24.938000 PM" and the destination table datatype for the column is specified as "datetime".

    If i...

    Igor Micev

    May 19, 2012 at 12:41 pm

    #1490150

  • RE: SSIS 2012 - Create Catalog

    It is Saturday and a QofD. Is this a mistake or a surprising? 🙂

    Thanks anyway

    IgorMi

    Igor Micev

    May 19, 2012 at 12:09 pm

    #1490147

  • RE: Video url problem

    pallavi.unde (5/18/2012)

    Hello friends,

    I am using sql server 2008 r2 and .net.

    I am passing video links in dynamic way. but the problem i am facing here is that, the video...

    Igor Micev

    May 19, 2012 at 12:06 pm

    #1490146

  • RE: passing values to stored procedure

    ssurekha2000 (5/17/2012)

    IF EXISTS (SELECT 1 FROM E_TABLE1 WHERE eid =@eid)

    UPDATE E_TABLE1

    SET FNAME=@FNAME,MNAME=@MNAME,LNAME=@LNAME,DOB=@DOB,Address=@Address, Gender=@Gender,Phone=@Phone,

    Mobile=@Mobile,Email=@Email,...

    Igor Micev

    May 18, 2012 at 2:06 pm

    #1489948

  • RE: Foreign key

    Hardy21 (5/17/2012)

    Good One.

    If Table2 declared as following than all 3 tables created without any issue.

    create table Table2

    ( id_tb2 int primary key references table1(id_tb1),

    value2 varchar(100))

    Yes, sure

    That is the point of the...

    Igor Micev

    May 18, 2012 at 10:08 am

    #1489798

  • RE: getting output param

    ssurekha2000 (5/17/2012)

    i have a select stmt in SP with a where condition

    from c# front end i am passing the condition param to SP & i waant the result fields...

    Igor Micev

    May 18, 2012 at 10:02 am

    #1489794

  • RE: NULLS

    Thanks to the question and to community discussions.

    IgorMi

    Igor Micev

    May 11, 2012 at 11:03 am

    #1486465

Viewing 15 posts - 1,111 through 1,125 (of 1,170 total)