Database Discussion Boards

SQL Server CURSOR

choorakkuttyil21-Sep-06 2:07

choorakkuttyil

21-Sep-06 2:07

how to declare,fetch,deallocate and manipulate using cursor in SQL SERVER Confused | :confused:

Re: SQL Server CURSOR

_AK_21-Sep-06 3:34

_AK_

21-Sep-06 3:34

choorakkuttyil wrote:
how to declare

DECLARE cursor_name CURSOR
[LOCAL | GLOBAL]
[FORWARD_ONLY | SCROLL]
[STATIC | KEYSET | DYNAMIC | FAST_FORWARD]
[READ_ONLY | SCROLL_LOCKS | OPTIMISTIC]
[TYPE_WARNING]
FOR select_statement
[FOR UPDATE [OF column_name [,...n]]]

opening a cursor:===

OPEN { { [GLOBAL] cursor_name } | cursor_variable_name}

choorakkuttyil wrote:
fetch

FETCH
[ [ NEXT | PRIOR | FIRST | LAST
| ABSOLUTE {n | @nvar}
| RELATIVE {n | @nvar}
]
FROM
]
{ { [GLOBAL] cursor_name } | @cursor_variable_name}
[INTO @variable_name[,...n] ]

choorakkuttyil wrote:
deallocate

DEALLOCATE { { [GLOBAL] cursor_name } | @cursor_variable_name}

Smile | :)

Best Regards,
Apurva Kaushal

Re: SQL Server CURSOR

Eric Dahlvang21-Sep-06 3:45

Eric Dahlvang

21-Sep-06 3:45

SQL Server Books Online:
Using Cursors[^]
Declare Cursor (T-SQL)[^]

Example:

CREATE PROCEDURE MyProcedure @cMyParameter varchar(100)
AS

DECLARE @cMyVar varchar(100)

DECLARE  mycursor CURSOR FOR 
SELECT MyField
FROM MyTable
WHERE MyOtherField = @cMyParameter

OPEN mycursor 
FETCH NEXT FROM mycursor INTO @cMyVar 
WHILE @@FETCH_STATUS = 0
BEGIN
	FETCH NEXT FROM mycursor INTO @cMyVar 
        --do some processing
END

CLOSE mycursor 
DEALLOCATE mycursor

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

SQL server 2005 express edition

NituC21-Sep-06 0:20

NituC

21-Sep-06 0:20

I want to use report services in SQL server 2005 express edition. Does it require IIS?

Thanks

Re: SQL server 2005 express edition

Dave Kreskowiak21-Sep-06 10:34

Dave Kreskowiak

21-Sep-06 10:34

I'm not sure about the Express Edition, but Reporting Services, in general, requires IIS, at least 5.0, and ASP.NET 2.0.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Access Database

V.20-Sep-06 23:48

20-Sep-06 23:48

Does anybody know what we need to read out an Access database?

Is MS Access really needed or can you install a provider only (or Access only without the rest of Office)? We need to show the data in our application only. (the users don't have to open the file itself) Currently the client provided the data in a mdb file, which occasionaly can be updated. Unfortunately this application has to be installed on several hundreds of workstations where Office is not installed.
The application is a html application embedded in our product. I use javascript to access the db.

Thanks a lot for your help...

I've found a living worth working for, but I haven't found work worth living for.

Moviereview Archive

<marquee> Beer | [beer]

Badger | [badger,badger,badger,badger...]

Re: Access Database

Rob Graham21-Sep-06 4:46

Rob Graham

21-Sep-06 4:46

V. wrote:
has

The MS access oledb provide (ADO0) is intalled with the system in in "program files\common files\system\ADO"
The Jet engine dllas are normally around in windows\system32
As a result, you should not have to intall anything if you are using ADO/ADO.Net to read from the file.
If these are old clients (win2k, ME, Win98 etc.) you may need to install ADO and possibly the jet engine stuff.
Redistributables can be found here[^]

Re: Access Database

V.21-Sep-06 4:57

21-Sep-06 4:57

Hey man,

thanks a lot, this is really helpfull !

I've found a living worth working for, but I haven't found work worth living for.

Moviereview Archive

<marquee> Beer | [beer]

Reset the Primary KEY

vengaqua20-Sep-06 22:14

vengaqua

20-Sep-06 22:14

i am having a database and i entered some data and deleted it also.Now the Primary Key starts from 4 or say any thing..i want it to start it from 1.And the primary key is auto incremented and not for replication.So how to do it.Please help me out.

Mohinder Singh

Re: Reset the Primary KEY

Colin Angus Mackay20-Sep-06 22:27

Colin Angus Mackay

20-Sep-06 22:27

DBCC CHECKIDENT[^]

DBCC CHECKIDENT('MyTable', RESEED, 0)

You need to be logged on as a user with at least one of the following roles: sysadmin, db_owner or db_dlladmin

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Reset the Primary KEY

Khawar Abbas120-Sep-06 23:59

Khawar Abbas1

20-Sep-06 23:59

Rename ur column[PK].
Add new column with the name of pk column.
Now delete the column u renamed.
Your problem will be solved.

Do good and have good.

Re: Reset the Primary KEY

Colin Angus Mackay21-Sep-06 0:50

Colin Angus Mackay

21-Sep-06 0:50

That is the craziest solution I've heard!

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Reset the Primary KEY

_AK_21-Sep-06 3:36

_AK_

21-Sep-06 3:36

Best Regards,
Apurva Kaushal

Re: Reset the Primary KEY

Farhan Noor Qureshi21-Sep-06 7:47

Farhan Noor Qureshi

21-Sep-06 7:47

You should read more of http://www.TheDailyWTF.com[^] Big Grin | :-D

Farhan Noor Qureshi

Re: Reset the Primary KEY

Dave Kreskowiak21-Sep-06 10:23

Dave Kreskowiak

21-Sep-06 10:23

No, it won't! You'll just create an empty column. The key ID's won't be regenerated for any existing rows.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Get hour from date

papa8020-Sep-06 20:51

papa80

20-Sep-06 20:51

Hi

How can i extract hour from datatime varable???

Good bye
Best Regards
N.Nikolov

when i want to read something good just seat and type it

Re: Get hour from date

vicky0000020-Sep-06 22:22

vicky00000

20-Sep-06 22:22

This is what i know you can use this code to extract hour from datetime variable

COleDateTime oOleDateTime(DateTimeVariable);
int iDay = oOleDateTime.GetDay();
int iMonth = oOleDateTime.GetMonth();
int iYear = oOleDateTime.GetYear();
int iHour = oOleDateTime.GetHour();
int iMinute = oOleDateTime.GetMinute();
int iSeconds = oOleDateTime.GetSecond();

Re: Get hour from date

papa8021-Sep-06 2:54

papa80

21-Sep-06 2:54

Thank's a lot

when i want to read something good just seat and type it

SQL Procedures help plz...

Aqueel20-Sep-06 18:21

Aqueel

20-Sep-06 18:21

Hi Can i get parameters from the user at run time in a SQL Procedure. I want to implement a SQL function just like i used to do in my C++ introductory classes. In the function, i want to ask user to enter name, age, class, and address etc one by one and then i would store this record using INSERT query. Can anyone plz help me?
Thank you

We Believe in Excellence
www.aqueelmirza.cjb.net

Re: SQL Procedures help plz...

Eric Dahlvang21-Sep-06 8:16

Eric Dahlvang

21-Sep-06 8:16

SQL Server is a database server, and has no "run time" user interface development tools. You need to write your interface in a programming language (C++,C#,ASP,etc.), then connect to SQL Server via some data connection method (ODBC,OLEDB,etc) and send your "INSERT query" to SQL Server.

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Saving hashtable to sqlexpress database...Is is possible

haomeister20-Sep-06 18:08

haomeister

20-Sep-06 18:08

It might be crazy, but i really wanna know if a hashtable (or any array of user defined type) can be save to database as a single object...and how?

any ideas? thanks~

Re: Saving hashtable to sqlexpress database...Is is possible

jigneshelegant120-Sep-06 20:20

jigneshelegant1

20-Sep-06 20:20

hi
yes
u can do by converting your hashtable to DataTable or DataSet

fsdfsdfd

Re: Saving hashtable to sqlexpress database...Is is possible

Scott Serl21-Sep-06 7:56

Scott Serl

21-Sep-06 7:56

Serialize to a byte array, then store in a varbinary field. When you read it back from the database, deserialize back into a hash table. This obviously only works with serializable objects. Also, if the implementation (of hashtable) is changed at some time, reading back a hashtable from the old serialized format will fail. Also, a varbinary can only hold 8000 bytes, and you need to use an image field if you will have more than 8000 bytes.

Scott

SQL Query help

picazo20-Sep-06 12:20

picazo

20-Sep-06 12:20

Hi,

I have tables:

Fruits:
FruitID | FruitName
====================
1       | Apple
2       | Orange
3       | Pear


Baskets:
Basket | FruitID | Amount
========================
Bask1  | 1       | 3
Bask2  | 1       | 5
Bask3  | 1       | 2
Bask1  | 1       | 1
Bask2  | 1       | 2
Bask1  | 3       | 2
Bask3  | 3       | 4

What query can I use to get the following table:

Basket | Apple | Orange| Pear
=============================
Bask1  | 3     | 1     | 2
Bask2  | 5     | 2     | NULL
Bask3  | 2     | NULL  | 4

Thanks in advance,

-----------------
Genaro

Re: SQL Query help

albCode20-Sep-06 20:48

albCode

20-Sep-06 20:48

select fruits.*,baskets.*<br />
from  fruits,baskets<br />
where  fruits.FruitID = Baskets.FruitID

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.