Re: Need help on how to update SQL query using VC++ - Database Discussion Boards

First Prev Next

Re: sql v/s ms access

sachees1234-Nov-09 23:20

sachees123

4-Nov-09 23:20

I dont want to change any format anywhere. Its the access which is changing the format from dd/mm/yyyy to mm/dd/yyyy. Why it is doing and wats the solution?? Thats my question.

Re: sql v/s ms access

Eddy Vluggen5-Nov-09 0:02

Eddy Vluggen

5-Nov-09 0:02

sachees123 wrote:
Its the access which is changing the format from dd/mm/yyyy to mm/dd/yyyy.

Databases don't store dates in a specific format, they store them as numbers[^]. The database applies one of the predefined dateformats when you retrieve the value. You can change[^] the table-design to change the default format that's used for the date-column though.

I are Troll Suspicious | :suss:

Two New Editions Join SQL Server 2008 R2 Roadmap

brucedkyle4-Nov-09 8:15

brucedkyle

4-Nov-09 8:15

Key announcements were made at PASS Summit 2009 about SQL Server:

Upcoming SQL Server 2008 R2 community technology preview (CTP) would be available in November.

SQL Azure is now feature-complete and goes live in January.

Two new editions of SQL Server to address high-end, mission-critical scenarios:

Microsoft SQL Server 2008 R2 Datacenter
Microsoft SQL Server 2008 R2 Parallel Data Warehouse (formerly project code-named “Madison”)

For more information, see Two New Editions Join SQL Server 2008 R2 Roadmap[^]

Learn more about Microsoft emerging techologies[^] on the Microsoft blog for independent software vendors (ISVs) in the United States.

Need help on how to update SQL query using VC++

John5023-Nov-09 18:55

John502

3-Nov-09 18:55

Hi,
I have one SQL query, i want to update it in one database. Please check that SQL query below.

update employee set emp_name = 'Ravi' where emp_id = 1

Now i want to get the count of how many rows get updated..

Can any one help me out as it urgent requirement for me..

Thanks
John.

Re: Need help on how to update SQL query using VC++

dan!sh 3-Nov-09 19:01

dan!sh

3-Nov-09 19:01

ExecuteNonQuery would do that if you are speaking of managed C++.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: Need help on how to update SQL query using VC++

Niladri_Biswas3-Nov-09 19:11

Niladri_Biswas

3-Nov-09 19:11

Try with OUTPUT command introduced with SQL SERVER 2005.
This link may help you

http://www.aspfree.com/c/a/MS-SQL-Server/Wonders-of-the-OUTPUT-Clause-in-SQL-Server-2005/[^]

http://www.databasejournal.com/features/mssql/article.php/3598636/OUTPUT-clause-in-SQL-Server-2005.htm[^]
Smile | :)

Niladri Biswas

Re: Need help on how to update SQL query using VC++

Mycroft Holmes3-Nov-09 19:31

Mycroft Holmes

3-Nov-09 19:31

I always use stored procs but this may work.

update employee set emp_name = 'Ravi' where emp_id = 1; Select @@Rowcount Updated

Not sure if it requires a colon or a semi colon.

Re: Need help on how to update SQL query using VC++

John5023-Nov-09 22:19

John502

3-Nov-09 22:19

Hello Holmes,
Yes, you have given exact query.. i have executed this query in QueryAnalyser it is working fine and this what i am expecting..

Can you please explain me how to execute this query through VC++..?

Thanks
John.

Re: Need help on how to update SQL query using VC++

Mycroft Holmes3-Nov-09 22:32

Mycroft Holmes

3-Nov-09 22:32

Sorry, I wouldn't know VC++ if it wandered up and bit me, I suggest you take it to the language forum.

Never underestimate the power of human stupidity
RAH

Error: 26 SQL Server does not allow remote connections...

Illegal Operation3-Nov-09 14:43

Illegal Operation

3-Nov-09 14:43

Hi!

I have recently published a website to a Windows 2008 x64 Server with SQL 2005 Express Edition. I am able to logon to the website but when I navigate to view employees for instance then I get the error 26 message.

I enabled the TCP/IP and Named Pipes Protocols, added SQL browser.exe to the firewall including port 1433 and 1434. I also checked to make sure SQL Browser is running.

Does anyone have any suggestions?

Illegal Operation

Re: Error: 26 SQL Server does not allow remote connections...

Niladri_Biswas3-Nov-09 18:00

Niladri_Biswas

3-Nov-09 18:00

Hi,
I have not worked in Windows 2008 x64 Server with SQL 2005 Express Edition. So I am not able to give a deep insight on that. However, I have searched in google with ur problem and found this site. Please check if it helps.

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
[^]
Smile | :)

Niladri Biswas

Re: Error: 26 SQL Server does not allow remote connections...

shantanu gupta13-Dec-09 11:30

shantanu gupta

13-Dec-09 11:30

I too had the same problem some time back and I too tried many solutions.
Here are the few good steps and a video to resolve this error.

http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server[^]

Authentication as sql client

tasumisra3-Nov-09 2:53

tasumisra

3-Nov-09 2:53

Hi Friends,
i am trying to refresh a data base where i need to authenticate the user first with something similar window as we see in SQL client.
can somebody help me here..

Thank you very much!

vikas da

Re: Authentication as sql client

Mycroft Holmes3-Nov-09 13:53

Mycroft Holmes

3-Nov-09 13:53

So you are after a logon screen, try searching CP or Google, there are hundreds of examples. You should probably be asking this in the forum of your language choice (C#, VB, C++ etc).

SSIS Variable Problem

Vimalsoft(Pty) Ltd3-Nov-09 2:20

Vimalsoft(Pty) Ltd

3-Nov-09 2:20

Good Day all

i have created a Global Variable as depicted in the following Pic

http://www.tiyaneproperties.co.za/SSIS/pic1.JPG[^]

The Following Screen-shot shows how i created my Variable and its Properties

http://www.tiyaneproperties.co.za/SSIS/pic2.JPG[^]

and the Following Screen-shot shows the Script Editor Properties

http://www.tiyaneproperties.co.za/SSIS/pic3.JPG[^]

and the Last pic is the code that write to the XML File

http://www.tiyaneproperties.co.za/SSIS/pic4.JPG[^]

The Variable comes back empty and at the end the file comes back empty. So i added a if statement as you can see to make sure that the part that write to the file has no problems.

Thank you

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

How can we Empty the whole tables by one single query

lrsalunkhe3-Nov-09 2:09

lrsalunkhe

3-Nov-09 2:09

Respected,
How can we truncate the whole tables value from my DataBase by single query.
Thanks

Re: How can we Empty the whole tables by one single query

Niladri_Biswas3-Nov-09 2:50

Niladri_Biswas

3-Nov-09 2:50

truncate table tblName
Smile | :)

Niladri Biswas

Re: How can we Empty the whole tables by one single query

David Mujica3-Nov-09 3:40

David Mujica

3-Nov-09 3:40

Drop database: The DROP DATABASE statement is used to delete a database. Everything is deleted ... tables, views, indexes, stored procedures, etc

Drop Table: The DROP TABLE statement is used to delete a table.

Truncate Table: Delete the data inside the table, and not the table itself

Use this as reference:
http://www.w3schools.com/SQl/sql_drop.asp[^]

Re: How can we Empty the whole tables by one single query

lrsalunkhe3-Nov-09 17:20

lrsalunkhe

3-Nov-09 17:20

Respected,
But I have given the Relations to Tables.
Thanks.

Re: How can we Empty the whole tables by one single query

_Damian S_3-Nov-09 18:02

_Damian S_

3-Nov-09 18:02

Then do it one table at at time, starting from the leaf tables...

eg:

Persons have one or more Addresses. Delete Addresses first, then Persons.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!!

Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!!
Do something wonderful - make a donation to Camp Quality today!!

Re: How can we Empty the whole tables by one single query [modified]

Niladri_Biswas3-Nov-09 18:39

Niladri_Biswas

3-Nov-09 18:39

You could have specified that in the post.. How can one come to know that you want to perform a CASCADE DELETION ?

e.g.

CREATE TABLE tblPK
( id int primary key )


CREATE TABLE tblFK 
(id int, 
 name varchar(50),
 age int
 FOREIGN KEY (id) REFERENCES tblPK ON DELETE CASCADE)

Niladri Biswas

modified on Wednesday, November 4, 2009 12:51 AM

Re: How can we Empty the whole tables by one single query

Mycroft Holmes3-Nov-09 19:03

Mycroft Holmes

3-Nov-09 19:03

In 20+ years of database design and development I've never actually used cascade delete, I wonder why!

Re: How can we Empty the whole tables by one single query

_Damian S_3-Nov-09 19:09

_Damian S_

3-Nov-09 19:09

Mycroft Holmes wrote:
I wonder why!

Because you are scared of it? Laugh | :laugh:

Re: How can we Empty the whole tables by one single query

Mycroft Holmes3-Nov-09 19:13

Mycroft Holmes

3-Nov-09 19:13

I always envisage someone going to the settings table and using cascade delete on the Standard Customer record or something. Scared does not even cover it, terrified is closer.

Re: How can we Empty the whole tables by one single query

_Damian S_3-Nov-09 19:23

_Damian S_

3-Nov-09 19:23

Meh... don't let users have access to the tables... have a good backup strategy!! Wink | ;-)

Last Visit: 31-Dec-99 18:00 Last Update: 18-Apr-24 18:49

Refresh

ᐊ Prev 1...730 731 732 733734735 736 737 738 739 Next ᐅ

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