How To Implement Cursors In Sql

Feb 29, 2008

 hi friends.......
         I have one doubt.
                 how can we use cursor in sql. in oracle they implement cursors on stored procedure,
                  can we implement same concept in sql stored procedure...
regards
Samuel chandradoss . J
 

View 3 Replies


ADVERTISEMENT

How To Implement Alter Database Implement Restrictions On SQL2K ?

Dec 28, 2007

Hi Guyz

it is taken from SQL2K5 SP2 readme.txt. Anyone have idea what to do to implement this ?
Our sp2 is failing. we suspect the above problem and researching it.we are running on default instance of SQL2K5 on win2003 ent sp2

"When you apply SP2, Setup upgrades system databases. If you have implemented restrictions on the ALTER DATABASE syntax, this upgrade may fail. Restrictions to ALTER DATABASE may include the following:

Explicitly denying the ALTER DATABASE statement.


A data definition language (DDL) trigger on ALTER DATABASE that rolls back the transaction containing the ALTER DATABASE statement.


If you have restrictions on ALTER DATABASE, and Setup fails to upgrade system databases to SP2, you must disable these restrictions and then re-run Setup."

thanks in advance.

View 4 Replies View Related

How To Implement?

Apr 12, 2005

Hi all,
I had many groups of data which column A store number & column B store location. My syntax as below :-
select count(columnA) as no, columnB from table group by columnB
No    columnB
20     A
10     B
5       C
How can I select 5 rows for Each ColumnB? (total 15 rows of record)
Thanks!

View 3 Replies View Related

Cannot Implement Mirroring

Apr 1, 2008

Hi,

I have place an question, but in some other place in the same forum.

My apologies for that



I wanted to implement mirroring
I hereby let u know the steps



1. Created a database in Principal server named Mirror1 and one table named tblMirror1.( no values inside the table)

2. Repeated the same in Mirror in Witness

3. Selected the Principal server's database -->right click-->tasks-->mirror

4. from the left hand panel selected Options -->recovery model-->full

5. selected Mirroring from left hand panel-->configure secuirty-->entered mirror and witness name--Success



6. When I click on start mirroring I have an error stating

" Alter failed for database mirror1"

"Database mirroring cannot be enabled because Mirror1 database may have bulk logged changes that have not been backed up etc...."




7. followed this one
BACKUP database mirror1 TO DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'

got the answer as

Processed 160 pages for database 'mirror1', file 'Mirror1' on file 2.
Processed 1 pages for database 'mirror1', file 'Mirror1_log' on file 2.
BACKUP DATABASE successfully processed 161 pages in 0.318 seconds (4.147 MB/sec).

According to sources
Run a restore of this backup on your mirror.
This can be done through the GUI or using a T-SQL command.

The database restore must use the NO RECOVERY option, so the database stays in a loading state.

Also the database name on the mirror must be the exact same name as the principal

RESTORE TestMirror FROM DISK='C:Backup TestMirror_FULL.BAK' WITH NORECOVERY



Hence did the below


RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

ERROR

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


HENCE MODIFIED AS

use master
go
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.



Please let me know what shuld i modify

regards
cmrhema

View 20 Replies View Related

Implement One Is To Zero Or Many Relationship

Sep 19, 2013

Just wondering if there was a way to implement a one is to zero or many relationship with sql or can you only have a one is to one or many?

View 2 Replies View Related

How To Implement This As A Function?

Jul 6, 2007

Hi all,

I've been using a piece of transact code to generate random strings of characters in a lot of scripts and I wanted to wrap it up all nice and neat into a function. I came up with the script below.

However, this fails with the following error..
quote:Invalid use of 'rand' within a function.
I've allready tried using dynamic sql and sp_executesql inside the function hoping that a new scope would let me use rand() but that isn't allowed either.

I'm Using sql server 2000. Any ideas?

Charlie.

-- snip ----

CREATE FUNCTION dbo.randstr (
@lengthINT)
RETURNS VARCHAR

AS BEGIN
DECLARE @outputVARCHAR(8000)
DECLARE @allowedVARCHAR(8000)

SET @allowed = '234679abcdefghjkmnpqrstuvwxyz234679ACDEFGHIJKLMNPQRTUVWXYZ'

SET NOCOUNT ON
DECLARE @charmapTABLE (charpos INT IDENTITY (1,1), symbol CHAR)
DECLARE @counterINT
DECLARE @characterINT
DECLARE @maplengthINT

SET @maplength = LEN(@allowed)
SET @character = 0
SET @output = ''

-- Insert the allowed characters into the character map table
SET @counter = 1
WHILE (@counter < @maplength + 1) BEGIN
INSERT INTO @charmap SELECT SUBSTRING(@allowed,@counter,1)
SET @counter = @counter + 1
END

-- Start the loop to generate @output
SET @counter = 1
WHILE (@counter < @length + 1) BEGIN

-- RAND() should output a floating point number between 0 and 1 however...
-- Sometimes the rand() function spits out a number greater than 1
-- or the multiplication results in 0
WHILE (@character < 1) OR (@character > @maplength) BEGIN
SET @character = CAST(@maplength * RAND()+1 AS INT)
END

-- Add the random character to @output
SET @output = @output + (SELECT symbol FROM @charmap WHERE charpos = @character)

-- Increment and Reset the @character variable
SET @counter = @counter + 1
SET @character = 0
END


RETURN @output
END

-- end snip ---

View 3 Replies View Related

How To Implement Replication

Mar 26, 2008

Want to implement replication in sql server 2005

Kindly let me know how to do it.
Please


regards
cmrhema

View 2 Replies View Related

How To Implement This Scenario

May 11, 2006

Hi,

i hav a text file in this format..
currency,exchangerate(INR),date
dollar,45,20/04/2006
dollar,46,22/04/2006
britishpound,65,20/04/06
dirham,12,20/04/06..etc..

now,i want that using this as source.. 2 tables should be created and filled with appropriate data..
CurrencyMaster..Currencyid(PK),Currencyname
CurrencyDailyRate..ID,Currencyid(FK),rate,date

how can i do it using SSIS?
thks

View 1 Replies View Related

How To Implement This In SSIS

May 22, 2006

Greetings SQL friends!

I have the following transact SQL code which I want to change to a set of SSIS components.



SELECT blah, blah

FROM PSTAGE..[stage_OFFER_PRICE_DIVIDEND] AS SOPD
LEFT OUTER JOIN PSTAGE..[stage_PRICE_GRP] AS SPG
ON SOPD.PRICE_GRP_ID = SPG.PRICE_GRP_ID
LEFT OUTER JOIN PSTAGE..[stage_type] AS TYP
ON TYP.TYPE_CD=SPG.PRICE_TYPE_TYPE4_CD
and TYP.TYPE_CL_CD = '0017'



I know I can join two data sets using a merge join (left join) but how do I combine a third merge join? Should I be doing this or should I just stick my code in a SQL Task instead?



Your help would be appreciated.

View 1 Replies View Related

How Do I Implement If Then Else Conditions

May 28, 2007

Hi All,



I'm very new to Integration Services. Self Learned this ETL tool based on my prior ETL tool knowledge.



Can you tell me how do write IF Then Else conditions for every column in my source and redirect to a single output?





Hey correction here ... i'm using flat file as my source





Thanks in Advance,

Suresh N

View 7 Replies View Related

How To Implement Paging

Oct 27, 2006

My report is taking long time to display hundered of records.So we want to display 15 records per page and Next page link at the end of report.Please help me how to do this.

View 7 Replies View Related

How To Implement Search Function

Feb 1, 2007

I have a table search the record. The user can search by name, id, status, address and other information.I want to make the search function more robust. For example, when the database has a record with name = "Michael Jackson", either typing any subset of the name will show this record.I would like to know if there is any easy way to implement this with VS2005 and SQL2005 Express.Thank you 

View 3 Replies View Related

How To Implement A DropDownList W/o A Table

Jun 9, 2007

I am using Visual Studio 2005 & SQL Server. How do i implement a DDL for users to select which value to input. like i can with Access. i do not need a table i think. if not the table would have only ID & Value.?

View 2 Replies View Related

Implement Provider Model

Nov 27, 2007

Hi All,
Can i implement provider model to my business logic?
 

View 3 Replies View Related

Object Must Implement IConvertible

Feb 8, 2006

using (SqlConnection oConn = new SqlConnection(sConnection))
           
    using (SqlCommand oCommand =
this.CreateSqlCommand("rcsp_employee_f_changerole.xml", oConn))
                {
                    try { oConn.Open(); }
                    catch(Exception ex)
                    {
           
            p_nErrorCode =
10;
           
           
p_sErrorMessage = "Error opening database connection  during
RCEmployee.DBUpdate: " + ex.Message;
                        goto Failed;
                    }
               
                   
           
       
oCommand.Parameters["@employeeid"].Value = p_gID;
           
       
oCommand.Parameters["@authorityid"].Value = p_gAuthorityID;
           
       
oCommand.Parameters["@role"].Value=sNewRole;
           
        if (!ProcessNonQuery(oCommand,
sMethodName)) goto Failed;

                Failed:
           
        if (ErrorCode > 0) bReturn =
false;

                    oConn.Close();
                }
            }
            return bReturn;


p_gID, p_gAuthorityID  is of type guid.
sNewRole is of type string.
I get the error " Object must implement IConvertible at
oCommand.ExecuteNonQuery();  whihch is in the function    if (!ProcessNonQuery(oCommand, sMethodName))

View 1 Replies View Related

How To Implement This Kind Of Sorting?

Jul 15, 2004

Here's a basic overview of my Table

ID identity int
ParentID int
Name varchar

Now, the root level items will have a ParentID of NULL, and the child nodes will have it's parent's ID in it's ParentID column (a simple self-referencing relationship).

However, when I select it, I would like to Order by ID, but then have all it's children right after it. For example, if this is the unsorted view:

Code:


ID ParentID Name
----------------------
1 <NULL> Test
2 1 Test Child 1
3 <NULL> Test 2
4 1 Test Child 2
5 3 Test 2 Child 1


I would like the sorted to look like:

Code:


ID ParentID Name
----------------------
1 <NULL> Test
2 1 Test Child 1
4 1 Test Child 2
3 <NULL> Test 2
5 3 Test 2 Child 1


Is this possible with my current structure? If not, how could I change it?

View 4 Replies View Related

To Implement Commit / Rollback

Apr 14, 2008

hi friends,

Iam Executing the sp logic.suppose incase if any problem occurs inbetween execution(NO SPACE,communication failure,log full)
data is getting commited partially insteady of rollbacking entire transaction.

CREATE procedure RBI_Control_sp
as
begin

set nocount on
--Checking the count before truncating
exec fin_ods..count_sp

--Truncating the Table
exec fin_ods..trun_sp

--Data Transfer
exec fin_ods..RBI_Data_Transfer_sp

--Checking the count after Data transfer
exec fin_ods..count_sp

--temp table Table population,Fetching data from the fin_ods[erp Table]
exec FIN_wh..RBI_SPExecution_sp

set nocount off
end

View 3 Replies View Related

Cleaner Way To Implement This Design?

Apr 15, 2006

Hi all, I was hoping I could get some ideas about how to implement a share portfolio. Right now I've got a transaction table that lists the name of the share, quantity, amount and a few other details of every transaction I make. I think I'll be better off breaking it up into two tables; sales and purchases.

I want to create a portfolio using this data. I figured that I could set a query to show one column with names of all the shares (selected from the share purchase table) and another column to work out the current number of shares I hold. Thing is, I can't seem to work out a formula that will pick up all purchases of a certain share, then subtract of sales of the same and then place it in the column for that share in the portfolio.

There's probably a much cleaner way to do it that I'm completely missing. Any ideas? Perhaps edit the input form for the transaction table(s) so that it notes the name of the share and creates a new record if the share isn't already in the portfolio or adjusts it if it is.

And yes, I'm using Access.

Thanks
-N

View 12 Replies View Related

Object Must Implement IConvertible....

Oct 16, 2006

Using: VB.Net 2003, SQL Server 2000 and nText Column...

Examples: "Writing BLOB Values to a Database [Visual Basic]" and "Conserving Resources When Writing BLOB Values to SQL Server [Visual Basic]"

I modified the following code from the samples that were available in Help and MSDN. When my application reaches the ExecuteNonQuery statement it informs me that the Byte Array oDocument must implement IConvertible. I have even tried the extended version which uses a SQL Insert followed by UPDATETEXT with Pointers, and I get the same result with the Byte Array used in that example. My goal is to have Users Append certain documents to Proposals within my database, as I understand that is what I would be doing anyway if I used SharePoint.

Following the examples I have not trouble whatsoever reading an Image File from SQL Server 2000, and therefore I expect no trouble with nText Fields. I just cannot seem to insert Documents or Images via VB Code.

What is wrong with the examples that I cannot use the same code?

---- VB Code Follows ----

Private Sub btnSelectFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSelectFile.Click

Dim oSQLConnection As System.Data.SqlClient.SqlConnection

Dim oSQLCommand As System.Data.SqlClient.SqlCommand

Dim oSQLDataReader As System.Data.SqlClient.SqlDataReader

Dim oDocument() As Byte

Try

'Define the Initial Directory to be the "My Documents" Directory.

ofdAttachment.InitialDirectory = "My Documents"

'Filter for File of Word, PDF, and Text. This will suffice for now.

ofdAttachment.Filter = "Word Documents (*.doc)|*.doc|PDFs (*.pdf)|*.pdf|Text Files (*.txt)|*.txt"

'Show the Dialog to Open a File.

ofdAttachment.ShowDialog()

'If the User Selected a File then attempt to Add the Attachment.

If ofdAttachment.FileName <> String.Empty Then

'Read the Document into a Byte Array.

oDocument = GetDocumentInBytes(ofdAttachment.FileName)

'Define the Connection to the SQL Database.

oSQLConnection = New System.Data.SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=SSPI;database=proposal_tracking;server=dbserverdbserver;")

'Attempt to Open the SQL Connection.

oSQLConnection.Open()

'Create a New SQL Command Object.

oSQLCommand = New System.Data.SqlClient.SqlCommand

'Assign the SQL Connection information to the SQL Command Object.

oSQLCommand.Connection = oSQLConnection

'Define the SQL Statement to Attach the Document.

oSQLCommand.CommandText = "INSERT INTO Documents (DocumentName, Document) VALUES (@DocumentName, @Document)"

oSQLCommand.CommandType = CommandType.Text

'Define the Parameters of the SQL Statement.

oSQLCommand.Parameters.Add("@DocumentName", SqlDbType.VarChar).Value = Mid(ofdAttachment.FileName, ofdAttachment.FileName.LastIndexOf("") + 2)

oSQLCommand.Parameters.Add("@Document", SqlDbType.NText, oDocument.Length).Value = oDocument

'Execut the SQL Statement. Resulting in an Error that states:

'Object must implement IConvertible.

oSQLCommand.ExecuteNonQuery()

If Not oSQLCommand Is Nothing Then

oSQLCommand.Dispose()

oSQLCommand = Nothing

End If

If Not oSQLConnection Is Nothing Then

oSQLConnection.Close()

oSQLConnection = Nothing

End If

End If

Catch sqlex As System.Data.SqlClient.SqlException

MsgBox(sqlex.Message)

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

Public Shared Function GetDocumentInBytes(ByVal strFilePath As String) As Byte()

Dim ofsDocumentReader As System.IO.FileStream = New System.IO.FileStream(strFilePath, System.IO.FileMode.Open, System.IO.FileAccess.Read)

Dim obrDocumentReader As System.IO.BinaryReader = New System.IO.BinaryReader(ofsDocumentReader)

Dim oDocument() As Byte

Try

oDocument = obrDocumentReader.ReadBytes(CInt(ofsDocumentReader.Length))

obrDocumentReader.Close()

ofsDocumentReader.Close()

Return oDocument

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Function

View 1 Replies View Related

Implement CLR Integration Against Filesystem

Oct 18, 2007

Dear All,

Is there any way to do things with filesystem in SQL 2005 ? I want to check a file and if exists I could replace data into it or create the file if not exists. I tried build a DLL file using C# to do those things and registered it in SQL 2005
but when I execute the procedure it returns an error like this below :

Msg 6522, Level 16, State 1, Procedure testfsq, Line 0A .NET Framework error occurred during execution of user-defined routine or aggregate "testfsq": System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.System.Security.SecurityException: at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.IO.FileInfo..ctor(String fileName) at FSQuery.fsq()

So, is that means that we can't use another namespace in .NET framework but Microsoft.SQLServer.Server ? thanks in advance.

Best regards,

Hery

View 2 Replies View Related

How To Implement The Sql Server Mirroring?

Aug 28, 2006

i have two computers with Sql server 2000 std edition(SP4) and windows 2003 std edition(SP1).

how should i do to balance the loading of sql server and sync these two servers?

The sql server mirroring means that if one server is down, then the other one will replace it?





View 4 Replies View Related

Self-Indexing Keys - How Do I Implement?

Feb 8, 2008

Hello All,

I am totally new to MS SQL and need some help. Finding the so called "help" not very helpful, surprisingly Google not turning up much either, maybe not doing using the right search criteria?

I am using MS SQL Server Express 2005.

What I want to do is when a user adds a grower to the GrowerList (via an ASP.NET page) it is done so that the GrowerID increments automatically to the next unique number (currently set GrowerID as primary key, type int).

This is how the table looks so far:






GrowerID

GrowerName

1

Agrico

2

AOAL

3

Bannerton Park

4

Max Frender

5

OFM

6

Timber Corp

7

Wayne Overall

8

Wayne/ AOAL


Anyone know how to do this?

Thank you.

View 6 Replies View Related

How To Implement Encryption Into Database

Jun 4, 2015

I'm currently learning how to implement Encryption into my SQL database, and I've run into something I don't know how to explain or understand. I'm working on creating a set encryption for a set of columns in a database, and I don't know how to figure out what size the VARBINARY column needs to be. After some trial and error, I've noticed that a clear text of 9 characters needs 68 varbinary characters, 100 cleartext=148 varbinary, and 254 cleartext= 308 varbinary characters. How is the minimum number of varbinary characters calculated? 

View 2 Replies View Related

How To Implement Split And Merge?

Jan 9, 2006

I need to implement following flow:

[Source] - > [Split]

-  [IF TRUE] -> [DO SOMETHING] - [OUTPUT TO C]

-  [IF FALSE] -> [DO SOMETHING ELSE] - [OUTPUT TO C]

The issue is to come back to the same destination after conditional split.

In other words, is there something opposite to "Multicast"?

I looked at Union and Merge - but it looks like it's not for this kind of things.

Thanks.

View 5 Replies View Related

Some 'best Practice' On How To Implement SSIS

Dec 13, 2006

Hi,

We are planning for a DW solution based upon SQL Server 2005 EE. We will use a 64 bit machine for the Database engine and Analysis Services. Should we have seperate server for SSIS or should we use the same 64 bit box? If we go for a sepaerate server for SSIS should we use 32 bit or 64 bit ?

The primary datasources will be a new developed .NET application and a financial system based upon SQL Server 2000.

Every good advice/experiance is greatly appriciated!

Larra

View 1 Replies View Related

Any Ideas To Implement This In SSIS?

Feb 26, 2008



Hi,

I need some help regarding SSIS.

I have a table containing a list of source table names to be transferred to destination.I need to pass each and every table name as a variable and based on the name of the variable I need to select data from source and insert into destination.The source and destinations are on 2 different servers.The source tables have different metadata (different column names and data types).Any help how to implement this would be greatly appreciated.


To be more clear I have List table which has below format

TABLE NAME
CUSTOMER
PRODUCT
INVENTORY

Customer , product, inventory are tables names. So my package should first go and collect the table name from LIST table and then transfer the Customer table data from Server A to Server B. This should be repeat untill all the tables listed in LIST table are transferred.

View 3 Replies View Related

Object Must Implement IConvertible Is A BUG Non Solved?

Aug 9, 2006

 
 
i try to do a simple insert using SQLDataSource and a Stored Procedure
I try all night and always have this error
 
Object Must Implement IConvertible
 
I can’t understand where I wrong..
 
Looking around I understand is maybe a typecasting problema but I not find nothing more understeable..
Could someone tell me why Microsoft release this SQLdatasorce making more difficult a simple insert?
If someone could help me to fix this problem please
 
Here is the code
------------------------------------------------------------------------------------------------------------
 
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
 
 
        Try
            SqlDataSource1.Insert()
 
        Catch ex As Exception
            Response.Write(ex.ToString)
        Finally
            SqlDataSource1.Dispose()
 
 
        End Try
 
End Sub
------------------------------------------------------------------------------------------------------------
 
     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CommerceTemplate %>"
            InsertCommandType="StoredProcedure" InsertCommand="dbo.StoredProcedure1">
            <InsertParameters>
                <asp:ControlParameter ControlID="DropDownListCategory" Name="@CategoryID" PropertyName="SelectedValue"
                    Type="Int32" />
                <asp:ControlParameter ControlID="DropDownListCategory" Name="@ModelNumber" PropertyName="SelectedValue"
                    Type="String" />
                <asp:ControlParameter ControlID="txtModelName" Name="@ModelName" PropertyName="Text"
                    Type="String" />
                <asp:ControlParameter ControlID="txtProductImage" Name="@ProductImage" PropertyName="Text"
                    Type="String" />
                <asp:ControlParameter ControlID="txtUnitCost" Name="@UnitCost" PropertyName="Text"
                    Type="Decimal" />
                <asp:ControlParameter ControlID="txtDescription" Name="@Description" PropertyName="Text"
                    Type="String" />
                <asp:ControlParameter ControlID="txtWeight" Name="@Weight" PropertyName="Text" Type="Decimal" />
                <asp:ControlParameter ControlID="txtDiscount" Name="@Discount" PropertyName="Text"
                    Type="Decimal" />
                <asp:ControlParameter ControlID="chkIsActive" Name="@isActive" PropertyName="Checked"
                    Type="Boolean" />
                <asp:ControlParameter ControlID="DropDownListAuthors" Name="@IDAuthor" PropertyName="SelectedItem"
                    Type="Int32" />
            </InsertParameters>
        </asp:SqlDataSource>
------------------------------------------------------------------------------------------------------------
 
 
ALTER PROCEDURE dbo.StoredProcedure1
 
      @CategoryID int,
      @ModelNumber nvarchar(50),
      @ModelName nvarchar(50),
      @ProductImage nvarchar(50),
      @UnitCost money,
      @Description varchar(500),
      @weight money,
      @IsActive bit,
      @DiscountPerCent int,
      @IDAuthor int
 
AS
 
INSERT INTO dbo.CMRC_Products (
 
      CategoryID,
      ModelNumber,
      ModelName,
      ProductImage,
      UnitCost,
      Description,
      weight,
      IsActive,
      DiscountPerCent,
      IDAuthor
)
 
VALUES (
 
      @CategoryID,
      @ModelNumber,
      @ModelName,
      @ProductImage,
      @UnitCost,
      @Description,
      @weight,
      @IsActive,
      @DiscountPerCent,
      @IDAuthor
)
 
SELECT @@IDENTITY as [NewID]
 ------------

View 4 Replies View Related

How Do I Implement Paging Please? - DataReader Object

Jan 4, 2007

Hi, I am a beginner in ASP.NET 2.0
I am creating a simple blog website. 
I am using a DataReader object to collect all of the entries in the database (in one full sweep) and then display them by adding rows to a table and populating them.
I would like to enable paging so that only 5 blog entries at a time are displayed. The user should be able to page backwards and forwards 5 at a time.
Please can somebody give me some ideas of how I should do this?
Should I read all of the data into some kind of list so that all of the data is then readily available? An arraylist or something?
I realise that the DataReader object reads in one continuous stream so I couldn't expect it to read backwards and forwards from the database.
 I include a portion of my code below which reads the database.
Many thanks.
        Dim objCommand As New SqlCommand        objCommand.Connection = objConnection        objConnection.Open()        objCommand.CommandText = "SELECT BlogID, Date, Blog FROM BlogSite2_Blogs ORDER BY Date DESC"
        Dim objReader As SqlDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
        Dim dateDateTime As Date        Dim strBlogEntry As String        Dim intBlogID As Integer
        Do While objReader.Read()            intBlogID = objReader.GetValue(0)            dateDateTime = objReader.GetDateTime(1)            strBlogEntry = objReader.GetString(2)
            CreateBlogRow(intBlogID, dateDateTime, strBlogEntry)        Loop
        objReader.Close()

View 3 Replies View Related

How To Implement Transaction Roll Back

Feb 28, 2008

Hello, I do not know how to implement transaction roll back in asp.net application. I am using SqlHelper class to communicate with my sql db.Thanks, junior 

View 1 Replies View Related

I Have 2 Options To Implement A Web Forum. Which One Is Better?? (SQL Related)

Apr 18, 2005

Hi everyone
 
 
I have 2 options to implement a  very simple web forum. Which one is better??…..
 
The first approach is as the following:
-create a Posts table which will contain all posts.
- create a replies table which will contain all replies.
- The relation between Posts table and replies table is ONE to MANY
 
Advantages of this approach:
-         It follows the rules of normalization.
-         It avoids null values which will accrued if all replies and posts where stored in 1 table.
 
Disadvantages of this approach:
-         When it comes to implementing the search operation and data retrieve against posts table and replies table, I will need to run 2 different queries which means 2 connection to my SQL database. This means a slower execution and round trip to my SQL database.     
 
The second approach is as the following:
 
-         Create one table which will contain all posts and replies.
 
Advantages of this approach:
-         one query will be executed, which means faster execution than the first mentioned approach
-          it avoids round trip to my  SQL database which happens in the first mentioned approach
 
Disadvantages of this approach:
- It does NOT follows the rules of normalization.
- You will end up with null values (for example the post title field will be empty when inserting a reply.)
 
 
 
I would appreciate any comments or thoughts.  

View 4 Replies View Related

How To Implement Transactions In Sql Server 2000

May 11, 2005

hi,
i have developed an web-enabled database application using ASp.net, C# and sql server 2000.
now i want to implement transaction controls over the same
can anyone plz help me in implementing the same?
thanks in advance
 

View 4 Replies View Related

What &#34;Sort Order&#34; Did You Pick To Implement And Why?

Jun 26, 2000

Please identify the "Sort Order" you picked to implement?
Dictionary Order, Case Insensitive
Dictionary Order, Case In-sensitive
etc.

Why did you choose this "Sort Order"

Thanks!!

View 2 Replies View Related

How To Implement Transactional Replication Through Scripts

Sep 29, 2005

Hi All,
I am required to setup Transactional Replication between two database servers (SQL Server 2000) but am expected to do it through scripts and not through wizards.
So can anybody help me out on that front?

Thanks & Regards,
Rohit Saksena

View 1 Replies View Related







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