Viewing 15 posts - 256 through 270 (of 287 total)
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,
...
October 1, 2009 at 3:48 pm
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...
October 1, 2009 at 3:00 pm
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...
October 1, 2009 at 1:29 pm
Would a simple Cascade Delete Foreign Key Relationship not work?
October 1, 2009 at 12:13 pm
Are you trying to update the view directly? Can you show the Update statement?
October 1, 2009 at 11:49 am
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...
October 1, 2009 at 11:45 am
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...
September 28, 2009 at 6:16 pm
This should help: http://support.microsoft.com/kb/935446
September 26, 2009 at 7:23 pm
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.
September 24, 2009 at 6:58 pm
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...
September 23, 2009 at 7:27 pm
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'
September 23, 2009 at 7:06 pm
http://msdn.microsoft.com/en-us/library/ms345484.aspx
Hope that helps.
September 23, 2009 at 3:04 pm
The definition of those Database Roles in BOL will make it clear as to why the permissions you require have not been granted.
September 23, 2009 at 2:58 pm
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.
September 22, 2009 at 7:37 pm
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...
September 14, 2009 at 5:28 pm
Viewing 15 posts - 256 through 270 (of 287 total)