Forum Replies Created

Viewing 15 posts - 9,766 through 9,780 (of 15,374 total)

  • RE: Need Suggestions on creating new table

    yuvipoy (12/26/2012)

    Hi,

    I am having a condition that i need to create tables on run time that is

    Say for customer 1, if logins he will be giving some data which is...

    December 26, 2012 at 8:00 am

    #1571573

  • RE: editting data in an encrypted column

    Where is the encrypted data being decrypted? Is all the encryption handled in the application or in the database?

    December 26, 2012 at 7:53 am

    #1571572

  • RE: Table documentation advice

    SQL_Kills (12/26/2012)

    Hi,

    First of all I hope everyone has had a good Christmas!

    Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think how much detail...

    December 26, 2012 at 7:44 am

    #1571568

  • RE: SQL Question

    edward_hall76 (12/25/2012)

    I am using Sql 2008 server and Dreamweaver cs4 and wanting to use asp.net. Or how to connect to Sql 2008 server using php. Does anyone one know...

    December 26, 2012 at 7:41 am

    #1571567

  • RE: READ_COMMITTED_SNAPSHOT & TRUNCATE TABLE

    geoffrey crombez (12/21/2012)

    Hi,

    when I use the READ_COMMITTED_SNAPSHOT and use DELETE FROM table the other session is not locked when SELECTING data.

    However when I use TRUNCATE TABLE it does block the...

    December 26, 2012 at 7:31 am

    #1571563

  • RE: Query Help

    Adi Cohn-120898 (12/26/2012)

    Am I missing something? Seems to me that this should work:

    select cStudentID, cCurrentGradeCode, cAnticipatedGradeCode

    from #temp

    where cCurrentGradeCode <> '99' or cAnticipatedGradeCode <> '99'

    Adi

    According to the requirements that won't...

    December 26, 2012 at 7:19 am

    #1571559

  • RE: Insert Error: Column name or number of supplied values does not match table definition.

    imaceo58 8163 (12/24/2012)

    I am getting this same error message ...Column name or number of supplied values does not match table definition.

    My table definition is...

    December 26, 2012 at 7:15 am

    #1571557

  • RE: Len did not display right size

    Again...what is the datatype? The best you are going to get is pure speculation unless you give us the whole picture.

    December 21, 2012 at 3:22 pm

    #1571087

  • RE: Better way to write this?

    MyDoggieJessie (12/21/2012)

    Ninja's_RGR'us (12/21/2012)

    I get them just fine.

    I get them, they're just coming in several hours after-the-fact, last night it was after 10pm CST before I got post notifications from 4-5pm...

    December 21, 2012 at 2:53 pm

    #1571076

  • RE: Better way to write this?

    MyDoggieJessie (12/21/2012)

    Lynn, the actual execution plan is the first first attachment in my original post

    BTW - what is up with SSC today not delivering notifications for posts???

    I thought it was...

    December 21, 2012 at 2:41 pm

    #1571072

  • RE: Len did not display right size

    adonetok (12/21/2012)

    I use len function to find out varchar column data size but did not display right size.

    For example, in some cell of varchar column, data is "0", "6"... but...

    December 21, 2012 at 2:39 pm

    #1571071

  • RE: Query Help

    Here is another way.

    select t.* from #temp t

    join #temp t2 on t.cStudentID = t2.cStudentID

    where t2.cCurrentGradeCode <> '99' or t2.cAnticipatedGradeCode <> '99'

    order by t2.cStudentID

    December 21, 2012 at 12:33 pm

    #1571035

  • RE: Query Help

    Excellent job posting ddl, sample date and desired output!!! I wish everybody would post their questions like this.

    Here is one way to do this.

    select * from #temp

    where cCurrentGradeCode + cAnticipatedGradeCode...

    December 21, 2012 at 12:31 pm

    #1571034

  • RE: How to copy the structure of a database?

    According to BOL it should be db_ddladmin.

    http://msdn.microsoft.com/en-us/library/bb895179.aspx

    December 21, 2012 at 12:07 pm

    #1571030

  • RE: Table and SP cannot have same name

    Lowell (12/21/2012)

    reminds me of horrors like this:

    CREATE TABLE [SELECT]([SELECT] INT IDENTITY(1,1) NOT NULL PRIMARY KEY )

    SELECT [SELECT].[SELECT] FROM [SELECT] WHERE [SELECT] = 1

    OMG my eyes are bleeding!!! That is an...

    December 21, 2012 at 10:18 am

    #1571005

Viewing 15 posts - 9,766 through 9,780 (of 15,374 total)