Books For Sql Server Development Beginners
Dec 22, 2007Hi,
Can anyone suggest me good books for learning sql server development ie stored procedures etc..
ADVERTISEMENT
Books On Sql Server Development
Apr 7, 2008Hi,
Can anyone suggest good books on exclusively sql server development..Not for the beginners but at intermediate to advanced level.. Books which gives good understanding on Stored Procedures, Triggers, Cursors, Functions...
Connect To SQL Server 2000 With VB.NET For Beginners
Sep 4, 2006I 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!
Can't Play Files: Video Series: SQL Server 2005 Express Edition For Beginners
Apr 20, 2006I 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
Please Help Beginners
Oct 19, 2005The 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
Beginners
Sep 13, 2006I 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 ?
SQL Beginners Problem !
May 20, 2004*** 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
DTS - Beginners Guide
Mar 22, 2001I 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.
Triggers For Beginners
Mar 30, 1999Hi 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
MS SQL Setup For Beginners
May 28, 2004:) 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
Beginners Question
Jul 23, 2005This 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 RelatedQueries Used In Vîdeo For Beginners
Aug 21, 2007Hi,
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
Books - For SQL Server 7.0 DTS
Nov 3, 2000Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Resources For ABSOLUTE Beginners
Jan 26, 2007Seems 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
Books For Sql Server 2005
Jun 3, 2006Hi all
i am beginner with sql server 2005
and i need good books for good beginning
i found many books but i dont know which book i chose ...
what is the books you advice me to read for stability begnning ??
thank you
Good SQL Server Books
Sep 26, 2006Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks
Best SQL Server 2005 Books
Aug 17, 2006Hi,
I am trying to determine a couple of books that will help me understand SQL Server 2005 from a few of perspectives:
Optimizing databases, specifically from SQL 2000 - I have a recommended book Pro SQL Server 2005 Database Design and Optimization
Developing SQL Server 2005 based applications using VIsual Studio 2005 and .NET 2.0 - I have been unable to narrow down to a specific book here. I learn best by example, so I was hoping for a book that basically goes through implementing a "real world" project from scratch to finish. I am going to be using the full-blown enterprise edition of SQL 2005, not the Express Edition; but a book that uses the Express Edition trumps any other book, I would be open to it. Any suggestions on such a book?
Understanding T-SQL and Stored Procedures from a SQL Server 2005 perspective -- Any suggestions? A book that spells out the differences from SQL 2000 would be an added advantage.
Thanks.
SQL Server 2000 Reference Books
Nov 6, 2006There are between 10 and 15 books in the set. I recall an index, developer's book, administrator's book, and two T-SQL reference books. I don't remember what the other books were. Does this sound familiar to anyone? I had these books at my disposal at my last place of employment and I'm trying to get the same books here. If this sounds familiar to anyone, can you point me in the right direction?
Thanks
Finding Books For SQL SERVER Replication
Oct 19, 2004Hi,
I am new in this dbforums. i working on SQL SERVER REPLICATION. I need some books related to only SQL SERVER REPLICATION. If any body konwn then reply me
Sql Server 2000 Administration Books
May 11, 2004Hi All,
Can anybody list out good books for Sql server 2000 Database Administration for a beginer level to the expert.
And also the good resource /sites/forums for learning ,administering and for certification. Which is the best way to busy and where???
I am an oracle //informix DBA
Thx in Advance
Kpai
Sql Server Free Download Books
Sep 8, 2006dear friends please provide me some free downloadable books for sql server DBA's.
i tried i google. but not got any book to download.
Good Books On SQL Server 2005
Feb 22, 2008Can you guys pls suggest Good books on SQL Server 2005 ??
Thx
SQL Server 2005 Books Unavailable
Mar 18, 2007Windows 2003 Server x64, SP1SQL Server 2005 x64, SP2Installed Books Online Feb 2007.
Error displayed when launching Books Online:
'Microsoft Document Explorer cannot be shown because the
specified help collection 'ms-help://MS.SQLCC.v9' is
invalid.'
Work-around detailed in KB here (http://support.microsoft.com/kb/913392/en-us) does not work.
Un-installing Feb 2007 BOL and installing original makes no difference.
Help!
SQL Server Express Books Online
Dec 1, 2007are a mess, reminiscent of the structurless "goto" programming of days past. One of you brainiacs need to erect a "real" getting started section, with procedural steps on how a first time user can successfully download, install, and use SQL Server Express. Not all of us are working in corporations where the guy in the next cubicle can answer questions for newbies.
I will try once again, nicely, to ask a question about installing SQL Server Express Edition SP2 onto a Windows Vista machine. That drama will take place in another post.
New Books On Line For SQL Server Express?
Aug 29, 2006I just downloaded the SQL Server Express w/ Advanced Services and did not see a specific Books On Line for this edition. I know there is a new SQL Server 2005 BOL - I downloaded this as well, and will use to complement the old SQL Server Express BOL.
I was looking for specific information about the differences between SQL Server Express and the Advanced Services edition. I think the Microsoft sites are pretty vague - why is the advanced services edition better for multiuser applications?
Jane
Any Books That Explain How To Setup Windows 2003 Server + SQL Server 2000?
Nov 24, 2004My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Thanks in advance,
John
Books/Online Resources For SQL Server 2005?
Jul 16, 2007Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner
Any Good Books For SQL Server 2000 Administration ???
Jun 5, 2003Hi,
I am an Oracle DBA with over 7 yrs of experience.I am new to sql server 2000 and am given the responsibility of sql server 2000 production databases in a few weeks.I already have the sql server 2000 DBA survival guide.
I would like to know if there are any good books out there for
a)backup and recovery
b)General DBA tasks
c)Performance tuning.
Thanks,
Copernicus
Installing Sql Server 2005 Books Online
May 3, 2008I am trying to install sql server 2005 books online but I am failing and I am getting this message
"This installation pakage could not be opened.Contact the application vendor to verify that this is a valid windows installer package"
am I doing anything wrong or has the version of books online changed? Do I have to install anything else before installing it? or does my operating system not support it?
Thanks
SQL Server 2005 Books Online (May 2007)
Nov 6, 2007I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.
SQL Server 2005 Books Online - How To Install?
Oct 23, 2007Can some one give me detail instruction to installing the SQL Server 2005 Express Books Online.
I am new to SQL Server and want to install the MS training material.
SQL Server Books Online January 2004 Update
Jul 20, 2005Hi,I have been trying to download the latest update to SQL Server BOL forquite some time without any success. I have tried downloading around3-4 times. Every time (size of msi file would be around 25 KB) I try toextract the msi file, I get an error message to the effect that 'it isnot a valid windows installer package'. Has anyone come across thisproblem?Have been trying to download from this URL -http://www.microsoft.com/downloads/...A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=enThanks,Harish*********************************Long way to go before I sleep ..*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedSQL Server 2005 Reporting - Books / Reference Guides, Etc, Need Advice!!!
Apr 18, 2008
I am not new to the SQL Server world, but am somewhat new to the SQL Server 2005 world. I am just getting into the reporting tool. By just messing around for about an hour or so, I was able to get what I wanted somewhat. Basically, I'd like to get up to speed on the reporting side of things fairly quickly. So I am looking at some books, and was wondering if anyone had any suggestions on any.
Here is a few that caught my eye:
-MS SQL Server 2005 Reporting Services by Brian Larson
-MS SQL Server 2005 Reporting Services for Dummies
-Professional SQL Server 2005 Reporting Services by Paul Turley
-The Rational Guide to SQL Server Reporting Services
I am thinking the 1st two would probably be my best bet, but wanted to get you folks suggestions.
Let me know as soon as you can as I am planning on going to the book store tonight or this weekend.
Thanks in Advance!!!
Tony