SKIP & NOSKIP Back No Differnce To Backup Duration

Aug 1, 2007

Hi

I run a full backup once a month and a transaction log backup every 10 mins through working hours for the remainder of the month until the backup is re-initialised at th start of the following month.

I backup to virtual sql disk object devices.

As the month progresses the backup takes longer and longer whilst the amount of data being backed up every 10 minutes cycle is always roughly the same. its about 5 seconds for a backup on day 1, up to 5 mins at the end of the month.

I noticed that NOSKIP was being used in the command - i changed this to SKIP, but it made no difference in the amount of time the backup takes. Isnt this suppoed to stop some sort of integrity scan on all other backup sets in the archive?

full syntax of the backup command that runs now is:

BACKUP LOG [objectstore] TO [Backup_objectstore] WITH NOFORMAT , NOINIT , NOUNLOAD , NAME = N'objectstore backup', SKIP , REWIND , STATS = 10

but as I say, the SKIP command instead of NOSKIP makes no difference.

whats going on here?

any help appreciated.

Thanks

Alastair.

"A computer once beat me at chess - but it was no match for me at kick boxing" - Emo Phillips.

View 2 Replies


ADVERTISEMENT

Transact SQL :: Get Total Request Duration From Multiple Task Duration?

Jun 4, 2015

I have the following SQL query

SELECT
[Req_ID]
,[Service_Name]
,[Req_Started_Date]
,[Task_Name]
,[Task_Status]
,[Performer_Full_Name]

[code]....

Which works fine, but what I need to calculate the total duration of a request based on the duration of the tasks completed in the request based on Req_ID. I would like to use the CASE statement I have to determine the SLA_Mins for each task and add them together to get total request SLA_Mins.

Below is the create table schema and data

GO
/****** Object: Table [dbo].[MidrangeOtherSourceControl] Script Date: 06/03/2015 18:13:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MidrangeOtherSourceControl](
[Req_ID] [float] NULL,
[Service_Name] [nvarchar](255) NULL,

[code]....

View 9 Replies View Related

Getting DTS Packages Back From A Backup?

Feb 13, 2004

Does anyone know how to get a DTS package back into the EM's Local Packages from a disk backup?

In other words, inside Package Designer, it is possible to save a package to disk as a .dts file.

But, if the package has been removed from the EM Local Packages, I don't see any way to get the package imported back in from the backup file on disk.

The import/export wizard seems to be for moving a package from one database to another. I don't see anything that stands out as a way to read a 'flat' file from disk.

Anyone know how this is done? (I assume it can be done, else, why provide a way to save a package out to disk in the first place?)

Thanks much.

Randyvol

View 6 Replies View Related

What Does Exactly The Differnce Sql Query?

Jul 9, 2004

Hi,
I've found this query in a web:
SELECT * FROM dbo.Orders
WHERE DIFFERENCE(ShipName, ‘ernest’) >= 3

And I want to know what exactly does, i've tried it and it shows me values that i don know how it obtains, can anybody tell me what this query does?

Thanks so much

View 2 Replies View Related

Time Differnce

Nov 15, 2007

i want to find employee numbers who have spent more than 30 mins lunch break

table structure

Lunch(EmployeeId,LunchIn,LunchOut)

Thank You In Advance

View 1 Replies View Related

Back Up And Restore Using Transaction Log And Incremental Backup

Feb 1, 2001

hi, I would like to know the correct reaction for a crash in both senarios.
First senario,
I made a full back up at 6 am , then scheduled sql server to make transaction log back up every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 12:30. How would I resotre the data in the first senario....Can I restore the full back up done at 6 am then restore the last transaction log backup ( which is 12 Noon ) . I am not sure If I need to resotre the whole tran from 6 am till the time it was crashed.

Second senario,

I made a full back up at 6 am, then scheduled sql server to make Incremental backup every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 3:00 pm. How would I resotre the data in the second senario. ....Do I restore the full backup at 6 am then restore each incremental backup backwords ( 2,12,10,8)

AS you can see, I am not sure how to deal with this issue, I do appreciate your feedback.

Best regards

Ahmed

View 1 Replies View Related

Full Back Up ( Transaction Log ) Vs ( Incremental Backup)

Feb 1, 2001

hi, I would like to know the correct reaction for a crash in both senarios.
First senario,
I made a full back up at 6 am , then scheduled sql server to make transaction log back up every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 12:30. How would I resotre the data in the first senario....Can I restore the full back up done at 6 am then restore the last transaction log backup ( which is 12 Noon ) . I am not sure If I need to resotre the whole tran from 6 am till the time it was crashed.

Second senario,

I made a full back up at 6 am, then scheduled sql server to make Incremental backup every 2 hours (8,10,12,2 pm,4,6,8) . If I have a crash at 3:00 pm. How would I resotre the data in the second senario. ....Do I restore the full backup at 6 am then restore each incremental backup backwords ( 2,12,10,8)

AS you can see, I am not sure how to deal with this issue, I do appreciate your feedback.

Best regards

Ahmed

View 2 Replies View Related

Maintenance Back Up Plan Not Deleting Prior Backup

Apr 25, 2001

I have a maintenance plan set to back up my 2 primary databases, one about 1 GB, the other about 2GB. I have about 4 GB available on the back up drive. I have set it to delete old backups more than 1 minute old. Problem is, the first night it works fine, the second night it sometimes it refuses to delete the old and therefore does not have enough space to complete the new back-up. Does anyone run into this before? Does it complete both back-ups THEN erase the old, in which case I need to have about 6GB available? Sometimes it works and sometimes it doesn't. It can be going along fine for weeks then stop working. Any info or links to how this is supposed to work would help.

TIA

View 3 Replies View Related

Differnce Between SqlServer 2000 And 2005

Mar 22, 2007

Hi,
I want to know major functionalites differences between Sql server 2000 and 20005..Am expection ans as soon as possible
 
 
With Best Regards
C.Rajesh 
 

View 1 Replies View Related

Having Difficulty Setting Back Up To Back Up File Wihout Datetime Stamp SQL 2K

Apr 24, 2007

Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick

View 5 Replies View Related

Mirroring :: Principal Database Get Role Back After Being Back On Line

May 14, 2015

New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.

When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?

View 2 Replies View Related

Reporting Services :: Run Two Reports Back To Back Without Page Eject?

Jun 9, 2015

I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.

View 4 Replies View Related

Differnce Between A Column That S A Primary Key And A Column That S A Key/index With Isunique=true

Sep 13, 2007



Hi,

Please, What s the differnce between a column that s a primary key and a column that s a "key/index with Isunique=true"?

Thanks a lot.

View 4 Replies View Related

How Do I Back-up &> Truncate &> Shrink &> Back-up SQL 2000

Jul 20, 2005

Hello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.

View 2 Replies View Related

Differnce Between Stored Procedure And Stored Functions?

May 22, 2006

Hi all,
What is the Difference between Stored Procedure and Inline Quries...... Is Stored Procedure is faster then Inline Query...
What is the professional Approch....
I m using Inline Quries in my Professional Project with Microsoft Application Block..... Someone Said me this is not a professional approch... use stored procedure instead of Inline Quries... i m so puzzled...
plz guide me..... :)
Thanx
Sajjad

View 3 Replies View Related

Skip 1st And Last Row In DTS

Mar 13, 2001

Does any one know, how to skip the first and last row of a text file while importing using DTS.

ThankX in advance.

View 1 Replies View Related

Do While Skip In Selecting...

Oct 21, 2004

Hello:

I have one table and it contains a column named ID Number, and a column named Date. I have a Do While statement that runs a SQL select statement a few times based on the number of records with the same ID Number. During the Do While statement the information is copied into another table and deleted from the old table. After I look at the results, I see that at the second Do While loop, the data was not selected and the Select statement did not run... so the old variable value from varValue is used again... Any reasons on why?

Here is a code snippet of what is going on:
Do While varCount < varRecordCount
conSqlConnect.Open()
cmdSelect = New SqlCommand ("Select * From temp_records_1 where [id number]=@idnumber and date<@date", conSqlConnect)
cmdSelect.Parameters.Add( "@accountnumber", "10000" )
cmdSelect.Parameters.Add( "@date", dtnow )
dtrdatareader = cmdSelect.ExecuteReader()
While dtrdatareader.Read()
If IsDbNull(dtrdatareader("value")) = false Then
varValue = dtrdatareader("value")
End If
End While
dtrdatareader.Close()
conSqlConnect.Close()

'#####The information above is copied to another table here
'#####The record where the information was received is deleted.

varCount = varCount + 1
LoopAny ideas?

View 2 Replies View Related

To Skip Recovery

Mar 13, 2000

Hello somebody,

I submitted an update query on a table of 80 million rows, in the weekend. When I returned on Monday, the transaction was still running. I thought some thing wrong happened and cancelled the transaction. It was taking long time to rollback the transaction. I recycled the SQL Server assuming it will do faster recovery. Now I realised that anyway it is going to take lot of time. And SQL server is not going to be up till the database is recoverd completely.
Now can any body suggest me any thing to faster this process or skip this process. I dont know how long it is going to take rollback the transaction which ran for more than 70 hours.


Thanx in advance.

View 1 Replies View Related

RPC - Skip Tables

Apr 19, 2004

I was attempting to use BCP today via xp_cmdshell. I have never done anything with BCP before, so it was very enlightening. However, I ran across a problem that maybe someone could help explain to me a little more.

I am using the "queryout" option, and when I run it, the error I get is that you "can't skip fields except for on inserts" or something like that.

The reason I was trying to use bcp is the ability to dynamically generate a filename, i.e. filename = 04182004 (the date). Because in the file name argument, I can use a variable. Make sense?

Since I apparently can't ignore fields, I am thinking of taking all of the information I need daily out, and into a seperate table, then I can use the xp_cmdshell to run a bcp that creates a file with the date as a filename, and I won't be ignoring any fields because I have just put the information I need in the new table. Am I making sense? Does this sound like an appropriate thing to do?

View 3 Replies View Related

Skip The Error

Oct 25, 2007



Hello

I am tryung to execute a Store Proc using Execute SQL Task.

I am very aware that if there is any errors occur I have handled it sufficiently.

All I want to do is, when ever there are any errors in teh Store Proc then this Execute SQL task should not fail and it should go for the next Task in teh control flow.

How can I do this?

View 4 Replies View Related

Skip Footer Row

Apr 23, 2008

Hi,


There is an option in ssis to skip one or more header rows, but there isn't any thing to skip one or more footer rows.

Example:

header bla bla
1;"Joe";24;"New York"
2;"John";54;"Washington"
3;"Phil";36;"San Francisco"
footer bla bla


I skip the first record in the source definition. So I have left 4 records. How do I skip the fourth (last) record? The value contains some statistics so I cann't look for a special value. Is there a way to skip the last record with a script component?

Joost

View 5 Replies View Related

Sqldatareader Reads From Second Row Skip The First Row.

Jun 20, 2007

Hello,
im using sqldatareader to read my data and whenever time i loop through the reader it starts from second row why is that?
here is my code:while (reader.Read()){hinfo.Name = reader["_name"].ToString();hi.Add(hinfo);}
i look at the database and i have two rows but its reading only the second row, skiping the first row 
 

View 2 Replies View Related

Skip First Row In A Datatable At Insert Into SQL...

Jan 10, 2008

Hi, I have the code below. I need to skip the first row in the datatable as it has the headers. This works now, but my gridview gets the header row inserted as a record.Private Shared Sub InsertData(ByVal sourceTable As System.Data.DataTable, ByVal destConnection As SqlConnection)        ' old method: Lots of INSERT statements         ' first, create the insert command that we will call over and over:         destConnection.Open()        Using ins As New SqlCommand("INSERT INTO [tblAppointmentDisposition] ([contactdate], [dnbnumber], [prospectname], [businessofficer], [phonemeeting], [followupcalldate2], [phonemeetingappt], [followupcalldate3], [appointmentdate], [appointmentlocation], [appointmentkept], [applicationgenerated], [applicationgenerated2], [applicationgenerated3], [comments], [newaccount], [futureopportunity]) VALUES (@contactdate, @dnbnumber, @prospectname, @businessofficer, @phonemeeting, @followupcalldate2, @phonemeetingappt, @followupcalldate3, @appointmentdate, @appointmentlocation, @appointmentkept, @applicationgenerated, @applicationgenerated2, @applicationgenerated3, @comments, @newaccount, @futureopportunity)", destConnection)            ins.CommandType = CommandType.Text            ins.Parameters.Add("@contactdate", SqlDbType.Text)            ins.Parameters.Add("@dnbnumber", SqlDbType.Text)            ins.Parameters.Add("@prospectname", SqlDbType.Text)            ins.Parameters.Add("@businessofficer", SqlDbType.NVarChar)            ins.Parameters.Add("@phonemeeting", SqlDbType.Text)            ins.Parameters.Add("@followupcalldate2", SqlDbType.Text)            ins.Parameters.Add("@phonemeetingappt", SqlDbType.Text)            ins.Parameters.Add("@followupcalldate3", SqlDbType.Text)            ins.Parameters.Add("@appointmentdate", SqlDbType.Text)            ins.Parameters.Add("@appointmentlocation", SqlDbType.Text)            ins.Parameters.Add("@appointmentkept", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated2", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated3", SqlDbType.Text)            ins.Parameters.Add("@comments", SqlDbType.Text)            ins.Parameters.Add("@newaccount", SqlDbType.Text)            ins.Parameters.Add("@futureopportunity", SqlDbType.Text)            ' and now, do the work:             For Each r As DataRow In sourceTable.Rows                For i As Integer = 0 To 16                    ins.Parameters(i).Value = r(i)                Next                ins.ExecuteNonQuery()                'If System.Threading.Interlocked.Increment(rowscopied) Mod 10000 = 0 Then                'Console.WriteLine("-- copied {0} rows.", rowscopied)                'End If            Next        End Using        destConnection.Close()    End Sub

View 3 Replies View Related

CSV To SQL Import, Skip First Row (two Functions)

Jan 10, 2008

I have this code. It works, but inserts the header row into the gridview. I need to avoid the first row.   Protected Sub excelimport(ByVal dataSrc As SqlDataSource, ByVal fileName As String)        Dim intFileNameLength As Integer        Dim strFileNamePath As String        Dim strFileNameOnly As String        Dim strpath As String        If Not (uploadfile.PostedFile Is Nothing) Then            strFileNamePath = uploadfile.PostedFile.FileName            intFileNameLength = InStr(1, StrReverse(strFileNamePath), "")            strFileNameOnly = Mid(strFileNamePath, (Len(strFileNamePath) - intFileNameLength) + 2)            'If File.Exists(paths & strFileNameOnly) Then            'lblMessage.Text = "Image of Similar name already Exist,Choose other name"            'Else            If uploadfile.PostedFile.ContentLength > 40000 Then                lblmessage.Text = "The Size of file is greater than 4 MB"            ElseIf strFileNameOnly = "" Then                Exit Sub            Else                'strfilename = uploadfile.FileName.Substring(0, (InStr(uploadfile.FileName, ".") - 1))                strFileNameOnly = fileName & ".csv"                strpath = "/sites/marketing/apps/disposition/content/excel/" '& strFileNameOnly                uploadfile.PostedFile.SaveAs(Server.MapPath(strpath) & strFileNameOnly)                'lblmessage.Text = "File Upload Success."                'Session("Img") = strFileNameOnly                Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & (Server.MapPath(strpath)) & ";Extended Properties=""Text;HDR=No;FMT=Delimited"""                '"Provider=Microsoft.Jet.OLEDB.4.0;" & _                '"Data Source=" & "/" & strFileNameOnly & ";" & _                '"Extended Properties=Excel 8.0;"                Dim conn As New OleDb.OleDbConnection(strConn)                Dim myData As New OleDbDataAdapter("SELECT * FROM " & strFileNameOnly, conn)                Dim myDatatable As New System.Data.DataTable                Dim mySqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("BDOConnectionString").ToString())                ''You must use the $ after the object you reference in the spreadsheet                myData.Fill(myDatatable)                InsertData(myDatatable, mySqlConnection)                'System.IO.File.Delete(Server.MapPath(strpath))                GridView1.DataBind()                upload.Visible = False            End If        End If        ' GridView1.DataSource = myDataset.Tables(0).DefaultView        ' GridView1.DataBind()    End Sub    Private Shared Sub InsertData(ByVal sourceTable As System.Data.DataTable, ByVal destConnection As SqlConnection)        ' old method: Lots of INSERT statements         ' first, create the insert command that we will call over and over:         destConnection.Open()        Using ins As New SqlCommand("INSERT INTO [tblAppointmentDisposition] ([contactdate], [dnbnumber], [prospectname], [businessofficer], [phonemeeting], [followupcalldate2], [phonemeetingappt], [followupcalldate3], [appointmentdate], [appointmentlocation], [appointmentkept], [applicationgenerated], [applicationgenerated2], [applicationgenerated3], [comments], [newaccount], [futureopportunity]) VALUES (@contactdate, @dnbnumber, @prospectname, @businessofficer, @phonemeeting, @followupcalldate2, @phonemeetingappt, @followupcalldate3, @appointmentdate, @appointmentlocation, @appointmentkept, @applicationgenerated, @applicationgenerated2, @applicationgenerated3, @comments, @newaccount, @futureopportunity)", destConnection)            ins.CommandType = CommandType.Text            ins.Parameters.Add("@contactdate", SqlDbType.Text)            ins.Parameters.Add("@dnbnumber", SqlDbType.Text)            ins.Parameters.Add("@prospectname", SqlDbType.Text)            ins.Parameters.Add("@businessofficer", SqlDbType.NVarChar)            ins.Parameters.Add("@phonemeeting", SqlDbType.Text)            ins.Parameters.Add("@followupcalldate2", SqlDbType.Text)            ins.Parameters.Add("@phonemeetingappt", SqlDbType.Text)            ins.Parameters.Add("@followupcalldate3", SqlDbType.Text)            ins.Parameters.Add("@appointmentdate", SqlDbType.Text)            ins.Parameters.Add("@appointmentlocation", SqlDbType.Text)            ins.Parameters.Add("@appointmentkept", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated2", SqlDbType.Text)            ins.Parameters.Add("@applicationgenerated3", SqlDbType.Text)            ins.Parameters.Add("@comments", SqlDbType.Text)            ins.Parameters.Add("@newaccount", SqlDbType.Text)            ins.Parameters.Add("@futureopportunity", SqlDbType.Text)            ' and now, do the work:             For Each r As DataRow In sourceTable.Rows                If sourceTable.Rows.IndexOf(sourceTable.Rows(0)) Then                    'do nothing                Else                    For i As Integer = 0 To 16                        ins.Parameters(i).Value = r(i)                    Next                    ins.ExecuteNonQuery()                    'If System.Threading.Interlocked.Increment(rowscopied) Mod 10000 = 0 Then                    'Console.WriteLine("-- copied {0} rows.", rowscopied)                    'End If                End If            Next        End Using        destConnection.Close()    End Sub 

View 5 Replies View Related

Skip Or Ignore Where Clause In SP

Sep 20, 2013

I am looking for best practice when passing a parameter to stored procedure that is not needed. For example, sometime the users will want the list to list only by certain state. Other times the user want all states. How can I make the SP to ignore the where clause if users want all states.

CREATE PROCEDURE usp_Example
@State nvarchar(2)
AS
SELECT FirstName,
LastName,
State
FROM SomeTable
WHERE State = @FirstName;
GO

View 1 Replies View Related

BCP Utility - Skip Rows..

Jul 23, 2005

Hello All,Does the BCP utility enable you to selectively import rows from a flatfile to a table ?For example:The first column in my flat file contains a record type - 1, 2..7I only need to import types 1, 2, & 3Can this be specified in the .fmt file ?Thanks in advancehharry

View 4 Replies View Related

How Can I Skip An Initialize Snapshot?

Jun 2, 2006

Hence you have a database which huge tables and a transactional replication (push subscriptions).

Now my question:

1. if I have to initialize a snapshot but I would like to do it without the snapshot agent, what methods are available?



2. Usually the distribution agent will request an initialize snapshot. How can I tell him, that I would like to use an alternative method and that the distribution agent should NOT request a snapshot?



3. Any suggestions about a good practive for materializing huge and big tables wihtout using the disitrbution agent (e.g. "switch off" replication, bcp table out of the primary site and bcp it into the target site, "start" distribution agent so that it doesn't request a snapshot).



Regards

Nobsay

View 6 Replies View Related

Skip Rows In Excel

May 15, 2007

Hi,

How to skip my 12 header rows from XLS input source?

(before the Excel driver reads (by default, 8 rows) in the specified source to guess at the data type of each column.)

thx,

f.sor

View 3 Replies View Related

Skip A Row In The Flatfile Source

May 20, 2008

I am importing a flatfile and cannot seem to deal with an issue that seems quite simple.

The files have a header row with column names and those rows start with '#'

However sometimes this header row will also be present in the middle of the file.

The Source tries to parse this row and fails

Is there any way to tell the flafile source to skip rows that start with a particular character like comment rows?

View 5 Replies View Related

How To Skip The First Row In An Excel Workbook

Jul 24, 2007



Hi All,

I have a excel workbook with many sheets, in each sheet the first row has to be skipped and the second row contains the column information and thereafter are the records.



The Excel Source in SSIS just gives an option: check if the first row has column names.

But the first row for me is junk -- a link to parent or first sheet-- and has to be skipped and the second row has the column info.



How can this be accomplished .... any suggestions would be of great help!!!



Sample:






Main








id

desc

price

date


1

apple

1.0

1/1/1900


2

banana

2.0

1/1/2000



Main in the first row is actually a hyperlink ... once we click this it takes us to the first sheet in the workbook which has all sheet names as contents.



I am stuck and not sure how to skip this!!

View 5 Replies View Related

Footer Rows To Skip

Feb 7, 2006

OK. We know there is Header rows to skip options and it works great.

I've got the file that has a "footer". Here is an example:

.
PSC
filename=table1
records=0000000000525
ldbname=db1
timestamp=2006/02/07-16:25:00
numformat=44,46
dateformat=mdy-1910
map=NO-MAP
cpstream=ISO8859-1
.
0000260611


It's ALWAYS last 12 rows.

Is there a way to split at this point and put the 12 rows in a different location? The task is twofold - I don't need these control rows in my data and I need value of "records" to verify loaded number of rows.

UPDATED: After some testing I found out that the Flat File source does not see that footer at all. This is good and bad - I do want to load this metedat into some other tables.

Dima.

 

View 7 Replies View Related

Use GOTO To Skip Part Of A Script?

Nov 11, 1998

I have a script that creates and populates several tables. However I only want this to occur if one table has a row count greater than zero. I'm trying to use GOTO to script to the end of the script. However I get the message "A GOTO statment references the label 'MYLABEL' but the label has not been declared." How can I do this.


I have something similiar to the following in my script:
IF (SELECT COUNT(*) FROM MYTABLE) = 0
BEGIN
PRINT 'NO ROWS FOUND'
GOTO MYLABEL
END

CREATE TABLE X...

SELECT INTO X FROM Y ...

ETC. ETC.

MYLABEL:
PRINT 'END SCRIPT'

View 2 Replies View Related

SQL 2012 :: Bulk Insert - How To Skip First Row

Oct 31, 2014

I used code below to do bulk insert. Since csv file first row is column name. How to skip first row?

BULK
INSERT TEST
FROM 'c: est.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)
GO

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved