Database Discussion Boards

First Prev Next

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 | ;-)

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

J4amieC3-Nov-09 23:52

J4amieC

3-Nov-09 23:52

Thats even the worst side effect.

Imagine a header table with, lets say, 1000 records in it. Each header has 100,000 (badly indexed) child records. Cascade delete is turned on.

Someone comes along and says "Ah header table only has 1000 rows, it will be easy to delete a record from there".

Database reduced to treacle.

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

Ashfield4-Nov-09 7:31

Ashfield

4-Nov-09 7:31

Probably for the same reason as I haven't - we are control freaks who like to explicitly delete things when we want to, not sudenly finding it happening 'on its own' Smile | :)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

SSRS - web service interface generated pdf's with slightly different font/color

devvvy3-Nov-09 0:46

devvvy

3-Nov-09 0:46

hello

SSRS - web service interface generated pdf's with slightly different font/color compared to those pdf when access via "Direct URL access" (point browser to http://localhost/reports/SomeReport/SomeReport - then export by pdf).

Any idea why? Perhaps it has to do with DeviceInfo in Render method? What do I need to do so two are same?

Thanks

dev

Table could not found

haleemasher2-Nov-09 22:33

haleemasher

2-Nov-09 22:33

i have a crystal report which is bind with oledb database. tommorrow its working but now it show error that "Table could not found". i googled my problem and can't find any satisfactory solution if anyone knows it solution plz share with me.
advance thnx 4 help

Re: Table could not found

Niladri_Biswas2-Nov-09 23:55

Niladri_Biswas

2-Nov-09 23:55

Hello,
See computer does what we ask to do.. It's not a magic or cannot play games with us.. right Smile | :)

So what I think is that, check whether really that table is there or not in the database.... I mean to say that check the data source of ur crystal report. May be something happened without ur knowledge..who knows? Blush | :O

Niladri Biswas

need latest records

Member 38798812-Nov-09 18:23

Member 3879881

2-Nov-09 18:23

Hi i have 2 tables..,
one is master another one is child...,

ex:

Master=>Pid is primary key
===========
Pid Name
1 m1
2 m2
3 m3
4 m4
5 m5
6 m6

Child=>Cid is primary key
==========
Cid Pid Name
1 2 nm1
2 2 nm2
3 1 nm3
4 5 nm4
5 6 nm5

Now i need the lastest records...,

O/p:
======
Pid Cid Name
6 5 nm5
5 4 nm4
4 null m4
3 null m3
2 2 nm2 //in child table have 2 records for pid...,in tht latest is Cid=2
1 3 nm3

Thanks & Regards,
Member 3879881,
please don't forget to vote on the post

Last Visit: 31-Dec-99 18:00 Last Update: 27-Jun-24 21:26

Refresh

ᐊ Prev 1...731 732 733 734735736 737 738 739 740 Next ᐅ

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