Viewing 8 posts - 1 through 8 (of 8 total)
some code that can be used in DTS package to check if a file exists:
Function Main()
Dim objFSO
Dim cFilePath
Dim cFileName
cFilePath = "<file path>"
cFileName = "<file name>"
-- instantiate the Scripting Object
set...
December 2, 2004 at 3:38 am
CREATE PROCEDURE Z_Billing_Payment
(@GetWhat as Varchar(15),
@PaymentID as int)
--set @GetWhat = 'something'
--set @PaymentID = 1
as
Declare @SQL VarChar(1000)
SET @SQL = 'SELECT '+@GetWhat+' From Payments Where PaymentID = '
+cast(@PaymentID as varchar (10))
--PRINT @SQL
Exec...
December 1, 2004 at 2:00 pm
select convert(varchar,cast('2003-01-08 00:00:00'as datetime),103)
December 1, 2004 at 1:40 pm
New to this this forum so dont know if this is appropriate to ask for email addresses but I have a great document about SQL injection attacks in SQL Server and...
December 1, 2004 at 1:09 pm
Beth
What exactly do you mean by creating relationships between tables in T-SQL ?
When you write any T-SQL you can relate tables together using join syntax - post what you would...
December 1, 2004 at 1:05 pm
when you insert the new batch instead of setting the
GL_Control=0
set it to = 1 then others will sequentially be in the correct order
otherwise you could
Update Yourtable
set GL_Control= GL_Control +...
December 1, 2004 at 12:59 pm
I agree with a previous reply that you can set the ansi nulls on either before or after the creat proc statement.
One point though - if the correct answer SP...
October 5, 2004 at 2:56 am
Viewing 8 posts - 1 through 8 (of 8 total)