You can use profiler to track the users ... You can also query from the backend ...
Select program_name,hostname, nt_username, nt_domain from master..sysprocesses
Where Ltrim(program_name) <>''
You can also use sp_who2 to get the users connected ...
HTH,
Vinod Kumar
Hi,
replace is one option available ...
Like
field = repace(field,'-','')
You can use the Case Statement construct also to achieve this (provided you know the length of the string):
DECLARE @BadStr VARCHAR(30)
SET @BadStr = '6169-90'
SELECT CASE WHEN SUBSTRING(@BadStr, 1, 1) LIKE '[0-9]'...
You can surely use quotes with OpenQuery(). If you post us the complete code then we can surely debug the problem. Here is an example that works perfectly.
SELECT * FROM OPENQUERY([servername], ' SELECT * FROM northwind.dbo.employees WHERE employeeID = ''1'' ')
HTH,
Vinod Kumar
Donot you have an Identity Column. If you have one then you can update the second set easily like
Update WordFileLinks
SET
fileID=a.fileID + 100000
From WordFileLinks a
Where [Primary key] > 10000 -- (eg)
and fileID < 7000
HTH,
Vinod Kumar
Declare @field varchar(50), @loc int
Set @field = '4;4;3;65;43;813;345'
Set @loc = 3
CREATE TABLE #temp (PkID Int Identity, Id INT NOT NULL)
declare @param VARCHAR(8000)
Set @param = REPLACE(@field, ';', ' UNION SELECT ')
Select @param
INSERT #temp EXEC ('SELECT ' + @param)
SELECT * FROM #temp...
Why do you ant to come to your application to do this update? If you are using integrated authentication then you can fire a trigger at the backend for the FundSites that would update the AdminID field.
HTH,
Vinod Kumar
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.