Viewing 13 posts - 61 through 73 (of 73 total)
Old School:
loop through all SP's
exec sp_helptext 'proc name'
search text
break (when found)
end
April 9, 2004 at 3:58 am
For future reference & a little bit of old school:
create <tablename>(<fieldname> Nvarchar(1000))
grant all on <tablename> to public
EXEC master..xp_cmdshell "bcp DB..<tablename> in C:\<filename> /U<user> /P<password> /n"
Now you have...
April 4, 2004 at 4:10 am
data structures should be sepperate, when any of your field data in a table is repeated.
example like patient record
is linked to more than one address, & treatments, & appointments, etc... so...
April 1, 2004 at 6:30 am
You need a sequential aproach:
because you start a transaction and do all the processing in the same transaction, the flag is being set at the end of your process...(commit)
other calls start...
April 1, 2004 at 6:05 am
You need SOAP & SQLXML:
see (RE: Soap RPC via SQLXML
Posted 3/16/2004 9:39:00 AM) from fhanlon user.
March 30, 2004 at 4:02 pm
You're both right & now have the requestor re-thinking the purpose for his question...
I would like to know why he/she needs to do this action and if it is a fast fix...
March 30, 2004 at 3:44 pm
I believe this needs "DECLARE <name> INSENSITIVE CURSOR FOR";otherwise its not in a loop...
Insert Into @temp
Select Distinct employeeid
From directory
Where higmanagerempid =...
March 22, 2004 at 5:59 pm
Simple answer & most overlooked;is that you can create a trigger for each event like this:
CREATE TRIGGER [sp_INS_trrequest] ON [dbo].[TrRequest]
FOR INSERT
AS
BEGIN
CREATE TRIGGER [sp_UPD_trrequest] ON [dbo].[TrRequest]...
March 19, 2004 at 6:12 pm
A large procedure is memory intensive; lots of temp tables means lots of memory allocation; Intermittent errors caused by reused memory area, like partitioning between functions. Something gets dropped, usually...
March 19, 2004 at 5:54 pm
This may seem to simple, but why not place 'FETCH ABSOLUTE @FromRec FROM cPartners' into a loop?
DECLARE @MaxRec Int
SET @MaxRec = 10
WHILE (
March 19, 2004 at 5:29 pm
Recursive function example;
Trick is using simplified create function,
then use alter function to add the recursive call.
http://www.sqlservercentral.com/scripts/contributions/890.asp
March 19, 2004 at 5:04 pm
Also, you can resort to forcing indexes, whenever the optimizer is being stubborn…
(NOLOCK INDEX=<index_name>
March 19, 2004 at 4:21 pm
Other than creating large dynamic statements, why would you need a Nvarchar(4000)?
SQL supports (image & text) types which are much more effient in storage&recall..
March 16, 2004 at 5:45 pm
Viewing 13 posts - 61 through 73 (of 73 total)