Toad for SQL Server on USB

I use this tool to connect to sql server. It works without any kind of install on the client computer. Its similar to ms sql querry analyzer. Attached image shows how to connect to the server etc. Download Toad. More USB Tools Links.

Comments

Post a Comment

Popular posts from this blog

SQL 2008

SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. more
Read more

ARRAY In SQL Server 2000

Image
On a number of occasions that I have regretted the fact that there is no such thing as Array in Microsoft SQL Server's Transact-SQL. Lots of other SQL programmers would mention the same thing. The array is one of the most common and highly used programming structures. Indeed, T-SQL does not provide for the fully functional array structure. However, SQL 2000 introduced the new feature called a variable of type table, which allows for mimicking an array and/or using it instead of SQL Server cursor. It can be a challenge to pass such a list of values to a stored procedure. In earlier times I had been using so called composite queries, or dynamic SQL. It includes putting together a string to be compiled and executed using EXECUTE statement. For example: CREATE PROCEDURE CustomerByRegion @List varchar(100) AS declare @sql varchar(1000) set @sql = 'select * from Customers where Region IN (' + @List + ')' execute (@sql) -- call procedure declare @List varchar(100) set ...
Read more

Microsoft a BI Force

Image
Microsoft BI is a new tool. It is delivered through three layers or workloads: data warehousing, reporting and analysis, and performance management. These are designed to provide a consolidated, comprehensive data source and tools to help improve decision making. Microsoft BI is to help decision makers at all levels. An IDC report issued this summer—found that Microsoft’s BI market share growth outpaced that of most rivals. More to the point, both Gartner and IDC now agree: Microsoft is now a BI force to be reckoned with, trailing established leaders such as Business Objects SA, SAS Institute Inc., and Cognos Inc. for overall BI market laurels. more
Read more