Viewing 15 posts - 166 through 180 (of 345 total)
see the option clause on the select statement.
I can't find the knowledgebase article about it.
Try posting this on the microsoft site
http://msdn.microsoft.com/newsgroups/
I'll do some more research and see if...
November 6, 2003 at 6:03 am
no.
see sp_renamedb in bol
Cursors never.
DTS - only when needed and never to control.
November 6, 2003 at 5:49 am
select count(*) from master..sysprocesses
where db_id = dbid('dbname')
Cursors never.
DTS - only when needed and never to control.
November 6, 2003 at 5:48 am
Is it the only thing accessing the table?
If so try with maxdop = 1.
Do you have the latest service pack?
There have been some bugs fixed with parallelism causing deadlocks.
Cursors never.
DTS...
November 6, 2003 at 5:13 am
???
Why do you care what a variable is named?
Why do you want it to be based on a parameter?
Cursors never.
DTS - only when needed and never to control.
November 6, 2003 at 5:10 am
You can name tthe columns and use convert(varchar(7000,txtcol) on the text column.
Do you want to include the text in the distinct?
Cursors never.
DTS - only when needed and never to control.
November 6, 2003 at 4:18 am
There is currently no equivalent of this in sql server - you have to coed it yourself.
You can use a recursive SP or function but probably better to use a...
November 6, 2003 at 4:15 am
Full backup only backs upenough of the tr log to do a restore.
You can restore tr logs across full backups - it is one of the reasons for doing them....
November 6, 2003 at 4:10 am
see
http://www.nigelrivett.net/spFormatOutputBuffer.html
Cursors never.
DTS - only when needed and never to control.
November 6, 2003 at 4:06 am
>> The order table has a unique index key which surly must need a Clustered index to speed performance?
No.
Depends on the nature of the system. A clustered index will help...
November 2, 2003 at 6:27 pm
declare @i int
select @i = -1
while @@rowcount > 0
begin
select @i = @i + 2
insert newtbl
select SalesID, substring(States,@i,2)
from oldtbl
where len(Sales) >= @i + 1
end
Cursors never.
DTS - only when needed and never...
November 1, 2003 at 5:16 pm
You will need something to provide the dates but you can join to the table rather than insert.
Cursors never.
DTS - only when needed and never to control.
November 1, 2003 at 5:10 pm
Given the same parameters it must return the same result.
You cannot use things like getdate() within the function.
There are a lot of restrictions on functions - see bol.
Cursors never.
DTS -...
November 1, 2003 at 1:50 am
No idea what you want - can you give an example.
Cursors never.
DTS - only when needed and never to control.
November 1, 2003 at 1:37 am
a stored procedure is executed
exec s_mysp
whereas a function can be used in a select statement - depending on it's type.
A function has to be deterministic.
See bol for a description.
Cursors never.
DTS...
November 1, 2003 at 1:37 am
Viewing 15 posts - 166 through 180 (of 345 total)