Anyone Direct Me To Good JOIN Tutorials..
Oct 8, 2007ok i need to know the difference between inner outer , left , right joins ....
anyone know any good tutorials ?
ADVERTISEMENT
Advanced SQL Tutorials
Nov 29, 2005Dear All,
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...
How Do You Launch Tutorials?
May 8, 2007I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.
When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.
What am missing here?
Some Nobish Tutorials
Mar 13, 2006hi there
Can someone post some very good tutorials about MS SQL 2005 working with c#??
please
Thanks guys..
Sql 2005 Tutorials
Mar 20, 2008Can someone tell me where I can find some SQL 2005 tutorials, e-learning or learnig tool for a kind of beginner. I want something where I can learn by doing. Some of the tutorials I have seen all pertain to .NET.
Thank you
Dee
Online Books / Tutorials
Aug 2, 2002Hi All...
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
Thanks to ALL
SQL 2005 Reporting Tutorials
Mar 21, 2008
Could someone point me to some good SQL 2005 Reporting Tutorials? Types of Reporting? Reporting without using .NET?
Dee
Installing SSIS Tutorials
Jun 30, 2006I feel stupid for asking this but I can't seem to find where to install the SSIS tutorials referenced in msdn.. specifically the "Deploying Packages Tutorial". In the SQL Server 2005 Developer Edition DVD that I have, I've chosen to install all of the samples etc. I have the AdventureWorks and AdventureWorksDW and a whole bunch of samples in "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesPackage Samples" but under the directory "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesTutorial" I only have sample data for "Creating a Simple ETL Package".
I know... feels like a dumb question but I have run the install wizard on both the dev edition dvd and the msdn library dvd several times and looked at all the options and can't find anything about tutorials under the SQL server installation or the workstation component installation. Please help. Thanks.
ADS Wizard, Tutorials And Examples - Please Help.
Oct 26, 2006Hi,
I'm new to SQL Server Technology and am trying to learn how to create a Mobile Device application and to sync it with a desktop application that uses Access. I have found a lot of information but some of it doesn't seem to make sense.
I found this blog: http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx which is the announcement of Access Database Synchronizer (ADS) CTP. I downloaded it and installed it with all the prerequisites. This is the part i can't understand:
"The CTP setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Everywhere Edition database on the device."
I cannot seem to find the desktop component to try out! The Readme shows you how to pull and push data but i can't see where the desktop data sync wizard is located. Should there be something installed on my desktop that i can see?
Also, there doesn't seem to be much help or examples around on this component as yet. Can anyone point me in the right direction for examples, help, or tutorials on this.
This paragraph also confuses me:
"Note: As of today only SQL Server Mobile Edition is available for devices. SQL Server Everywhere Edition whould be available for devices at time of SQL Server Everywhere Edition RTW whihc is planned for November 2006".
Does this mean SQL Everywhere won't work on mobile devices until November?
Sorry for all the questions but i'm still trying to learn this stuff so i can write my application for Windows CE. Thanks in advance.
Service Broker Tutorials
Nov 16, 2005Where can I find tutorials on Service Broker with C#?
View 1 Replies View RelatedSQL Server 2005 Video Tutorials Please
Aug 14, 2007Hiii everyone,
Can anyone send me the link of SQL Server 2005 Video tutorial please..
I am waiting for it.....
New SQL Site For Code Library; Tutorials & FAQ.
Aug 20, 1999Check out www.sql-server.co.uk.
This site offers a growing code library; tutorials & the full FAQ from Neil Pike SQL Server MVP in an easily readable search/review format.
Also a possible UK user group is being formed, initially information for this will be passed through this site - register there.
MS SQL Server 2005 Newbie Tutorials Available?
Aug 29, 2006I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?
View 3 Replies View RelatedSQL Express - Guides/tutorials/intros
Apr 18, 2006Hi - can anyone recommend tutorials/guides for beginners? The Microsoft documentation seems very poor to me especially in comparison to Oracle Express. I am really struggling to find a good intro/tutorial.
Many thanks
db
SQL Server Mobile Editon Tutorials
Sep 12, 2005I installed SQL Server 2005 and want to practice the "Creating a Mobile Application with SQL Server Mobile" in SQL Server Mobile Editon Tutorials,but I can't find the file sqlmobile.sql listed in "C:" according to tutorial document.
View 3 Replies View RelatedCan't Install Sample Databases Plus No Documents Or Tutorials
May 17, 2006I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ???
R
Where To Get More In-dept Tutorials For The Data Mining Add-In For Excel?
Jun 13, 2007Does anyone know where we can get more in-dept tutorials for the Data Mining Add-Ins for Excel? Currently, all we have are the videos from the microsoft web site as well as some white papers.
View 1 Replies View RelatedDatabase Filename Error -- Cannot Create Db From MS Online Tutorials
Apr 20, 2006I am using VB with Visual Studio Express. I am new to these tools. I have SQL Server 2005 Express installed on my machine. I think that I have the right version. I am just using Express for taking classes and teaching myself on my machine.
When I follow the examples in the book, I keep getting this error when I go to my ASP.NET configuration and click on the security tab to add myself as a user.
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote) " -- end of erro msg.
I have an apostrophe in my last name. Could that be what is causing it? Is it creating a db based on my name or something? Or do I have the wrong version of SQL Server Express installed.
Thank you for any help. I appreciate it.
--Mark
SSIS Tutorials: Lesson 1 - Missing Customers.xls File
Nov 28, 2006I can not seem to locate this file any where on my computer let alone in the specified directory. With out this file, it would be very difficult if not impossible to go through rest of the SSIS tutorials. Could I ftp this file from some locations so I could get started on the tutorials.
I would very much appreciate any help.
Thanks
Help With Direct Update
Aug 27, 2007hi guys help please. I have a column name Quantity of type int in my table table1 and it has an intial value say 5. My question is, is it posible to update that column say, i want to add 10 from its initial value for it to have a value of 15, without querying it first from my application and store it to a varibale and add 10 to it for it to have 15 and execute update to set the initial to new value (15).
View 6 Replies View RelatedDirect Interface To SQL Server
Dec 4, 2007I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:
- A dropdown of different connection strings, to connect to different databases
-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)
-A gridview object for results
-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)
I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)
Direct SQL Vs Stored Procedures
Jan 3, 2008Hi,
There are certian "routine things" that need to be queried in my database. Currently we can either do:
1) SELECT * FROM myTable WHERE id = x
OR
2) We can use a stored procedure to do the above SQL for us...That way, if the table changes, or we make changes to the database etc. The calling code will remain unchanged and we just have to change the stored procedure code instead of anywhere that calls it.
What would you say are any disadvantages of doing the 2nd approach?
Thanks!
Prints Everything Big In Direct Printing
Apr 10, 2007
I am using SQL RS 2005 with VS2005 in Windows Application. I have placed Report Viewer on Windows From and then report is attached with it. Now report previews well in BIDS as well as in VS2005. Moreover it exports perfectly to pdf and excel but when I click print button on report viewer and give direct print to printer, font size, textbox, rectangle and every other thing become large, like instead of 10 font size, it prints 12, instead of 240 width of rectangle, it prints 280 or so.
There must be some solution to this thing. Some one help
Is There Is Any Direct Way To Set Optional Parameter
May 12, 2008
hi all,
I am using SQL reporting services 2005, i like to have a parameter as optional, is there is any diresct way to set a parameter as optional without setting through the default value.
Direct Deployment Issues
Jul 24, 2007Hi
I have found article by Jamie T. (www.sqlis.com/26.aspx) where he explains how to use direct configuration.
I followed every step.
Before building project I made sure that CreateDeploymentUtility = True.
Once project was built I have copied files from Deployment folder to other PC to c:PackageConfiguration (I have 3 files there: environment.dtsconfig, PersonAge.dtsx and jamie.SSISDeploymentManifest)
dtsConfig file is;
<?xml version="1.0" ?>
- <DTSConfiguration>
- <DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="me" GeneratedFromPackageName="PersonAge" GeneratedFromPackageID="{2612ABDA-E4FB-43DF-A1C1-44066426A798}" GeneratedDate="7/24/2007 9:46:41 AM" />
</DTSConfigurationHeading>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[InitialCatalog]" ValueType="String">
<ConfiguredValue>DataStore</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[ServerName]" ValueType="String">
<ConfiguredValue>MyPCsql2k5local</ConfiguredValue>
</Configuration>
</DTSConfiguration>
However, I am doing something wrong as I was not able to deploy this to another PC.
I double click Manifest file and in Configuration Package - Property there are two entries: InitailCatalog and ServerName. Initial Catalog has Value=DataStore and ServerName = MyPCsql2k5local. I change ServerName to be AlexPcSQL2k5Local.
I have Validate Package after instalation so I get error saying that connection to Destination failed.
If I go to File System to installed package and say Run, package will run OK if I change all ConnectionManagers to point to AlexPcSQL2k5Local
What is it that I am doing wrong?
Direct Link To Reports
Jul 12, 2007Hi There,
I have recently upgraded to report Server 2005. I used to have a webpage that loaded a number of reports into different frames to give real time statistics for an IT Service Desk.
In the new version if try and link directly to the report (By right clicking a report and taking the link) the report loads with out any of the toolbars etc at the top as i need it, however it does not refresh and seem to be cached data.
Has anyone got any ideas how to resolve this problem, in short all I need is a way to directly view the report losing all the toolbars etc on the top and just displaying the data.
This has been driving me mad so if anyone could help i would be really grateful!
Many thanks
Gerard
Direct Display Of SQL Image Field
Aug 3, 2004Hi
I have a SQL 2000 table in which pictures are stored as an Image column. I want to display then onto a c# aspx webpage without storing them to disk.
What is the best way to read and display the pictures?
In classic ASP I used to do this:
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.fields("ThisImage")
but I can't get this to work in c#.
Differences Between Variable And Value Direct In A SELECT
Dec 11, 2007I have a table from 1.5 million records.
A valued-table function with the parameters used in a SELECT.
1) If I use:
DECLARE @Par1 int
SET @Par1 = 28338;
SELECT Count (*) FROM MyTableValuedFunction (@Par1)
Running time: 2.3 min.
2) If instead:
SELECT Count (*) FROM MyTableValuedFunction (28338)
Running time: 0.02 sec.
Why?
The two solutions are not identical?
Direct Vs. Indirect Package Configurations
Sep 29, 2006If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?
I am modifying the connection string with the XML. My strategy is to set up an XML configuration for each database that we have. The Dev XML config will point to Development connection, UAT to UAT etc..
My thought is that by using the direct configuration it will eliminate the need for environment variables and also allow me to add configs without having to reboot the servers, which you would need to do in order to get server to recongize the EV.
Thanks
Replication And Direct Updating In SQL 2000
May 3, 2006I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.
One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!
Does anybody have any ideas about how this could be happening ?
Is it ok to have users directly updating on the server and users synchronising ?
I would appreciate any help!!
Thanks.
Can Any One Tell Me The Difference Between Cross Join, Inner Join And Outer Join In Laymans Language
Apr 30, 2008Hello
Can any one tell me the difference between Cross Join, inner join and outer join in laymans language
by just taking examples of two tables such as Customers and Customer Addresses
Thank You
Trusted Connections && Preventing Direct Db Access
Aug 29, 2007Is there a way to use trusted connections in ASP.NET and WinForm applications yet prevent users from accessing databases directly (outside of applications) ? I know the use of trusted connections are recommended for several reasons however I have a lot of applications that I need to prevent users from accessing databases directly outside of the applications themselves.
View 5 Replies View RelatedShortcuts, Direct Keys In Management Studio ?
Dec 8, 2007Hello. Does anybody knows if the are shortcuts to differrent menu items in Sql 2005 Management Studio ?For example i will to use the "Execute " button without need to use the mouse, as this case as of others.Any knows where can i find a map or a page info with the shortcuts of SQL2005 Management Studio ? Thanks
View 1 Replies View Related