Question about Microsoft SQL Server Standard Edition for PC

1 Answer

Help me.. Hai, Am using vb6,crystal report10 and sql server2000.. My doubt is how to retrive the records betwen two different dates.. my system date format is "dd/mm/yyyy" i wrote like this "crxrpt.SQLQueryString = "select CStudent_ID,C_Name,RCourse_Code,E_Date from stumas where rcourse_code='" & Text1.Text & "' and e_date between '"& dtpicker1.value &"' and '"& dtpicker2.value &"'" but it showing none records.. Thanks in advance

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 150 Answers

It needs to be in the format "yyyy-dd-mm hh:mm:ss:nnn". The BETWEEN keyword must include the time as well. so if you want from DTPicker date of "2007-09-01" and "2007-09-10" it will literally be this "2007-09-01 00:00:00.000" and "2007-09-10 00:00:00.000" thus not including any of the day for the 10th. If you want the 10th, then you have increase Date2 + 1 day to be "2007-09-11 00:00:00.000".

You should always remember that dates include the time.

I like to use the >= date1 and < date2. It's a little more forgiving.

Posted on Nov 24, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:


How to Create and Remove SQL Server Password

SQL Server is a Microsoft product used to manage and storeinformation. It uses tables to contain large sets of records for thedatabase. Do you have a SQL server and have you ever used SQL server?Do you know how to create a SQL Server passwordto protect your data stored on SQL server? What to do if you forgetyour SQL password? Following it will introduce you how to create a SQLpassword. And it also tells you how to remove SQL Server password ifyou forget as password can be easily lost.

How to create a SQL Server password?

As we know, it is an important security measure to set a passwordfor user accounts and in particular the SA account. And it is very easyfor you to create a SQL Server password. Just follow the simpleinstructions.

1. Open the Microsoft SQL Server Management Studio program from the Start menu bar in Windows.
2. Click on the SQL Server instance on which the new user will be created.
3. Right-click the Security folder, point to New, and then click Login.
4. On the General page, enter a name for the new login in the Login name box.
5. Select SQL Server Authentication and enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Click the OK to complete the creation of the new user.

Sometimes it happens that you ignore or forget the systemadministrator password. What will you do if you forget SQL password andcannot access to SQL database? The effective way I know is to remove SQL Server passwordwith the help of SQL Server password remover software. MS SQL ServerPassword Unlocker is one of the good MS SQL password remover toolswhich can help you remove SQL password in a few seconds.

How to remove SQL password with Windows Password Unlocker?

MS SQL Server Password Unlocker is handy SQL Server password remover software for you to reset SQLpassword including reset SA password and other user passwords. It caneasily remove SQL Server password for Microsoft SQL Server2000/2005/2008 in a minute. You don’t need to install MS SQL Server onyour PC, and the file in master.mdf format is enough for you to removeSQL Server password and set a new one for it.
Step 1. Download and install MS SQL Server Password Unlocker, and run the application.
Step 2. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.

This SQL account password has been reset. You can login with the newly set SQL password. Although it is easy for you to remove SQL Server passwordwith SQL password remover, it is better to keep your SQL password inheart. Or you can also write it down on a paper and keep in a safeplace.

on Sep 07, 2010 | Computers & Internet

8 Answers

How can i fix the problem by error message 262,level 14,state 1,line 1 CREATE DATABASE permission denied in database 'master' in sql server 2005

RecoveryFix for SQL server database recovery utility is a very powerful utilty to fastly short out your all problems to MS SQL database. By using this application, user can simply repair SQL database. Read more:
For more information read this post:

Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...

4 Answers

Whst is the difference between .mdf,.ldf & .sdf?

LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

Dec 03, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

I want to programaticaly modify an SQL statement in VB6

If I remember correctly you need to call ExecuteQuery or something similar otherwise it does not update the database.


Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

Adodb connection

In VB6 you would use ADODB. This is for ADO and is used for accessing data (read, write, update, etc.) from different data sources. Your connection string will vary based on the data source you need to connect to. Here is an example for a SQL connection:

"Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User ID=sa;Password=your_password;"

For VB.NET you would be using the ADO.NET toosl and a connection string as well.

Apr 27, 2009 | Computers & Internet

1 Answer

Hello! I want to know the features of Sql Server2000,ASP.NET with C#,C,C++

Come on, bit broad don't you think. Ask a more specific question, what are you trying to achieve?

Apr 13, 2009 | Computers & Internet

1 Answer

I want to install SQL server2000 free!

you cant get sql server 2000 free, but you can get sql 2005 express edition free. this is the link to download SQL 2005 express edition. This is same as SQL 2000 if you just want to work on queries.

Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

106 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2971 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides