Does anyone know any good MS SQL or TSQL tutorials? I know the basics of SQL, such as joins, functions such as COUNT, SUM etc so I do not need one of them. Problem is I am using MS SQL at a new role in work and finding it difficult. I write the statements how I would in oracle of mysql but find that they refuse to work, and I can not find/use the MS SQL Help to find what I want.
Cheers, Mike
I am trying to go thru the deployment tutorial, but I'm running into some trouble. The two sample packages I need to work with are called DataTransfer.dtsx and LoadXMLData.dtsx found in the samples.
When I examine these packages, they are writing to tables called dbo.HighIncomeCustomers and dbo.OrderDatesByCountryRegion. These tables don't exist in my copy of AdventureWorks database.
Also, when I try to open the Connection Manager for the target tables, I get a message that says, "The specified provider is not suported. Please choose different provider in connection manager."
Is it possible I'm having these issues because I'm working with a different version of the sample packages?
Does anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.
View 2 Replies View RelatedHi,
Can someone suggest me a simple and nice tutorial that can explain T-SQL with examples.
Plizzz....
Regards..,
Aazad
Hi There
View 13 Replies View Relatedmy freind asked me to look for him for online book or something very good that teach SQL for SQL server 2000 ... what i need is something like hands on examples that will take user from level 1 to level * .... i have seen alot of stuff in google but i think some of you might know what i need and can direct me to better resources as i could not find someting specail !!!
View 2 Replies View RelatedHiI'm having problems following the tutorial on creating a data access layer - http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page. <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle"> <HeaderStyle CssClass="HeaderStyle" /> <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines... using NorthwindTableAdapters; <<<<<this is the problem - where does this come from? protected void Page_Load(object sender, EventArgs e) { ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts(); GridView1.DataBind(); }Thanks in advance
View 6 Replies View RelatedI am a newbie to tsql. I am trying to find if a job has failed, if so I only want to pickup the lastest job. I want to see name,message and run date. I know I need to find the max run_date and run_time for each job_id. I know that I need to join the sysjobhistory table and the sysjobs tables. I also know that I need status not equal to one. I have tried thousands of different things and nothing seems to work. If I ever get this to work then I only want to look at jobs in the last 24 hours. I am not going to include any of my job since I have tried so many things and I have been all over the map.
Does anyone have a TSQL utility (that they can share) that recursively searchs sysobjects for a matching input parameter string(for instance column name) for stored procedure object properties that returns the stored procedure name?
View 1 Replies View RelatedBefore page 12, step by step instructions work!
Then there is code for AllProducts.aspx that doesn't work if one inserts the code
into the DataTutorial project started on page 1. Yes I changed the name of the CodeFile!
The code given for AllProducts.aspx.cs doesn't compile.
I was doing better without the tutorial!
I can gleen out some concepts but that is all.
If that is all, why have a tutorial?
We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFO [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
Can anyone please give me the equivalent tsql for sql server 2000 for the following two queries which works fine in sql server 2005
1
-- Full Table Structure
select t.object_id, t.name as 'tablename', c.name as 'columnname', y.name as 'typename', case y.namewhen 'varchar' then convert(varchar, c.max_length)when 'decimal' then convert(varchar, c.precision) + ', ' + convert(varchar, c.scale)else ''end attrib,y.*from sys.tables t, sys.columns c, sys.types ywhere t.object_id = c.object_idand t.name not in ('sysdiagrams')and c.system_type_id = y.system_type_idand c.system_type_id = y.user_type_idorder by t.name, c.column_id
2
-- PK and Index
select t.name as 'tablename', i.name as 'indexname', c.name as 'columnname' , i.is_unique, i.is_primary_key, ic.is_descending_keyfrom sys.indexes i, sys.tables t, sys.index_columns ic, sys.columns cwhere t.object_id = i.object_idand t.object_id = ic.object_idand t.object_id = c.object_idand i.index_id = ic.index_idand c.column_id = ic.column_idand t.name not in ('sysdiagrams')order by t.name, i.index_id, ic.index_column_id
This sql is extracting some sort of the information about the structure of the sql server database[2005]
I need a sql whihc will return the same result for sql server 2000
HI there... i'm really new to this, and i want to know if there is a tutorial of how to connect to sql database, display the data online, and run some queries....
thanks in advance
please e-mail me to hachemr@hotmail.com
Where can I find a good MDX tutorial ..
I am a beginner with analysis services
but got a job in which i have to create a cube and some mdx querires
Try this outRegards,Josephhttp://db2examples.googlepages.com
View 1 Replies View RelatedDo you know a good link (i.e. on msdn) that has a good tutorial for SSIS?
Thanks
Hey guys, while going thru the sql tutorial #5 on this website, I have run into an error. Am using, sql server management studio where it is required I attach a database, on adding the selected db, here is the error that I get, and i have no clue whatsoever on how I must proceed:
TITLE: Microsoft SQL Server Management Studio------------------------------
Attach database failed for Server 'parijat'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Could not open new database 'MyCompany'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
hi there! im new to MSSQL and i want to know if anyone of you knows a reliable website which teaches a detailed and in depth info on how to use mssql...
thanks!
I'm using VB to access MDBs, and now I want to expand my work to a SQL server. Does anyone know where someone of my needs can find a suitable tutorial?
Thanks in advence,
Chen
There's a tutorial (http://msdn2.microsoft.com/ms345296.aspx) on how you create a login in SQL Server. But when I type a new user name I get the error message that the name allready exists. But if I type a existing user name I get the error message that the user name or group couldn't be found.
View 3 Replies View RelatedHi all,
i'm looking for an article on how to use DataTypes of SQLServer in T-Sql script writing !!!?
As you know the Books-Online has limited example and i have trouble undertanding for example how to use Binary,varbinary Decimal,Float,real...in T-sql script
Could anyone showm me an instructive article on the net?
Thanks in advance.
I'm a coldfusion programmer that works with SQL Server databases. We have the opportunity to move our database from a shared sql server to a semi-private virtual machine with our own copy of sql server 2005. We'll all of a sudden be able to use more features of sql server including replication. We want to be able to keep several databases on the same server in sync so that we can have a production database and a development database that are identical.
I'm not a professional dba but I am willing to learn. Is there a good, straightforward tutorial about setting up and using replication out there that someone can recommend?
Many thanks!
Are there any good free online tutorials for T-SQL?
View 2 Replies View RelatedHi Forum-Members,
I was doing the Step by step tutorial "Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005". Link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp
Doing it on Windows XP (as required by the tutorial) worked fine for me, doing it on a Windows Server 2003 installation failed, as the client could not connect to the SQL Server database.
Does anyone have experience stepping through the tutorial on a Windows Server 2003 machine?
Best Regards,
Tobias
Hello!Im trying to write SQL but I dont think that SQL is enough for me right now.I wants to write Stored Procedures, but I dont know how to... Is there any good tutorials you can recomend?
View 3 Replies View RelatedDo someone know good tutorial on web with examples for search data from SQL database?
View 2 Replies View RelatedHello all,
I have been trying to set up roles and security for my database using SQL Web Data Administrator(from Microsoft). Unfortunately, i am facing some difficulties to do it. Is there any link that explain how to manage these roles and security issues in the program.
Thanks
hi all,
could anybody send me the tutorial site for learning sql server...
especially in stored procedure,functions,triggers.
thanx in advance
hey!Im looking for a db tutoral which covers accessing a Microsoft SQL databaseon windows. I will be using VC++ if it matters. NO details just a basicintroduction!Oracle DB access using C++ is also of interest!Thanks!-- Majk
View 1 Replies View RelatedAfter I complete the SSIS Tutorial Lesson 5 and try to run the package, I found there's no any rows inserted into the error output file. I'm sure that I'd followed all the procedures. Anybody help?
View 1 Replies View Related
One of the wonderful tutorials Microsoft done for SQL DBA/ Developers
If you are having hard time to understand SSIS Package. Please finish the entire tutorial to become Master on SSIS.In order to finish the entire tutorial you need to start from fresh installation of sample Database by Microsoft. Once finish all Tutorial you will be master on SSIS.Good luck.
Thanks
Faiz Farazi
MCDBA, MCSA
I'm new to SQL Server 2005 Express. I'm sure it's great but after successfully installing it on Vista, I don't know how to "connect" to the default "instance".
Can someone please point me to a online tutorial on connecting once installed... or please help me out with understanding this.
After that I think I can go forward with the msdn video tutorials.
Thanks in advance
In Lesson1 of SSIS Tutorial, section "Running the Wizard to Create the Basic Package", is stated
"Specify the data source. You will use the Excel workbook, Customers.xls, as the data source..."
I have both AdventureWorks databases installed on my box as well as a host of samples but I can't find that file. Any pointers much appreciated.
TIA,
barker