Database Discussion Boards

Re: Two same temp tables in two diffrent stored procedures

veereshIndia13-Jan-08 19:48

13-Jan-08 19:48

Hi,

You can use as many temp table you want.But after doing transaction you have to delete those temp table.

Regard's
Veeresh

i want to join this group

SQL database replacement

Maddie from Dartford8-Jan-08 23:04

Maddie from Dartford

8-Jan-08 23:04

Hello,
I have created database with name say XYZ in Microsoft SQL Server. My client uses same database, to avoid development phase reflection on database, i created exact replica of database and did the required modification. After finalising the changes i want that changes to be reflected in original database(XYZ).

Please tell me how can i replace existing databse with some other databse?
I tried usin script but table data is not getting copied.
I want to know how can i replace the exact copy of one database with another???

Thank you very much.

Re: SQL database replacement

pmarfleet9-Jan-08 0:02

pmarfleet

9-Jan-08 0:02

Restore the new copy of the database over the existing one.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: SQL database replacement

Mike Dimmick9-Jan-08 3:19

Mike Dimmick

9-Jan-08 3:19

We use the Red Gate utilities SQL Compare[^] and SQL Data Compare[^].

DoEvents: Generating unexpected recursion since 1991

Re: SQL database replacement

Mark Churchill9-Jan-08 21:34

Mark Churchill

9-Jan-08 21:34

Seconded. SQL Compare is very good.

Mark Churchill
Director
Dunn & Churchill
Diamond Binding: Zero to Data Layer in 3 mins

storing image in database

Pankaj Garg8-Jan-08 22:21

Pankaj Garg

8-Jan-08 22:21

CREATE PROCEDURE [dbo].[spa]
@a image
AS
insert into a(a) values(@a)
GO

table
column name = a
datatype = image

p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input);

The above code is right to insert the image in sql server 2000?

Re: storing image in database

Paul Conrad13-Jan-08 7:12

Paul Conrad

13-Jan-08 7:12

It looks okay. Does it work?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

how to install sqsh on Windows after cygwin installed?

devvvy8-Jan-08 20:48

devvvy

8-Jan-08 20:48

Hi
how to install sqsh[^] on Windows after cygwin installed? In fact where do you even download[^] binary for Windows?

Thanks!

devy

Oracle error

this is pumpkin8-Jan-08 10:17

this is pumpkin

8-Jan-08 10:17

Hello Everyone,
I am new to code project. Recently i had downloaded and installed oracle 9. but i could not be able to log on to sql plus. it displays the error "could not resolve service name"(error tns:12154). i went through several lot links online and tried to resolve. but none of them work. i had created the new port,checked the tnsnames.ora file, updated the necessary information from the net manager option. i am really worried about my problem. could anyone please help me regarding this. I appreciate your help.

Re: Oracle error

Paul Conrad13-Jan-08 7:12

Paul Conrad

13-Jan-08 7:12

You might want to look on the Oracle forums.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

quick newline question for a noob

likefood8-Jan-08 10:13

likefood

8-Jan-08 10:13

I'm starting out with database programming in C# (using System.Data.Odbc). I have an SQL command, using the UPDATE command. I'm trying to update a memo field (in an .mdb file) with contents that have multiple lines of text. However, I keep getting an error. I can see what the error is saying (that it doesn't like me starting a line without an SQL command). How do I modify the following example so that it will work?

UPDATE mytable
SET pagecontents = 'first line of text
second line of text
third line of text'
WHERE id = 3

The error basically says:
ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "second line of text
thirdline of text'

-Daniel
Typing too fast fro my owngood

Re: quick newline question for a noob

likefood8-Jan-08 15:53

likefood

8-Jan-08 15:53

Basically, I need to find out how to put multiple lines of text into a memo field. The text may or may not have apostrophes, quotes, backslashes, and other characters that usually require special treatment in other circumstances.

Anyone?

-Daniel
Typing too fast fro my owngood

Re: quick newline question for a noob

likefood8-Jan-08 18:09

likefood

8-Jan-08 18:09

Nevermind, I found it myself. I'm using an OdbcCommand object with an OdbcParameter.

-Daniel
Typing too fast fro my owngood

How to Create the Following Procedure

Vimalsoft(Pty) Ltd8-Jan-08 6:59

Vimalsoft(Pty) Ltd

8-Jan-08 6:59

Good Evening All

i want to Create a Procedure that will update the "locked" Field with "1" when it find some records that are null in a "Locked", based on a Parameter. Here is the Query that select records where Field "locked" is Null based on a parameter i have named "@lis_key".

SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key, Actual_Extent, 
Improved_Value, Site_Value, Purchase_price, Purchase_date, prop_id, 
confidence_score, fin_ls_prediction, new_lis_key, new_func_key,
 Tshwane_Prediction, matchflag, source, flagtype, 
Locked FROM Property_mass WHERE (SUBSTRING(Lis_Key, 1, 4) = @Lis_key) 
AND (Locked IS NULL)

i have tried the following but did not finish and not know which way to go, am still researching,

Create Procedure sp_Lock_Select
(
@Lis_key varchar(34) 
)
as 

SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key, Actual_Extent, 
Improved_Value, Site_Value, Purchase_price, Purchase_date, prop_id, 
confidence_score, fin_ls_prediction, new_lis_key, new_func_key,
 Tshwane_Prediction, matchflag, source, flagtype, 
Locked FROM Property_mass WHERE (SUBSTRING(Lis_Key, 1, 4) = @Lis_key) 
AND (Locked IS NULL)

Update Property_Mass
set Locked = 1
where (above selected Records)

PLease help

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: How to Create the Following Procedure

Vimalsoft(Pty) Ltd8-Jan-08 8:47

Vimalsoft(Pty) Ltd

8-Jan-08 8:47

hi All

while looking for Answers , i came across this and it seemed to work if i test the Procudure,

Create Procedure sp_Lock_Select
(
@Lis_key varchar(34) 
)
as 

if Exists(
SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key, Actual_Extent, 
Improved_Value, Site_Value, Purchase_price, Purchase_date, prop_id, 
confidence_score, fin_ls_prediction, new_lis_key, new_func_key,
 Tshwane_Prediction, matchflag, source, flagtype, 
Locked FROM Property_mass WHERE (SUBSTRING(Lis_Key, 1, 4) = @Lis_key) 
AND (Locked IS NULL)
)
Update Property_Mass
set Locked = 1
WHERE (SUBSTRING(Lis_Key, 1, 4) = @Lis_key And Locked IS NULL)

Am using the same searching Criteria of searching, because it will look for the same records that it had been found and update them.

Thanks

Re: How to Create the Following Procedure

Vimalsoft(Pty) Ltd8-Jan-08 9:28

Vimalsoft(Pty) Ltd

8-Jan-08 9:28

Hi All

Now Here is another Challenge, the above query is for select and lock the selected. now i have a challenge that is beyond my experience,because i used to depends on VS wizards to do it for me, now i have come out of the closet to code my way out. am trying to update a Datagrid from a Prodecure in vb.net, here is my Procedure and am open for advice.

create Procedure Update_And_UnLock
(
@Tshwane_Prediction float ,
@Primary_ID int
)
as 
Update Property_Mass 
set Tshwane_Prediction = @Tshwane_Prediction
where Primary_ID = @Primary_ID

Helps, how can i do that, i will keep on loking for answers while, am waiting for your advices.

Thanks

how to write a stored procedure that it holds multiple rows

jagan1238-Jan-08 2:31

jagan123

8-Jan-08 2:31

how a multiple row can be assigned to the out parameter of a stored procedure

Re: how to write a stored procedure that it holds multiple rows

pmarfleet8-Jan-08 2:40

pmarfleet

8-Jan-08 2:40

I don't think this is possible. However you could return a resultset from your stored procedure that contains the information.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

copy of sql server database

eyeseetee8-Jan-08 0:50

eyeseetee

8-Jan-08 0:50

Hi
does any1 know how to copy sql database.
I need to make another version of the database for test purposes

thanks

Re: copy of sql server database

Arjan Einbu8-Jan-08 2:29

Arjan Einbu

8-Jan-08 2:29

Take a backup and restore it to a new database...

You can do this form SQL Server Management Studio For MS SQL Server/MS SQL Server Express, from Enterprise Manager for MS SQL Server 2000 and 7.0.

From Query Analyzer, SQLCMD or other sql tools; lookup BACKUP (T-SQL) and RESTORE (T-SQL) in books online or Google.

Re: copy of sql server database

veereshIndia13-Jan-08 20:05

veereshIndia

13-Jan-08 20:05

Hi,

Open Sql Server 2000 Enterprise Manager Select Your DataBase Right Click on that there is an option Under All Tasks->BackUp DataBase->In Destination Path Give The Location Where u want to store that database back up.

After that Click Ok.

Then Restore this database backup where ever you want.

For that Just create one database Right Click on that Select
All Tasks->Select Restore Database,Select From Device It will ask the
location there u specify ur DataBase Backup Name Click Ok.

Regard's
Veeresh

i want to join this group

Re: copy of sql server database

veereshIndia13-Jan-08 20:30

veereshIndia

13-Jan-08 20:30

Hi,

Open Sql Server 2000 Enterprise Manager Select Your data base Right Click on that there is an option Under All Tasks->BackUp data base->In Destination Path Give The Location Where u want to store that database back up.

After that Click Ok.

Then Restore this database backup where ever you want.

For that Just create one database Right Click on that Select
All Tasks->Select Restore Database,Select From Device It will ask the
location there u specify ur DataBase Backup Name Click Ok.

Regard's
Veeresh

i want to join this group

SQL Profiler for Sybase?

devvvy7-Jan-08 23:29

devvvy

7-Jan-08 23:29