How to update the values in VC++? - Database Discussion Boards

Re: Default values in microsoft Sql Server

Neophyte3022-Apr-08 23:22

Neophyte30

22-Apr-08 23:22

Thanks - perfect for what I need!

Big Grin | :-D

Re: Default values in microsoft Sql Server

sonia.sardana23-Apr-08 23:38

sonia.sardana

23-Apr-08 23:38

use sonia
create table stud(roll int identity(10,2),name varchar)
insert into stud values('A')
insert into stud values('B')
select * from stud

**IDENTITY(10,2) --> 10 is the initial value
2 is the number by which the value is to be incremented.
U can also decrement the value.

SQL EXPRESS REPLICATION

briogene22-Apr-08 3:19

briogene

22-Apr-08 3:19

Hallo

We have set up Replication in several locations the SQL Server Enterprise Edition which is the Publisher is running on a different location while the Subscribers are running SQL express Edition which use Windows Synchronization as it does not have agents. The problem is users entering Passwords each and every time the Synchronization starts is there a way to enter the database only once and save it to the client Computers?

change date from mm/dd/yyyy to ddmmmyy

tlisom22-Apr-08 2:23

tlisom

22-Apr-08 2:23

I'm using SQL server 7. Unfortunetly, the database I'm working with was not designed very well to restrict the date format input by the user. I need to change a table's column [IncidentDate] from a format of mm/dd/yyyy (12/25/2008) to a format of ddmmmyy (25DEC08). There are over 3,000 entries within this column that have a mixture of these two formats. I'm not sure exactly how I would accomplish this task. I tried using SQL Server Enterprise Manager's export/import tool to place the data into an Excel spreadsheet, manipulate the dates, and then import back into the database. I come close to resolving my issue, but I always get an error in the import function.

Any help is appreciated.

Re: change date from mm/dd/yyyy to ddmmmyy

Blue_Boy22-Apr-08 2:32

Blue_Boy

22-Apr-08 2:32

make while loop in TSQL, and format is this SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]br mode="hold" />

>

I Love T-SQL

Re: change date from mm/dd/yyyy to ddmmmyy

tlisom22-Apr-08 3:08

tlisom

22-Apr-08 3:08

Thank you. I'll give this a shot and let you know how it worked out.

Re: change date from mm/dd/yyyy to ddmmmyy

Blue_Boy22-Apr-08 3:54

Blue_Boy

22-Apr-08 3:54

If it won't work then ask again.

I Love T-SQL

How to update the values in VC++?

savitri21-Apr-08 23:31

savitri

21-Apr-08 23:31

Hi EveryOne,
I am savitri here.I am using ODBC in VC++ programs.I am Inserting values in the tables.If i want to Edit/Update Those values how Can I do it.if i clicked on the values those are come on the text boxes in that i want to edit after clicking button those values should be updated.Please tell me How can i Do it.
I am not getting idea how to get back the values on text boxes.
PLEASE HELP ME.

THANKS IN ADVANCE,
savitri Confused | :confused:

Re: How to update the values in VC++?

Blue_Boy22-Apr-08 0:12

Blue_Boy

22-Apr-08 0:12

the way how u execute Insert command then do it with update same thing. or share your insert code and probably we can find how to execute update command.

I Love T-SQL

SELECT column FROM table WHERE time = @time ISSUE

Harvey Saayman21-Apr-08 23:11

Harvey Saayman

21-Apr-08 23:11

Hey guys

im having a slight problem with the above query, the problem is the value in the variable is like this "23:00" and the value in the table is "01-01-2008 23:00:00.000"

how can i get the query to return the row i need irrespective of the date that is attached to the time?

thanx,

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS

you.suck = (you.passion != Programming)

Re: SELECT column FROM table WHERE time = @time ISSUE

Blue_Boy21-Apr-08 23:50

Blue_Boy

21-Apr-08 23:50

select convert(varchar(10),columnname,108) from myTable it will return this format HH:mm:ss

hope it helps to you...

I Love T-SQL

Re: SELECT column FROM table WHERE time = @time ISSUE

Harvey Saayman21-Apr-08 23:57

Harvey Saayman

21-Apr-08 23:57

thanx dude, im sure it will work!

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS

you.suck = (you.passion != Programming)

Re: SELECT column FROM table WHERE time = @time ISSUE

Blue_Boy21-Apr-08 23:59

Blue_Boy

21-Apr-08 23:59

I guess it will work for you Wink | ;)

I Love T-SQL

Re: SELECT column FROM table WHERE time = @time ISSUE

Sivu21-Apr-08 23:58

Sivu

21-Apr-08 23:58

Oh, that's handy! i didn't know there was such easy conversion! Big Grin | :-D

Re: SELECT column FROM table WHERE time = @time ISSUE [modified]

Blue_Boy22-Apr-08 0:01

Blue_Boy

22-Apr-08 0:01

108 is returned format of datetime, also we have another formats like 100,101,102 and so on

If you wanna check this syntax in T-SQL by changing format number

select convert(varchar,getdate(),108)

I Love T-SQL

modified on Tuesday, April 22, 2008 6:09 AM

Re: SELECT column FROM table WHERE time = @time ISSUE

Colin Angus Mackay22-Apr-08 23:46

Colin Angus Mackay

22-Apr-08 23:46

Blue_Boy wrote:
108 is returned format of datetime, also we have another formats like 100,101,102 and so on

Which means what? What does format "101" actually mean? Without further explanation your statement is meaningless. Technically correct, but meaningless all the same.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Introduction to LINQ to XML (Part 1) - (Part 2)

My website | Blog

Re: SELECT column FROM table WHERE time = @time ISSUE

Blue_Boy23-Apr-08 6:28

Blue_Boy

23-Apr-08 6:28

for more-meaning use google search engine Wink | ;)

I Love T-SQL

Re: SELECT column FROM table WHERE time = @time ISSUE

sonia.sardana23-Apr-08 23:43

sonia.sardana

23-Apr-08 23:43

hey frnd can u tell me what is 108 in the foll Query
select convert(varchar(10),columnname,108) from myTable

Re: SELECT column FROM table WHERE time = @time ISSUE

Sivu21-Apr-08 23:53

Sivu

21-Apr-08 23:53

Hey man,

You can use DATEPART to get the different parts of the date.

<br />
select right('0' + convert(varchar, datepart(hh, time)), 2) + ':' + <br />
       right('0' + convert(varchar, datepart(mi, time)), 2) + ':' + <br />
       right('0' + convert(varchar, datepart(ss, time)), 2)<br />

With the date you've given as an example, this would return the string "23:00:00".

Hope this helps...

Problem with timeout in accessing Excel file

Rocky#21-Apr-08 23:06

Rocky#

21-Apr-08 23:06

hi everyone,
I'm working on importing records from an excel file, the problem is that I'm trying to specify a time out of about 2 minutes but it still expires on 1 minute.

Here's the string that I'm using in my app.config file.

Can anyone plz help me in this regard

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=D:\Projects\BulkCopy\BulkCopy\BulkCopy\bin\Debug\test1.xls;connect timeout=120;

Rocky

Success is a ladder which you can't climb with your hands in your pockets.

Re: Problem with timeout in accessing Excel file

Blue_Boy22-Apr-08 0:20

Blue_Boy

22-Apr-08 0:20

connect timeout=120*2 will give you 2 minutes.
Try it

I Love T-SQL

Re: Problem with timeout in accessing Excel file

Rocky#22-Apr-08 0:28

Rocky#

22-Apr-08 0:28

Actually this time out was comming form the server where I was trying to bulk copy those records so right now I'm giving the time out in SQLBulkCopy object, a few moments ago it ended in failure with 500 as its value. now I'm raising it up to 3600Secs = 1hr

Hope that turns out ok

Rocky

Success is a ladder which you can't climb with your hands in your pockets.

Re: Problem with timeout in accessing Excel file

Michael Potter22-Apr-08 4:12

Michael Potter

22-Apr-08 4:12

Just so you know - The Connection Timeout only comes into play when acquiring a connection to the source. It has no bearing on processing which is defaulted to 30 seconds in ADO.Net. I guess the default is 1 minute in SQLBulkCopy. If you ever want to change the ADO.Net processing timeout, it is in the Command class under CommandTimeout.

Re: Problem with timeout in accessing Excel file

Rocky#22-Apr-08 4:17

Rocky#

22-Apr-08 4:17

yes I used Timeout property of SQLBulkCopy and it worked for me.

Thanks for ur reply Smile | :)

Rocky

Success is a ladder which you can't climb with your hands in your pockets.

SqlDumpExceptionHandler Error

Vimalsoft(Pty) Ltd21-Apr-08 22:18

Vimalsoft(Pty) Ltd

21-Apr-08 22:18

Good Morning All

i have the Following Query

---------------------------------------------------------
--Updating the Actual_Extent  with a Floor Area
update  Tshwane_Valuations_Train.sde.Property_Summary_Backup
set Actual_Extent = ip.Actual_Extent
from  Tshwane_Valuations_Train.sde.Property_Summary_Backup p 
inner Join  Returned_file_GEOSS ip on 
p.Property_ID  = ip.Property_ID
where ip.Property_ID = p.Property_ID
And Propery_ID in  
(
select Property_ID from Property_Summary
where Actual_Extent is null
And Func_key like 'GEOSS%'
And Archive_Date is Null
union all
select Property_ID from Property_Summary
where Actual_Extent in (0,1,2,3,4,5,6,7,8,9)
And Func_key like 'GEOSS%'
And Archive_Date is null
 )

This when i tryt to run the query , i get the Following Error

Msg 0, Level 19, State 0, Line 3
SqlDumpExceptionHandler: Process 149 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

What is Wrong,

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

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