Viewing 15 posts - 4,996 through 5,010 (of 5,356 total)
quote:
ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the...
June 11, 2003 at 4:56 am
Hello demos,
quote:
At the moment I am looping through the SQL stored procedure from VB using a straight WHERE ColumnB = @SomeVariable clause.
June 11, 2003 at 4:44 am
Hello amelvin,
quote:
declare @sqlset @sql='select * from tablea where columnb in (' + @SomeVariable + ')'
exec sp_executesql @sql
June 11, 2003 at 3:24 am
Hello demos,
sorry, hit the Enter button too early
declare @test-2 varchar(10)
declare @stmt varchar(100)
set @test-2 = '25,10789'
set @stmt = 'SELECT * FROM TableA WHERE ColumnB IN (' + @test-2 + ')'
EXEC(@stmt)
All...
June 11, 2003 at 3:03 am
Hello demos,
quote:
SELECT * FROM TableA WHERE ColumnB IN (@SomeVariable)and the variable can be = 1 or = 1,2,3 etc
June 11, 2003 at 2:54 am
Hello sbuckby,
quote:
We had exactly this same problem. Our client provides a work order system that we HAVE to use. We can extract...
June 11, 2003 at 12:22 am
Ever been around with actuaries or top management?
quote:
This may be slightly off topic, but may be of some use. I spent...
June 11, 2003 at 12:15 am
Hello darshit_99,
quote:
my problem is that I have a dynamic stored procedure which has 10 parameters such as @param1.....@param10. I have a asp...
June 10, 2003 at 9:16 am
Hello Markus,
quote:
Here you have a script which corrupts the IAM of a table. Note that after running the script the table in...
June 10, 2003 at 8:59 am
Hello tmp,
quote:
Maybe you have the select into/bulk copy option checked in your db, and operations like bulk insert, bulk copies, truncate tables...
June 10, 2003 at 8:49 am
Hello Michael,
quote:
select into's
are you sure about this?
quote:
See...
June 10, 2003 at 8:42 am
It is happening again!
Again there are non-logged transactions where rollforward cannot be applied.
What are non-logged transaction? I've read through BOL, but don't know much more as before. Is this...
June 10, 2003 at 8:33 am
Hello wongj5,
quote:
Let's say I have 6 Word documents (Worddoc1.doc, Worddoc2.doc, Worddoc3.doc........) that have been uploaded into a SQL Server 2000 table. The...
June 10, 2003 at 7:56 am
Hello Flavio,
quote:
SELECT * FROM [dbname].dbo.table_name_2work
SELECT * FROM [serverName].[dbname].dbo.table_name_2
not work ??
see BOL, syntax conventions, Transact-SQL for...
June 10, 2003 at 7:36 am
It seems that if you can't trust your DBA's, you'll have a problem...
quote:
Interesting!Hope there aren't any unscrupulous DBA's with a company grudge...
June 10, 2003 at 7:27 am
Viewing 15 posts - 4,996 through 5,010 (of 5,356 total)