Re: sql v/s ms access - Database Discussion Boards

sachees1234-Nov-09 20:29

4-Nov-09 20:29

sql query aur ms access main
when i pass "select maid) from enquiry where regdate=#05/11/2009#" from sql
access treate it as 11/05/2009
why???
and wats the solution

Re: sql v/s ms access

Mycroft Holmes4-Nov-09 21:11

Mycroft Holmes

4-Nov-09 21:11

Try this

select maid) from enquiry where regdate=#05/Nov/2009#

or this

select maid) from enquiry where regdate=#2009/11/05#

Read up on datetime

Re: sql v/s ms access

sachees1234-Nov-09 21:59

sachees123

4-Nov-09 21:59

But for this i have to change Date/Time format of System to what u written.

Re: sql v/s ms access

Mycroft Holmes4-Nov-09 22:08

Mycroft Holmes

4-Nov-09 22:08

In Access you MUST be storing your data as a datetime data type, if you are storing it as varchar/string then you are screwed.

SQL Server has a dateformat, I presume that Access has something similar (I know it has I just can't remember the format). This will allow you to control the format of the datestring when you need it.

Re: sql v/s ms access

sachees1234-Nov-09 22:27

sachees123

4-Nov-09 22:27

Thats true, type in access is date/time and format is "Short Date - 26/12/2009".

When i call this through SQL it change dd/mm/yyyy to mm/dd/yyyy.

Where to change, in sql or access??? As i cant change system date / time format.

tell

Re: sql v/s ms access

Eddy Vluggen4-Nov-09 23:09

Eddy Vluggen

4-Nov-09 23:09

sachees123 wrote:
Where to change, in sql or access???

Well, do you want to change the format that Access uses, or the one that SQL Server uses? For SQL Server, you'd set the time format like this;

SET DATEFORMAT ydm;

sachees123 wrote:
As i cant change system date / time format.

The user is the one who sets (or changes) the format, from the control panel. Other applications should display their dates using the format that the user provides. That means that one saves a datetime as a DATE-type. When displaying, convert to a string of the ShortDateFormat or LongDateFormat Smile | :)

I are Troll Suspicious | :suss:

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.

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