Can anyone suggest me any resources, web sites where I can learn and find examples of advanced t-sql scenarios? I am using sql server 2000 and 2005.
122501
These sites are great learning resources.\n\n\nhttp://www.softwaretrainingtutorials.com/ms-transact-sql.php
60916
SQL Server allows remote applications and users to connect using TCP/IP (internet), you can install it on a remote server and configure it to listen to a particular port, on the other hand you can use its built in XML handling capabilities too.\nIn first situation you have to utilize CORBA for RPC calls to retrive/store data to and from SQL Server, in 2nd situation you can use Java http package to load and send xml data.
408859
Your probably would have to have SQL, but even that would not be enough. You'd need a log viewer as well.
485278
It's very easy if you build a stored procedure to get the output like that .\nStored Procedure is created to handle all complex query and the most impossible query, so always find the alternative in Stored Procedure if you ever get stuck with your query.\n\nin stored procedure :\n- make a loop query : 'Select distinct ID1, ID2 from myTable'\n- and in the loop, make query like : 'Select GUID from myTable where ID1=:ID1 and ID2=:ID2 order by GUID rows 1' \n\nthis stored procedure is for Interbase/firebird structure :\nCREATE PROCEDURE WEIRD_QUERY\nReturns\n( \n ID1 integer,\n ID2 integer,\n GUID varchar(30)\n)\nas\nbegin\n  For\n  Select distinct ID1, ID2 from myTable into ID1, ID2 \n    do begin\n       Select GUID from myTable\n       where ID1=:ID1 and ID2=:ID2 order by GUID rows 1\n       into GUID \n       end\n   suspend;\nend;\n\nNotes :\n- Rows 1 is to limit our query result,  in mySql 'rows' is 'Limit' \n- suspend is a loop query\n\ntry to convert my stored procedure structure to your Microsoft Sql Server structure\nor\nyou can keep searching the way to build your query without using stored procedure.\n\nsorry, this is the best i can help.
69465
I've not done shelling from SQL (we do scheduled jobs via task scheduler), but simply prefixing 'http://' will shell the browser.\n\nHowever, if what you are trying to do is get SQL to do a parameterized call to a web server, I really can't recommend this approach. A web browser needs a user context, and has a fair bit of overhead.\n\nUsing the new SQL 2005, you could write a .NET DLL that sends a WebRequest, and then register the DLL as a .NET stored procedure. Then just call the SP. You won't need a user context, and it won't do end-user style threading, it will run in-process.\n\nOtherwise, keep SQL Server out of the Http request business. It really shouldn't be doing that anyway. That's a middle tier task if I've ever seen it.
226200
SQL Server 7.0 vs MSDE 1.0\n\nhttp://www.mssqlcity.com/Articles/Compare/SQLvsMSDE.htm\n\nread it v good
360889
Both SQL Server and Oracle are Relational Database Management Systems. Microsoft Access is not; it is run by a jet engine instead.\n\nMicrosoft created Access in an attempt to compete with FoxPro (a product similar to Access). When Access failed to do compete with FoxPro, Microsoft bought the FoxPro company.\n\nNow for the Oracle and SQL Server, both are Relational Database Management Systems. A Relational Database Management System is capable of supporting concurrency (concurrent access to data), transactions (ablity to excute queries as an atomic block with rollback capability) so it can handle more concurrent users and it is for sure more reliable in a multiuser environment.\n\nIt is very hard to say which (Oracle or SQL Server) is better because there are so many factors that have to be taken into consideration, however SQL Server enjoyes a remarkable growth rate because it is easier to use and more cost-effective than the competing enterprise Database systems like Oracle and IBM DB2. Of course oracle and IBM DB2 have been entrenched in the enterprise for some time now , unlike SQL Server.\n\nOne last point. You can use any of the above products to handle 1000 records, However since you are still learning about Database programming, I suggest you learn either SQL Server or Oracle so that you learn some Database programming concepts like the use of Database objects such as stored procedures, triggers, transactions and so on.
524556
The problem is that Microsoft Access, as I am sure you are aware, is very limited in its use. It is great for hobby projects, and small applications, but for commercial applications, you hit the wall very quickly.\n\nIn MS-Access 2003, a 7-table join is the upper limit. If you want to join more tables in a query, then you have to rethink your design - or denormalise the database, which defeats the purpose of proper design in the first place.\n\nI have written a medium-sized commercial application in MS-Access, but I stretched the limits of what MS-Access could handle, in almost every way imaginable, and I would never want to build a career in programming MS-Access :-)\n\nMy suggestion is therefore... Since you know MS-Access, sell yourself as a VB developer - it should take little time to bring yourself up to speed on the differences in Basic dialects, and you end up with a more robust platform. You could also go for C# or another .Net language.\n\nGood luck :-)
614032
Hi, \n\nOk your question is a little open ended, but here's the general principle. \nYour website has asp on it, so that is the first hurdle. The question you need to ask who ever provides your web space, is whether they can provide a database as well, it'll will either be MySQL, SQL Server, or support Access databases. More than likely it's SQL server if your site has asp on it. The next bit is the tricky bit. You'll need to put the access database containing the stock levels either on the web server where your website is, or by transferring the data to a database your isp provides.\n\nThe next bit is the easier bit ;) . You'll need to write some asp pages to query the database and display the results, which isn't as difficult as it sounds. That's pretty much it. \n\nThere's a load of books about creating dynamic data driven websites on Amazon... get one that will go through all the concepts from easy bits to the end...!
419125
There is a lot of useful information on ADO and Delphi here:\nhttp://delphi.about.com/od/database/\n\nThis might be of some use - sorry I can't help more, despite being a Delphi buff I don't know much about database connectivity.\n\nRawlyn.
321015
Visual FoxPro 6 offers two techniques:\n\nRemote Views which allow you to treat a back-end table as though it were a VFP table\n\nSQL Pass-through which lets you send SQL commands tobe processed on the server.\n\nWhich of these were you planning to use? There is a lot of information on both in VFP Help and on MSDN.
469026
Well the easiest way is to use a straight out SQL method in access. Its not that a SQL method is hard but is just how you access the information in a table. Below is a link to a page which shows you a great straight forward example of using a few nested select statements or if you want to create an intermediate table to hold the results, that example is there too.\n\nHope this doesn't confuse you too much, but really if you take a look at it, you will find it makes sense. Just read it out loud.\n\nGood luck!
135087
SQL Server doesn't support multithreading in the way you're describing it. However, it does have a performance enhancing tuner:\n\nhttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx
199056
Use some .net sites to study .net.from the sites u can get started with the basic conceptsgradually U can go through the detaled section also.from the sites u will get sample projects  in bothe vb.net and C#.As u have the vb background it is better to start with vb.net.\npls check the following sites\n\nwww.asp.net\nwww.mocrosoft.com\nwww.C#friends.com\nhttp://www.dotnet247.com/247reference/msgs/13/67679.aspx\nhttp://www.geocities.com/uttoransen4/... \n\nU will get the sample project with full code and Databse from the StarterKits\nhttp://msdn.microsoft.com/vstudio/downloads/starterkits/\n\nTo study SQL first u should study the SQl statements.\nhttp://www.microsoft.com/sql/default.mspx\nwww.sqlservercentral.com/
643624
Read this short review:\nhttp://en.wikipedia.org/wiki/DBMS
659881
In a word: yes\n\nif you have an familiarity with ms-sql 2000 using the built in reporting services, and as you're familiar with crystal reports, you'll discover that the reporting services within ms-sql 2005 with the included reporting services has quite a few more features.\n\nRealize though that the reporting server/services defaults to C# pages; so there isn't really much of a difference; as you'll be dealing with a programming language of some sort, rather than having the actual database perform the functions which will create the reports...\n\nif i may suggest.\n\nAs you're already using stored procedures, why not expand the power of sql (as long as the flavour is at least 2k SP2), and have it create the reports directly with a few triggers defined by the dynamic pages in whatever flavour language you prefer?\n\nThe reporting server/services when installed, generates a slew of directories, pages, and control (behind code pages) defaulting to C# asp.NET 2.0 pages.\n\nif you are curious, i recommend downloading MS-SQL 2005 Express and install it. You'll be able to apply it to any website located currently within your development/staging environment and test it directly without interfering with your currently deployed applications.\n\nPersonally if it were me. I'd likely avoid the management of a database conversion of parameter values via a scripting language, and just have the database do what it's meant to do. After all, most dbase enterprise systems have intergrated capabilities to produce reports in a variety of methods (w/ my preference being xml/xsl display, leaving me the option to display within any environment in any codebase).
564235
how about creating a dynamicly driven website with SQL engine.  Where you can add stuff and easily search it in the search bar.  That would be a good one for you.