Viewing 15 posts - 12,481 through 12,495 (of 18,923 total)
Around almost anyone with more than 250 post actually
.
October 20, 2005 at 5:24 pm
Please post the whole code so we know what we're working with.
October 20, 2005 at 4:21 pm
Select id, dbo.fnName(id) from dbo.YourTable????????
October 20, 2005 at 4:18 pm
IF Object_id('ListTableColumns') > 0
DROP FUNCTION ListTableColumns
GO
CREATE FUNCTION dbo.ListTableColumns (@TableID as int)
RETURNS varchar(8000)
AS
BEGIN
Declare @Items as varchar(8000)
SET @Items = ''
SELECT
@Items = @Items + C.Name + ', '
FROMdbo.SysColumns C
WHEREC.id = @TableID
AND OBJECTPROPERTY(@TableID, 'IsTable')...
October 20, 2005 at 2:46 pm
You're seriously suggesting dynamic SQL for this?
![]()
![]()
![]()
October 20, 2005 at 2:38 pm
Use netscape so the identation is lost... maybe someday I'll translate to html code...
October 20, 2005 at 1:47 pm
Works well and it is easy to copy and paste
.
Besides you'd be the first to figure it out all by himself (without having...
October 20, 2005 at 1:37 pm
And I thaught we only had to backup after
.
October 20, 2005 at 1:12 pm
Still can't be reminded when you don't know it in the first place... ![]()
October 20, 2005 at 12:58 pm
Check the script section... there's surely something there.
October 20, 2005 at 12:40 pm
Dynamic Search Conditions in T-SQL
Arrays and Lists in SQL Server
Neat function to do this :
IF EXISTS (Select * from dbo.SysObjects where...
October 20, 2005 at 12:38 pm
The parameters are not all varchars and of variable datatypes???
You'll have to quote the varchars in the raw data directly and remove the quotes from the select statement (4 per...
October 20, 2005 at 12:26 pm
EXEC master.dbo.xp_execresultset 'SELECT Statement + '' '''''' + ServerName + '''''', '''''' + ReplaceValue + '''''''' AS ExecStatement FROM dbo.MyTable', 'DB you want the code executed from'
October 20, 2005 at 12:17 pm
Check the list of foreign keys on the main table?!
October 20, 2005 at 12:00 pm
Viewing 15 posts - 12,481 through 12,495 (of 18,923 total)