Good Book About Stored Procedure
Mar 5, 2008Hi:
Can you please recommend 1-2 good books about "stored procedure", I need a book which starts from basic and goes to developed level.
Thanks.
Jt
ADVERTISEMENT
Good Book For Learning The Stored Proc Language
Jul 12, 2007Though I have been using SQL Server for some years, it is just recently that I have need to learn how to write SP's. I would like a recommendation for a book that is rich with examples (my best learning style).
Many thanks...
Todd
Good SQL Book
May 30, 2007hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
NubNub
Good Book For Using DTS?
Aug 23, 2000I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.
Anyone found either a book on DTS or a good section in a book?
Thanks,
Judith
Need A Good Book...
Apr 27, 2004I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!
View 3 Replies View RelatedGood SQL Book?
Jul 20, 2005hello, for a new job i might have to learn SQL. i've neverworked with databases or SQL, so i'll need to learn. cananybody advice me on what would be a good book to learnfrom? i'm quite an experienced programmer, so it doesn'thave to be a dummies guide, and preferably not a bulky booklike the "SQL bible" or something.oh, one of my 'favourite' computer books of all times is"thinking in Java" by bruce eckel, to give you an idea.mike--not sure if there's a better group to ask these questions
View 4 Replies View RelatedI'd Like To Get A Good Book Of SQL...
Apr 20, 2006Would all of you give me a suggestion of valuable book in terms of SQL ??
I confused what kind of SQL book is going to be good for me to study since
I begin to jump into MS-SQL...
Furthermore, I'd know that various level of book as begginer, intermediate , advance...
Thanks for your help in advance..
Web Developer Looking For Good SQL Book
Jan 6, 2007I'm looking to buy a book about SQL, T-SQL, stored procedures, etc. I'm a web developer, so I don't need a book for a SQL Server administrator. I need a book that tells me what I as a developer need to know about SQL. I'm currently using Visual Studio, SQL Server 2005, ASP.NET 2.0, and VB.NET (and fairly new to all of those) if that makes any difference. The bulk of my web developing experience has been with PHP and MySQL so this is new territory for me. I hope all that makes sense. I would appreciate any suggestions for such a book.
Thanks!
-Mathminded
p.s. I bought a bunch of Wrox books and haven't had them long enough to decide if I like them: "Professional ASP.NET 2.0", "Professional ASP.NET 2.0 Security, Membership, and Role Management", "ASP.NET 2.0 Website Programming", and "Visual Basic 2005". I thought I'd check with the experts before investing in another book. :-)
A Good SSIS Book?
Jan 7, 2007I am new to SQL2005 and have been given the task of writing some SSIS packages to import some CSV files.
I need to cleans the data as it is imported from my CSV files before it reaches my SQL DB.
I am currently Googling the internet to discover how to do this.
Can anyone recommend a good SSIS book?
I am a C# developer, so a book that has lots of SSIS C# examples would be good.
Any help appreciated.
Regards,
Paul.
Need A Good Book On Replication????
Jul 31, 2000Anyone has a suggestion on a good book on Replication. How to set it up.. I am looking for a good detailed book on this subject.
View 2 Replies View RelatedA Good Book On SP, Functions
Dec 13, 2007Can anyone recommend a good book on Stored procedure, Functions, triggers ..Etc??
Thank you
Good Book About MS-SQL Replication...
Jul 20, 2005Hi,Does anyone know any good book(s) about MS-SQL, especially aboutReplication - basically, I need in-depth explanation about how tosetup/maintain Snap Shot, Transactional, Merge Replication anddifferent agents - with good examples? Hopefully, the book(s) isrecent enough to cover SQLCE merge replication as well. In-depthinformation about DTS is a plus ^_^Just tired of print hundreds of pages from MSDN site.Thanks,Charlie Chang
View 1 Replies View RelatedLooking For A Good Book On SSIS 2005
Mar 13, 2007Anyone know a good book on SSIS. I need a good beginer book on SSIS 2005 I am very interested in using it for capturing data from other database and loading that data into the database that I'm working on . Weather it be from another database, textfiles, spread sheets. Any suggestion.
View 1 Replies View RelatedAnyone Know Of A Good T-Sql Reference Code Book?
Nov 6, 2003Hi does anyone know of a good book that has all the t-sql keywords and functions in?? Or a webiste that has a printable version with explanations. I knows its on msdn but its very hard to print it all off.
I need something by my side so I can refer too and use in helping me build statements and sp,s etc.
Thanks
Good Book On Sql Admistration And Performance ?
Mar 26, 2001Hello
Would you please point again on good book for admistration
Thanks
Best Book To Gain Good Knowledge In DBA
Feb 26, 2007Dear Friends,
please suggest me the best book to gain sound knowledge in DBA concepts as well as
writing in sub queries, complex queries as well as inner queries.
thank you very much
Vinod
Good Integration Services Book
Apr 3, 2006ive been learning through books online, but i just find learning from a book is better for me. have any of you bought books on integration services and if so , would you recommend them?
View 4 Replies View RelatedReporting Services, Good SQL 2005 Book
Jan 28, 2006What are reporting services? i know asp or something like that, do i have to use asp? or can i use crystal Rpts?
Can anyone offer a good book on SQL Serv 2005?
Sql Server Stored Procedure Book Or Tutorial?
Jul 26, 2005hi,are there any good books or tutorials anyone can recommend to someone who wants to get more into stored proc in sql server? i'm already good with sql, use it everyday at work, but want to start learning more about stored proc, know just a little, how to write simple ones to retrieve and insert/update, but want to get more into them. a book for beginners to advanced, thanks.
View 2 Replies View RelatedProblems Running A Good Stored Procedure As A Job
Dec 13, 1999I wrote a Stored Procedure I wish to run as a job. It inserts data to a linked server. The stored procedure runs fine from the sql query analyzer but fails as a job. There are no permissions assigned to this stored procedure as I beleive it runs under the context of sa which has default access granted.
Can someone give me some insite why this stored procedure won't run as a scheduled job?
ALTER PROCEDURE tsul_insertintolinkedserver
AS
DECLARE @srvname varChar(20)
SELECT @srvname = @@servername
insert into THOMAS.tsnet.dbo.usagelog
select id, tsgroup, account, error, failedpin, type, servername, ipbrowser, cid, logintime, expand , msgspresent, msgslistened, @srvname
from usagelog
where id >
( select max(id) from THOMAS.tsnet.dbo.usagelog
where hostserver = @srvname
)
Thanks in advance-
A Good Insert Record If Non Existant Stored Procedure
May 26, 2004Can anyone spare me a good SP that ....
checks if the record exists - and if so return the identity.
and if the record does not exist
inserts it and returns the identity.
Mine keep flipping up :) so I rather look at someone else and use theirs.
Thanks in advance.
SQL Server 2000 Book Recommendations? Including Good Coverage Of Reporting Services
Jul 23, 2005What up-to-date books on this topic can people here recommend? Thanks.- Bob
View 1 Replies View RelatedStored Procedure - SELECT INSERT Statement - Good Practice?
Jan 9, 2004I would like to have a stored procedure executed once a week via a DTS package. The data I would like inserted into Table_2, which is the table where the DTS is being executed on, comes from a weekly dump from Oracle into a Table_1 via another DTS package.
I would like to only import data since the last import so I was thinking of my logic to be like this:
INSERT INTO Table_2
(Field1, Field2, ... , FieldN)
VALUES (SELECT Field1, Field2, ... , FieldN FROM Table_1 WHERE ThisDate > MAX(Table_2.ThatDate))
Does this make sense? Or do you all suggest a different mannger of accomplishing this?
Book For Store Procedure
Jan 31, 2006Can someone recommend me a good book for coding store procedure?
View 2 Replies View RelatedStored Procedures Book
Aug 10, 2004Can anyone reccomend a good book on Stored Procedures, for beginners or intermediates???
View 5 Replies View RelatedA Good Stored Proc Template - What Are Your Views?
Apr 18, 2008Hi,
I'm curious to know what templates/standards you guys use for T-SQL stored procs. I've been using the following standard:
Code Snippet
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = '<proc name>')
BEGIN
DROP Procedure <proc name>
END
GO
CREATE PROCEDURE <proc name>
@parm1,
@parm2
AS
BEGIN TRANSACTION <transactionName>;
BEGIN TRY
--DO WORK HERE
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION <transactionName>;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION <transactionName>;
ELSE
ROLLBACK TRANSACTION <transactionName>;
GO
If you guys have any advice/critisizm, please post it as I'm constantly looking into bettering this as much as possible.
Regards
Michael
Stored Procs And Source Safe Good Idea?
Sep 25, 2000Hi,
Any pros and cons of putting sprocs into Source Safe?
Thanks,
Judith
Building Query Strings Within Stored Procs - Good Or Evil?
Feb 4, 2008I ran across this technique being used in an application the other day. It seems not a good idea to me. What do you think?
1. The proc builds a basic query, nothing real fancy, into a string variable called @SQL defined as varchar 2000. Depending on the result desired, the group by clause can be one of three different sort orders.
2. The string is executed via EXEC @SQL.
It seems to me that the whole process can eliminate the EXEC and just use some other construct. All the parameters are passed in via the initial call to the stored proc. It also seems that every time this is executed it will result in a new query compile and cache useage, no matter what. Wasteful? Should I take the developers aside and knock heads? I think the app was coded by some folks who were rookies then but may be willing to crack open their code. Or, am I the one that is a rookie?
Thanks for your inputs.
Calling A Stored Procedure Inside Another Stored Procedure (or Nested Stored Procedures)
Nov 1, 2007Hi all - I'm trying to optimized my stored procedures to be a bit easier to maintain, and am sure this is possible, not am very unclear on the syntax to doing this correctly. For example, I have a simple stored procedure that takes a string as a parameter, and returns its resolved index that corresponds to a record in my database. ie
exec dbo.DeriveStatusID 'Created'
returns an int value as 1
(performed by "SELECT statusID FROM statusList WHERE statusName= 'Created')
but I also have a second stored procedure that needs to make reference to this procedure first, in order to resolve an id - ie:
exec dbo.AddProduct_Insert 'widget1'
which currently performs:SET @statusID = (SELECT statusID FROM statusList WHERE statusName='Created')INSERT INTO Products (productname, statusID) VALUES (''widget1', @statusID)
I want to simply the insert to perform (in one sproc):
SET @statusID = EXEC deriveStatusID ('Created')INSERT INTO Products (productname, statusID) VALUES (''widget1', @statusID)
This works fine if I call this stored procedure in code first, then pass it to the second stored procedure, but NOT if it is reference in the second stored procedure directly (I end up with an empty value for @statusID in this example).
My actual "Insert" stored procedures are far more complicated, but I am working towards lightening the business logic in my application ( it shouldn't have to pre-vet the data prior to executing a valid insert).
Hopefully this makes some sense - it doesn't seem right to me that this is impossible, and am fairly sure I'm just missing some simple syntax - can anyone assist?
Calling A Stored Procedure From ADO.NET 2.0-VB 2005 Express: Working With SELECT Statements In The Stored Procedure-4 Errors?
Mar 3, 2008Hi all,
I have 2 sets of sql code in my SQL Server Management Stidio Express (SSMSE):
(1) /////--spTopSixAnalytes.sql--///
USE ssmsExpressDB
GO
CREATE Procedure [dbo].[spTopSixAnalytes]
AS
SET ROWCOUNT 6
SELECT Labtests.Result AS TopSixAnalytes, LabTests.Unit, LabTests.AnalyteName
FROM LabTests
ORDER BY LabTests.Result DESC
GO
(2) /////--spTopSixAnalytesEXEC.sql--//////////////
USE ssmsExpressDB
GO
EXEC spTopSixAnalytes
GO
I executed them and got the following results in SSMSE:
TopSixAnalytes Unit AnalyteName
1 222.10 ug/Kg Acetone
2 220.30 ug/Kg Acetone
3 211.90 ug/Kg Acetone
4 140.30 ug/L Acetone
5 120.70 ug/L Acetone
6 90.70 ug/L Acetone
/////////////////////////////////////////////////////////////////////////////////////////////
Now, I try to use this Stored Procedure in my ADO.NET-VB 2005 Express programming:
//////////////////--spTopSixAnalytes.vb--///////////
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sqlConnection As SqlConnection = New SqlConnection("Data Source = .SQLEXPRESS; Integrated Security = SSPI; Initial Catalog = ssmsExpressDB;")
Dim sqlDataAdapter As SqlDataAdapter = New SqlDataAdaptor("[spTopSixAnalytes]", sqlConnection)
sqlDataAdapter.SelectCommand.Command.Type = CommandType.StoredProcedure
'Pass the name of the DataSet through the overloaded contructor
'of the DataSet class.
Dim dataSet As DataSet ("ssmsExpressDB")
sqlConnection.Open()
sqlDataAdapter.Fill(DataSet)
sqlConnection.Close()
End Sub
End Class
///////////////////////////////////////////////////////////////////////////////////////////
I executed the above code and I got the following 4 errors:
Error #1: Type 'SqlConnection' is not defined (in Form1.vb)
Error #2: Type 'SqlDataAdapter' is not defined (in Form1.vb)
Error #3: Array bounds cannot appear in type specifiers (in Form1.vb)
Error #4: 'DataSet' is not a type and cannot be used as an expression (in Form1)
Please help and advise.
Thanks in advance,
Scott Chang
More Information for you to know:
I have the "ssmsExpressDB" database in the Database Expolorer of VB 2005 Express. But I do not know how to get the SqlConnection and the SqlDataAdapter into the Form1. I do not know how to get the Fill Method implemented properly.
I try to learn "Working with SELECT Statement in a Stored Procedure" for printing the 6 rows that are selected - they are not parameterized.
T-SQL (SS2K8) :: One Stored Procedure Return Data (select Statement) Into Another Stored Procedure
Nov 14, 2014I am new to work on Sql server,
I have One Stored procedure Sp_Process1, it's returns no of columns dynamically.
Now the Question is i wanted to get the "Sp_Process1" procedure return data into Temporary table in another procedure or some thing.
SQL Server 2014 :: Embed Parameter In Name Of Stored Procedure Called From Within Another Stored Procedure?
Jan 29, 2015I have some code that I need to run every quarter. I have many that are similar to this one so I wanted to input two parameters rather than searching and replacing the values. I have another stored procedure that's executed from this one that I will also parameter-ize. The problem I'm having is in embedding a parameter in the name of the called procedure (exec statement at the end of the code). I tried it as I'm showing and it errored. I tried googling but I couldn't find anything related to this. Maybe I just don't have the right keywords. what is the syntax?
CREATE PROCEDURE [dbo].[runDMQ3_2014LDLComplete]
@QQ_YYYY char(7),
@YYYYQQ char(8)
AS
begin
SET NOCOUNT ON;
select [provider group],provider, NPI, [01-Total Patients with DM], [02-Total DM Patients with LDL],
[Code] ....
Connect To Oracle Stored Procedure From SQL Server Stored Procedure...and Vice Versa.
Sep 19, 2006I have a requirement to execute an Oracle procedure from within an SQL Server procedure and vice versa.
How do I do that? Articles, code samples, etc???