OPENROWSET

Technical Article

RE: How to import a .sql file with DTS

  • Reply

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

Technical Article

RE: DTS global variable value not being set properly

  • Reply

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

Technical Article

RE: help selecting sums from two similar tables

  • Reply

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

Technical Article

RE: Extracting from an ODBC source

  • Reply

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

Technical Article

RE: Evaluating a string arithmatic expression

  • Reply

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

Blogs

Flyway Desktop Projects for My PoC

By

In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023

By

Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs

Forums

Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...

migration

By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers