Guide Needed For Vb.net

Feb 13, 2008

 
how to set values for parameter during run-time.

in query, we set

select * from user_alms where username=?

during run-time, we have to pass values to the username. how it has to be done using dataadapter.

my current coding is as follows:


dim Conn as new odbcconnection


dim strQuery as string


Conn = New OdbcConnection(connString)

strQuery = "select * from user_alms where username=?"

ODBCHelper.ExecuteDataset(Conn, CommandType.Text, strQuery, ds, 0, 0)


 
what i have to do, for pass parameter values to '?' during runtime


 
thanx in advance

View 2 Replies


ADVERTISEMENT

Guide Me

Apr 23, 2008

hi i m new to sql and learning sql server 2005 ..can any body please tell me which topics i have to cover to start with?please help

View 10 Replies View Related

Guide Me

Oct 6, 2006

can you guide me to write a query to get cumulative salary, like this

Ename Salary Cu_Sal
----- ------ -------
A 15000 15000
B 10000 25000
C 20000 45000
D 45000 90000


Do i need to use functions or can it be done by using a subquery.IF yes please explain


one more doubt.Is there a query to write a word in the reverse format.
for ex:SQL--->LQS

also on the same lines can we write a query to convert the case of the string like for ex:SeRVer---->sErvER

View 8 Replies View Related

DBA Guide

Jul 20, 2005

Any good SQLServer DBA guides available online? Preferablya downloadable pdf. Or online in HTML.Thank you.

View 1 Replies View Related

Can Anyone Guide Me

Nov 23, 2005

i'm very new to SQl server, even i know nothing about it, all what i know about is Ms Access, i want to ask that :-

View 5 Replies View Related

Guide

Dec 28, 2006

Hi!
I am a beginner doing ETL processes, searching for a step by step detailed guide. Actually I could not map the columns, getting errormessages, and moreover I need to add sql.

Where could I find a such a detailed guide?

View 1 Replies View Related

DTS - Beginners Guide

Mar 22, 2001

I have "played" with DTS packages but I am now trying to do the following in an ActiveX VB script

Open a connection to database/table <---- Can't find how to do this!
Read a record from the table
Alter the content based on some rules
Post the record back to the table

Simple eh? If anyone has any examples or can point me to a good source of examples.

Many Thanks.

Geoff.

View 3 Replies View Related

Best Guide For Exam 70-229

Oct 25, 2007

I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.

Thank you.

View 2 Replies View Related

Installation Guide Please

Mar 20, 2008

Dear All,
please provide me the complete installation guide links like
on which operating system, which version can install like that...
i've searched in google, but i'm not satisfied. please provide the link from experts side....

thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 3 Replies View Related

Some Links Guide Datetime In Sql !

Feb 17, 2006

I need some links which guide datetime in sql statement !!
Such as : I have a datetime column in my table , I need to calculate
the total orders in the today, or yesterday ...
Any one know ?
Thank you very much .

View 5 Replies View Related

Where Can I Get I Guide On Conventions For Naming

Jun 12, 2007

Where can I get I guide on conventions for naming, stored procedures, tables, user functions ? that I can implement in my work

View 6 Replies View Related

User Manuel/guide

Oct 18, 2007



Hi all,

Search for any samples or whatever help writing professional user Manuel for SSIS any suggest or help is Grateful thanks in advance

View 10 Replies View Related

Can U Guide Me Writing A Simple Query

Jun 26, 2007

I am trying to do following thing:i got a table which contains some words....all i need to do is whenever i see a word starting with 'R', i need to remove the starting 'R'  and update it in the same table... could anyone help me out here.....thanks a lot in advance......... 

View 2 Replies View Related

What's The Best Study Guide Outhere To Pass 70-229

Jan 30, 2005

hi guys,


what's the best book outthere that can help me to pass microsoft sql exam
70-229?

rgrds
Mosaad

View 2 Replies View Related

Guide To Setup Database Mirroring

Feb 29, 2008

Hello room,
I am newbie to Database mirroring.
I have 3 window server 2003 running in window virtual server 2005.
Server1 of sql 2005 instance:
-- SQLDev01
Server2 of sql 2005 instance:
-- SQLDev02
Serve3 of sql 2005 instance:
-- SQLDev03
The servers are running on DC and the sql servers was setup with Window authentication mode only.
Also, All the sql instances'services are running under single domain user name.
e.g: sqladmin.

I have tried to setup manually and t-sql and both running into some issues.
Can anyone help and share t-sript to setup database mirroring.?
Thanks for the help.
TJ

View 8 Replies View Related

SQL 2005 Disaster Recovery Guide

Nov 22, 2006

Hi All,

Does somebody know where can I find a guide or white paper regarding to the subject?

It should contain the procedures needed to recover Analisys, Reporting and Integration services as well.

Thanks,

Miska

View 1 Replies View Related

New To SQL - Can Someone Send Me Towards A Good Guide? More Inside...

Jan 26, 2008


Hey forum...i'm a newbie to SQL, but not IT. However I'm or a network admin than a database admin...so this is completely new.

All i'm trying to do is setup one single database for my mail server to use for grey listing entries. it is using Access right now, and i want to setup a SQL Express database and DSN for it to use.

Does anyone have a good pointer for beginning SQL people?

THANKS!

View 2 Replies View Related

SQL Server Express: Can Someone Provide The Guide MS Does Not?

Mar 30, 2007

The overly complex MSDN library is proving virtually useless to me. To give you some background, I've programmed PHP / MYSQL websites, in-depth VBA programs for Excel and a bit of non-database work in various languages - I'm an amateur.



I've just bought a new PC (2g Ram, Core 2 Duo, Vista Home Basic) and would like to run Web Developer Exp, VB Exp and SQL Server 05 Exp.



Note. I have installed all three and run through Microsoft's video tutorial, until I hit a snag at the start of Tutorial 2. When try to create a new SQL Database in WebDev, an error saying either SQL Server is not installed or operating correctly (could Microsoft provide a more specific error or what????)



The questions Microsoft need to answer are:



1. What are the hardware requirements for SQL Server 05?

2. What are the operating system requirements for SQL Server 05?

3. What does IIS have to do with SQL Server 05?

4. How do you know if you meet the IIS requirements for running SQL Server 05?

5. Exactly what elements of SQL Server 05 are affected by different levels of IIS?

6. Can anti-virus or firewall software cause issues.



Please, some one from Microsoft respond.

View 5 Replies View Related

Please Guide - Especially About Time Dimension And Approach In General

Mar 30, 2004

Hi,

I have a table which contains all the transaction details for which I am trying to create a CUBE... The explanation below in brackets is only for clarity about each field. Kindly note that I am using the following table as my fact table. Let's call it tblFact

This table contains fields like transaction date, Product (which is sold), Product Family (to which the Product Belongs), Brand (of the product), Qty sold, Unit Price (at which each unit was sold), and some other fields.

I have created a Product dimension based on tblFact. I don't know if this is a good idea or not :confused: Is it okay and am I on the right track or should I base my Product Dimension on some other table (say tblProducts and then in the Cube editor link tblProducts with tblFact based on the ProductID field? Please guide.

Now coming to my last question:
Currently I am also creating my Time Dimension based on tblFact. Is this also a wrong approach?
1. Should I instead create the Time Dimension based on a different table (say tblTime) and again link up tblTime and tblFact in the Cube editor?

2. if yes, then how do I create tblTime from tblFact in a manner that it only contains all the transaction dates.

3. Assuming that I should take the tblTime approach, then should this table (tblTime) also contain the ProductID - representing the Product which was sold for each date in tblTime?

I realize that this is a lenghty post but reply and more importantly guidance from the experienced users will be greatly appreciated becuase I have recently started learning/playing around on the OLAP side of things and I know that this is the time that I get my foundations correct otherwise I'll end up getting used to some bad practice and will find it difficult to change my approach to cube designing later down the road.

So many thanks in advance and I eagerly look forward to reply from someone.

View 10 Replies View Related

Data Conversion/Migration Tools/guide

Jun 11, 2008

Please point me towards some good trusted (possibly economical) Data Conversion tools for converting legacy system SQL 2000 (XML, Image all data type) db data to SQL 2005 database (and possibly to Oracle too) in a totally different db schema/structure.

View 6 Replies View Related

Oracle Server Quick Reference Guide

May 29, 2006

Oracle Server Quick Reference Guidehttp://quickdba.blogspot.com/2006/0...ence-guide.htmlVisit daily to get more updated articles

View 1 Replies View Related

Error 1418 And Good Basic Setup Guide

Jun 16, 2006

Hi,

I'm new to DB Mirroring, and I am trying to get it going in a test enviroment between two SQL 2005 Dev Servers. I have followed documentation that I have found but cannot get past a 1418 error when establishing a connection between the servers initially. Does anyone know of any good step by step guides that I could look at, in case I have missed something stupid.



Thanks in advance



Stupots

View 19 Replies View Related

SQL Server 2005 Integration Services Installation Guide

Sep 8, 2006

Hi, all,

Thank you very much for your kind attention.

Would please any here give me any advices for where can I find the SQL Server 2005 Integration Services Installation Guide? The one I found online (http://msdn2.microsoft.com/en-us/library/ms143506.aspx) is just confused me, which is just about the installation of SQL Server 2005 different version.

Really need help for that.

With best regards,

Yours sincerely,

View 3 Replies View Related

Urgent: Suggest The OLAP Service Installation Guide Source

Oct 22, 2001

See topic

View 1 Replies View Related

SQL Server 2008 :: White Spaces Not Getting Ignored For Plan Guide Matching?

May 1, 2015

In sp_create_plan_guide documentation, it's written:

When SQL Server matches the value of statement_text to batch_text and @parameter_name data_type [,...n ], or if @type = 'OBJECT', to the text of the corresponding query inside object_name, the following string elements are not considered:

White space characters (tabs, spaces, carriage returns, or line feeds) inside the string.
Comments (-- or /* */).
Trailing semicolons

On SQL Server 2008 SP3, I created a plan guide for a query. Now, if I execute the query exactly how it was defined in the plan guide, SQL Server match it and use the plan guide to optimize the query.

However, if I add just a space between a column name and an operator in the WHERE clause, the plan guide is ignored. How come it doesn't ignore the extra space, like mentioned in the documentation?

View 3 Replies View Related

Sp Help Needed

Sep 24, 2006

Im new to stored procedure, but here's what I want, if someone can get me started and provide this as an example it would be VERY welcome!I have the following, a SP with parameter IsMale. This parameter may be empty. If it's not empty I want to add some text to my selection query: AND IsMale=paramvalueHere's the SP so far:ALTER PROCEDURE [dbo].[spFindUsersAdvanced] --declare parameters here@IsMale bitASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;   SELECT DISTINCT BirthDate,IsMale, FROM aspnet_Users INNER JOIN tblUserData ON aspnet_Users.UserId = tblUserData.UserID WHERE tblUserData.Username<>''IF @IsMale THENBEGIN  AND IsMale='True'ENDELSEBEGIN  AND IsMale='False'ENDEND IFEND1. How do I check if the parameter is empty?2. How do I add the text to my selection query?

View 3 Replies View Related

Help Needed

Oct 30, 2007

Hi all,I am trying to write a stored procedure, which has two insert statements.the first insert statement, is simple which inserts data into a table and returns the primary key for the new row added. using this primary key, i am writing another insert statement, which passes a list of elements which would be then entered into another table, with the primary key of the first table.Is this possible to do in a single stored procedure? I have implemented this using two different sp, but am wondering if it can be done other way?thanks for your help! 

View 10 Replies View Related

Help Needed

Dec 1, 2004

Hi,

For many to many relationship, what is the minimum number of tables required.

View 1 Replies View Related

Hep Needed!!!

Oct 17, 2005

Hi plz read below is my scenarioI have two diff tables which stores passwords (don't ask why b'coz it was there).Now to make data in both table consistance what I need to do?plz provide optimized solution.Thanks in advance.bye bye.happy coding!!!

View 1 Replies View Related

Help Needed.

Dec 20, 2000

Experts,

I've few questions regarding SQL Server. Appreciated, If any one out there help me with it.

I would like to do T-SQL Programing and would like to know some good book. I'll mostly be doing Stored procedures,Triggers and views programming. Any advice?

On my sql server I've 10 logins. But, I cannot view these logins from the Enterprise GUI. But, When i run a query against the syslogin table, those all 10 logins shows up. Why is that?

any help would be greatly appreciated.

View 1 Replies View Related

SQL Help Needed.......

Mar 25, 2004

Access 97.................

I'm trying to construct the following SQL statement but am missing something somewhere.

I get a syntax error with the 1st FROM highlighted.

If i construct a query out of the bit that works and then construct a query on that query then i can get it to work no problem but how to mimic that in SQL ? I can't simply view the SQL of the queries because the query names replace the SQL statements.

I'm trying to SUM the 5 volumes that get returned by the TOP 5 SQL statement. The VotingUniverse_TotalVolumeByType query returns the TotalVolume which will enable me to divide the SUMmed 5 volumes by the TotalVolume to obtain a %age.



SELECT
Type,
Sum(Volume) AS Volume,
TotalVolume
FROM
>>>>>>>>>>this following bit works............
(SELECT TOP 5
VotingUniverse_TopFirmsVolumeByType.Type,
VotingUniverse_TopFirmsVolumeByType.Volume
FROM
VotingUniverse_TopFirmsVolumeByType
WHERE
(((VotingUniverse_TopFirmsVolumeByType.Volume)
In (SELECT TOP 5 VotingUniverse_TopFirmsVolumeByType.Volume
FROM
VotingUniverse_TopFirmsVolumeByType
ORDER BY Volume DESC)))
ORDER BY
VotingUniverse_TopFirmsVolumeByType.Volume;)
>>>>>>>>>>>end of bit that works
INNER JOIN
VotingUniverse_TotalVolumeByType
ON
Type = VotingUniverse_TotalVolumeByType.Type
GROUP BY
Type,
TotalVolume;



hope this makes sense to someone anyway

thanks


====
Paul

View 5 Replies View Related

Immediate Help Needed!! Thanks A Lot!

Aug 15, 2002

I have a xxx.exe running on SQL 2000 server as a sql job every hour. For some reason this job sometime just hung in the middle and never finish. But
if I stop it and rerun it, it will be down within 10 seconds. I am wondering
if we can set up something so that the job aborts automatically if it ran more than 10 minutes.

View 1 Replies View Related

Help Needed!!!

Feb 22, 2001

Hi everyone.

We are running Sql 6.5 sp5 on a Pentium II 350 Mhz with 512 Mb. RAM, 1 ScSi 4 Gb hd, one 8Gb ScSi hd and 2 IDE hd (13,6 Gb and 8Gb) computer running windows NT 4.0 sp 6 without any problems.
Now have bought a new computer. The new one is a Pentium III 733 Mhz 512 Mb Ram with 2 ScSi ultra wide 2 18Gb each and one 40 Gb Ide Hd. We have installed windows NT 4.0 sp 6 and Sql 6.5 sp 5. We have restored our database to make some tests to it. The database is 7 Gb big.
The results of our test are that the old computer is between 20% and 30% faster than the new one when doing sql instructions and using the database even knowing that the hd´s of the new computers are 4 times faster than the old ones.

Would you please give us any help or clue that would make the new computer go faster?
We know that upgrading to sql 7 will work but we need first to make this computer work better with the 6.5.
Thank you.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved