Tips

Tips

• Word wrapping with T-SQL

  If there isn't a suitable front end that can perform the word wrapping task, it can done by SQL Server. Here's how.  Continue Reading

• Integrate mainframe transactions with Visual Studio

  This VS add-in makes it incredibly easy to integrate mainframe functionality into Windows computers.  Continue Reading

• How to use a SQL query to document your database

  Here's how to use a single SQL query to document your SQL Server database.  Continue Reading

• Basic ADO.NET operations

  Code and instruuction on the common database tasks of Insert, Update and Delete in ADO.NET.  Continue Reading

• The low down on the DropDownList control

  Overview of the control, how to use it and how to get data into it.  Continue Reading

• The VB DOMDocument class

  Discussion of the class.  Continue Reading

• How to decrypt encrypted stored procedures

  Here is a stored procedure used to decrypt compiled T-SQL stored procedures.  Continue Reading

• Returning a result set in random order

  At times you might need to return the SQL Server data to the client in a random order. Here's how.  Continue Reading

• How to use Visual Basic .NET to create a Web service

  This tip shows how to implement a Web service server and client and some of the object-oriented programming issues in designing a Visual Basic .NET application.  Continue Reading

• Kill the blocking connections

  This stored procedure will kill the blockers that have not issued a database command in the specified number of seconds.  Continue Reading

• How many records in each table?

  Easily find number of records in each table in a SQL Server database  Continue Reading

• Join the results of a stored procedure in T-SQL

  There may be instances where you have to join the results of a stored procedure with another query. Here's how to do it.  Continue Reading

• SQL query: That pesky apostrophe

  Our tip about substituting for apostrophes in SQL input provoked a storm of responses. Most of them said that we should have just used the Replace function instead. So in the spirit of community building, we offer these folks' responses as this ...  Continue Reading

• Write to Excel from VB

  This tip shows how to write to Microsoft Excel from Visual Basic.  Continue Reading

• Skills Assessment on your Resume

  How to depict skills assessment on your resume.  Continue Reading

• The With...End With statement

  This tip covers the With...End With statement in Visual Basic.  Continue Reading