Forum Replies Created

Viewing 15 posts - 256 through 270 (of 287 total)

  • RE: View Does not Update

    I have not been able to test this code as you have not provided any test data but try this:

    create view dbo.AB_CUST_ORDER_ACK

    as

    select dbo.CUST_LINE_BINARY.CUST_ORDER_LINE_NO,

    dbo.CUST_LINE_BINARY.BITS,

    ...

  • RE: View Does not Update

    You really should read the article that Lynn recommended. It really makes the difference between receiving a useful response and what may be, at best, a guess.

    You mentioned something...

  • RE: delete cascade trigger

    Sure.

    ALTER TABLE [dbo].[ForeignKeyTable] WITH CHECK ADD CONSTRAINT [FK_ForeignKeyTable_PrimaryKeyTable] FOREIGN KEY([col_fk])

    REFERENCES [dbo].[PrimaryKeyTable] ([col_pk])

    ON DELETE CASCADE

    The key clause in the code above is the ON DELETE CASCADE. It is...

  • RE: delete cascade trigger

    Would a simple Cascade Delete Foreign Key Relationship not work?

  • RE: View Does not Update

    Are you trying to update the view directly? Can you show the Update statement?

  • RE: Insert Word Document

    If you have Sql 2008 then you can look at FileStream Storage. In principle, its the same as storing it in the filesystem but it is much more tightly...

  • RE: Using Regular Expressions

    Most DBA's won't be keen on allowing you use the sp_OA* set of procedures (Ole automation) on a

    Production Server.

    The better approach, if you are using Sql Server 2005 is...

  • RE: Bulk Load Error

    This should help: http://support.microsoft.com/kb/935446

  • RE: SET CONCAT_NULL_YIELDS_NULL

    I'll assume you are running your code from ssms?

    If you execute dbcc useroptions you'll see that ssms overrides the database default connection settings.

    concat_null_yields_null is set to true.

  • RE: Empty Space Data

    You're welcome!

    You can also use a Case statement, by the way. I wonder if there will be a performance difference between the two approaches... It will...

  • RE: Empty Space Data

    Not tested as no test data but try this:

    SELECT c.[status]

    ,c.[depot]

    ,d.[name]

    ,c. as customercode

    ,c.[name] as customerName

    ,coalesce(nullif(c.[territory],''),'Unknown') as Suburb

    FROM [dbo].[Customer] c

    INNER JOIN [Depot] d

    ON c.[depot] = d.

    WHERE C.[status] = 'L'

  • RE: Cannot execute store procedures

    The definition of those Database Roles in BOL will make it clear as to why the permissions you require have not been granted.

  • RE: SQL 2008 Truncate Table No Longer Resets Identity Column

    I've just run a test against a Sql Server 2008 instance and it seems to reset the Identity column just fine when you Truncate the table.

  • RE: how to take the backup of all permissions

    A standard full database backup should also backup the system tables that contain the Users and their assigned permissions. No additional actions are required.

    If you are trying to map/sync...

Viewing 15 posts - 256 through 270 (of 287 total)