Viewing 15 posts - 1 through 15 (of 109 total)
You can use the Fully Qualified Name
SERVER.Database.Owner.Procedure name
annd execute the procedure on another server once you have added it as linked server.
Also remote stored procedures are not within the...
October 9, 2003 at 1:15 am
Where have the insert statements being written?
In the stored procedures or on the client side?
He who knows others is learned but the wise one is one who knows himself.
October 9, 2003 at 12:53 am
Restart the SQl server Service.
Issue the sp_detach_db command for the database you want to copy on some other place.
Copy the .mdf and .ldf to the location of your choice and...
September 29, 2003 at 2:51 am
Have you detached the database.
BOL States that:
sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation
He who knows others is...
September 29, 2003 at 2:35 am
quote:
Update @Tablename Set @FieldName = Replace(@FieldName,@FindString,@RepalceString)GO
Make it
'Update ' + @Tablename + 'Set ' + @FieldName + ' =...
September 26, 2003 at 4:16 am
You can create Dynamic SQL statments
and execute them using EXEC.
But I am not sure if this is the right way to go about.
What I feel is that you are trying...
September 26, 2003 at 4:01 am
I am completely unaware of these function,
I mean how to use them and why?
Please give me some leads.
He who knows others is learned but the wise one is one who...
September 26, 2003 at 12:28 am
Try this Out
==============
declare @sqlstring varchar(1000)
declare @currentchar varchar(10)
declare @mysqlstring varchar(8000)
set @sqlstring ='sum( case customersales.cutomerid when ''XXX'' then customersales.totalsales else 0 end )'
set @mysqlstring =''
set @currentchar =''
declare @m varchar(8000)
declare @start...
September 25, 2003 at 11:47 pm
One way I can suggest is getting all the unique values needed for buliding the columns
in a temporary table.
Then using dynamic SQl you could build your Case statements.
I believe ...
September 25, 2003 at 10:37 pm
Any errors that you are getting?
He who knows others is learned but the wise one is one who knows himself.
September 25, 2003 at 3:49 am
Try this
e.g.
update customers set
outstanding=case when coalesce(outstanding,0)=0 then null else coalesce(outstanding,0) end
He who knows others is learned but the wise one is one who knows himself.
September 24, 2003 at 11:20 pm
Where do you intend to display the data.
As far as I remember regional settings are used to display the data according to particular format.
He who knows others is learned but...
September 23, 2003 at 6:11 am
One way I found is using the database diagrams.
There one can change the file groups.
He who knows others is learned but the wise one is one who...
September 19, 2003 at 6:29 am
I am not sure if it can be done using EM
I think I am missing something obvious.
Can u guide me frank?
He who knows others is learned...
September 19, 2003 at 6:18 am
If I need to move existing tables to other filegroups, How do I do them?
I mean do I have to do it explicitly?
Like Create a table on other file group...
September 19, 2003 at 6:02 am
Viewing 15 posts - 1 through 15 (of 109 total)