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.
The followong statement is working
iif ([Measures].[Docsum]>500, "1","0")
But there is a need to count these Docsums
so
iif ([Measures].[Docsum]>500, Count[Docsum],"0")
but not this way
Can somebody help and explains, how to Count these sums
Thank's
I have just started learning SQL server. Where from I start. I have downloaded SQL Management Studio & SQL Express Edition.
Now What should I do now ?
*** edited by: master4eva ***
Please enclose your code in < code ></ code> tags (without the spaces). This will make your code easier to read online; therefore, encouraging a response to be faster. It is to your own benefit for your question to be answered in future.
I have already done the editing to include the < code ></ code> tags for this post.
*********
Hi,
I am following tutorials in a book to try and implememnt a basic select query using SQL.
However i am following all the instructions, which includes entering this header:
<%@ Page Language="VB" Explicit="True" Debug="True" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
Then i am dragging a data grid onto my form, constructing a select query in query builder, however the resultamt code i get is totally different than the one in book.
The ideal poutcome refers to the SQL client, SQL reader etc, however in my code below, there is NO mention of SQL at all...simply dbconnection, IDatareader.
can anyone help me out here..I know it's probably soemthing simple.but I'm stumped, and I've followed everything in the book.
H
Function Page_Load() As System.Data.IDataReader
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=F:My Documents"& _
"shopping.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT [Product].* FROM [Product]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Return dataReader
End Function
Hi all,
I have just started getting stuck in to SQL Server and have a silly question - i cannot find an example trigger anywhere for
UPDATE
INSERT
DELETE
I know i can use the insered or deleted tables, but my TSQL doesn't seem to work.
Any assistance (in the form of an exmaple!) would be greatly appreciated.
Thanks in advance
Simon
:) Hi dear fellow members,
I am a newbie to MS SQL. I already completed the installations on the SERVER side and CLIENT side. I have an inventory database in Ms Access that I want to transfer into MS SQL SERVER 2000. Is there anybody who can help me how to do it?
I would be very thankful to anybody who can help like me
who is new to SQL
Regards.
BOBOY PONCE
This is probably straight forward, but let's see:Say I have a Family which includes an address field table and a relatedFamilyMembers table which includes an age field.I need to output a report on each Family where there is at least onefamily member with an age over 16.Any help gratefully received!
View 4 Replies View RelatedHi,
I just installed reporting services and now starting with the video tutorial for reporting services(http://msdn2.microsoft.com/en-us/express/aa718391.aspx)
In Video 10 and 11 some queries are used to demonstrate building reports. I would like to repeat the steps in the video but I need the SQL Queries used in those videos.
Does anyone have any idea where I can download those SQL queries in order to programm the same reports as shown in the videos?
Many thanks for your replies and best regards from Switzerland
Chris
Seems to me like microsoft mentions learning, but it's never for beginners. I haven't found a single tutorial that says how to make a simple database step by step.
Does anybody know about a tutorial focused on teaching the very basics (a kind of "hello world" application) from setting up the new database with a few sample fields to "deploying" it (making it ready to be used)?
Please let me know.
Once I'm through with these first steps there seems to be a lot of helpful learning resources meant for experienced and expert users, but I'm not there yet...
Thanks,
Bernardo
Hi,
Can anyone suggest me good books for learning sql server development ie stored procedures etc..
I just started to learn Visual Basic 2005.NET. I have experience with VBA in Access and SQL Server.
I
now want to build applications (client/server) with VB & SQL
Server. Does anyone have a simple example with which I can start
learning?
Thank you in advance!
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 Relatedcan 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
Any good SQLServer DBA guides available online? Preferablya downloadable pdf. Or online in HTML.Thank you.
View 1 Replies View Relatedi'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 RelatedHi!
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?
I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?
Thanks,
Brian
Video Series: SQL Server 2005 Express Edition for Beginners
C00D1199: Cannot play the file
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
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.
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.
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 .
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
Hi all,
Search for any samples or whatever help writing professional user Manuel for SSIS any suggest or help is Grateful thanks in advance
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 Relatedhi guys,
what's the best book outthere that can help me to pass microsoft sql exam
70-229?
rgrds
Mosaad
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
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
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!
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.
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.
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 RelatedOracle Server Quick Reference Guidehttp://quickdba.blogspot.com/2006/0...ence-guide.htmlVisit daily to get more updated articles
View 1 Replies View RelatedHi,
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