This is a simple stored procedure, for inclusion in your script writing efforts, that strips non-numeric data from a given varchar. This is most usefull in scripts used to clean-up data such as account numbers that may include spaces, dashes and the like.
2004-09-21
328 reads
To help maintain index quality, defragging of any given index is a good thing. This will defrag ALL indecies in the current DB. NOTE: Schedule for off-hours operations. For a massive re-write of indecies, change the remarking on "--IF @indid" lines to use reindex instead of just defragging.
2004-09-21
584 reads
Simple enough routine that I've had to write I don't know how many times in different languages. It does what it says in the title i.e. kills multiple occurences of the whitespace character, leaving one behind to tell the tale.
2004-09-20 (first published: 2004-05-21)
145 reads
Given SQL text (@sql_txt) that will return XML data, run that XML data against an XSL template (@xsl_file_nm), and save the output to the specified outputfile (@out_file_nm). If @xsl_file_nm is not specified, then output is just saved as XML.This script is very usefull, but not secure. One could easily overload any of the script input […]
2004-09-17
302 reads
This Simple Function Let u get the Word Format From Numeric Value. Its just like NumericToWord Function in some prog. Languages.Just Copy and Paste it in SQL Query Analyzer and build it.Your Views are always welcomed at mayursid@yahoo.co.in
2004-09-17
114 reads
sp_BulkExport:Export Data from TSQL without using xp_cmdshell - uses SQLDMO and sp_OA*. Supports a variety of formats and options. In my testing on a 22 million-row table it is NOT as fast as BCP. This is the first rev of the proc and it has not been thoroughly tested.
2004-09-16 (first published: 2004-06-25)
948 reads
This Script is used to validate the given string is password complince(i.e Strong Password) or not.Allows [A-Z] or [a-z] or [0-9] or [,(,~,!,@,$,%,*,{,},?,),].String need to have one character, 1 number and 1 specified special character.
2004-09-16
570 reads
A procedure and a function doing the same thing are posted.
2004-09-16
171 reads
The level of index fragmentation is not taken into consideration. Actual level of fragmentation is assume to be proportionnal over time.Only one object can be used as the witness to drive the database size.A normally distributed database is needed for this tool to report accurate estimates. ** Example : dbo.sp__EstimateSize @UpdateUsage = true ,@ObjGuidance = […]
2004-09-16
276 reads
This is a modification of Database Data Dictionary by rsellers at http://www.sqlservercentral.com/scripts/contributions/895.asp.Two procedures to help maintain field definitionsvp_DatabaseDictionary lists the columns grouped by ColumnName, Type, and Length.DatabaseSchemaByColumn is a variation of rsellers procedure in that it takes a column name as an input.Usage: execute vp_DatabaseDictionary you may find that you have several fields of the […]
2004-09-15 (first published: 2004-06-20)
366 reads
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers