Formatted ASCII Results from a SELECT

Generate aligned output from SELECT statement for code comments using a simple stored procedure.

The mysteries of life, the beginning of the 20th century

ASCII Character Groups in String

Powerful function to find strings containing or excluding classes of ASCII characters.

convert string to ascii values

print every ascii value from a string

Finding whitespace in a specific column

A quick way to check a targeted column for whitespace.

RE: SP_ExecuteSQL

That's what I want to do, as per an example in the BOL:DECLARE @IntVariable INT DECLARE @SQLString NVARCHAR(500) DECLARE @ParmDefinition NVARCHAR(500)/* Build the SQL string once.*/ SET @SQLString =      N'SELECT * FROM pubs.dbo.employee WHERE job_lvl = @level' SET @ParmDefinition = N'@level tinyint' /* Execute the string with the first parameter value. */ SET @IntVariable […]

RE: Date Format

This may just be academic, but..Remember that when you talk about the "format" of a date/time value, you're strictly talking about presentation.  No matter how the date/time is represented, the actual datetime datatype is stored as two numbers that specify the number of days since Jan 1, 1900 and the number of milliseconds since midnight.As has already been […]

RE: Divide By Zero Error in WHERE Clause

Ah, my bad. Didn't read the question close enough... In that case, select CASE field2 WHEN 0 THEN 0 ELSE (field1 / field2) END + ( other calcs ) FROM .... should do just as required.. /Kenneth

RE: Free space in Data file

Dear friends, I am clear now. Thanks to all of U Anil

RE: Stored Procedure and parameters

if u have too many params and u want to bulid a sql statment according to the data in it u can try sp_sqlexcute or exec() by using this u can exec string and get output .