Forum Replies Created

Viewing 15 posts - 1 through 15 (of 41 total)

  • RE: SQL Database storage location for ADO

    it doesnt matter where the data is stored. what matters is whether SQL server is running and do you have the rights to connect to it.

  • RE: Global Table Updates

    you can do it easily using . dynamic sql.

    to give you a pointer. herez some code.

    eg:

    declare @vsql varchar(8000)

    declare @tablename varchar(300)

    declare @fieldname varchar(300)

    fetch next from...

  • RE: REPLACE to get rid of unwanted characters

    if there are leading and trailing spaces. you can use ltrim and rtrim.

    i would suggest you to provide a example and expected result. it will be easy for the members...

  • RE: CaseSensitive Select

    you can rewrite it by converting the fields into varbinary.

    SELECT COUNT(1) FROM TableName WHERE Field1=@Var1 AND Field2=@Var2 AND convert(varbinary(30),Field1)=convert(varbinary(30),@Var1)

    remember Ascii function will only look for the first character Ascii value....

  • RE: Storing an Excel Sheet in an SQL field.

    you can try using Image data typ.

    check BOL for image data type.

  • RE: My second dynamic sql statement - need some input

    wpballar i tried this its working perfectly fine.

    can u post what problem are you facing with this.

  • RE: Query Analyzer

    or

    sp_help tablename

  • RE: Not in

    Select a.col1, a.col2, b.col1, b.col2 from tablea NOT EXIST (select 1 from tableb b where a.col3=b.col3)

  • RE: How long would a backup take?

    15 hours thats a huge time. i would suggest you to take a backup on a local drive and then copy it in the tape rather then taking the...

  • RE: Stored Procedure ?

    CREATE PROCEDURE UpdateInfo @Empid Int AS

    Select * from tblEmployee where EmpID = @Empid

    go

    SNIPED!!!!!!!!!

    should get you your required result.

    Edited by - nazim on 06/19/2003 08:57:29 AM

  • RE: Performance - too many columns

    the maximum row size in sql server is 8060. so, all the cumululative size of the data cannot go beyond 8060 values. so, i dont see any performance degradation with...

  • RE: Importing 5 million rows of data every day?

    i would suggest you add two more new columns to your source table DateCreated and DateModified. first time you dump all the records from source to destination. later you can...

  • RE: Using IF in a SELECT statement?

    SELECT account_id, bill_contact, bill_address,isnull(cc_number,' '),

    isnull(cc_type,' '),isnull(cc_exp,' ')

    from account a

    left join credit_card c

    on a.account_id=c.account_id

    where a.bill_method='CC'

    HTH

  • RE: identity column

    check for DBCC CHECKIDENT in BOL.

    eg:

    DBCC CHECKIDENT (Employee, RESEED, 1)

  • RE: Help with "CASCADE CONSTRAINTS"

    if you are trying to drop a table being referenced by other table.

    first manually drop the referencial constraints then only you can drop the table.

    Edited by - nazim on 06/18/2003...

Viewing 15 posts - 1 through 15 (of 41 total)