Replace filename with the name of the .sql file, eg if the file you want to execute is called test.sql in the temp directory of your c: drive then would use isql /S servername /U username /P password -d databasename -b /m-1 /i c:\temp\test.sql Remember to change the other parameters as well.
2003-11-19
1 reads
quote: ...and why BI for the category?? Administration would probably be a more appropriate category.
2003-08-07
1 reads
try this...DTS gets funny with return codes and setting output variables. DECLARE @RC int DECLARE @partition varchar(10) DECLARE @nextid int DECLARE @id int set nocount on -- Set parameter values EXEC @RC = [TrafficAnalysis_Prod].[dbo].[usp_get_next_tblcdr_id] @partition = 'aged', @nextid =@id OUTPUT set nocount off SELECT @id AS next_cdr_id
2003-07-23
1 reads
Is this what you want? update ITEM set CTLG_NO = replace(CTLG_NO,'55551111','41331111') test it first though
2003-07-23
2003-06-18
jpipes, Thanks for your help, I'm getting an error on the statement: Incorrect syntax near the keyword 'GROUP'. It appears that it is choking on the group last group by portion on the page. I've tried fixing it, but I have yet to figur out why it's doing that. Do you know? Thanks for the […]
2003-06-18
Assuming you are using sql 2k I would say use a global variable to assign the date of the information you want to pull and only move those as apposed to trying to link the tables across servers... sorry I do not know Pervasive so you may not be able to do this.
2003-06-13
2003-06-05
The easiest thing to do would be to create a three column table valued function that splits the time and converts to seconds. Then you could always add all three colums up. I didn't have time to write it, but I will if you still need help.
2003-05-27
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC