Generate excel-html file
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-02-12
459 reads
Scripts
Global Database Field Search
Search all text fields in a database for a literal string.Outputs SQL statements to query analyser window, which can then be run in a new window.
2004-02-10
229 reads
Global String Search & Replace In All DB Fields
Stored procedure to search every field in the database for a string literal. Run the stored procedure in Query analyser, which will output sql statements to do the search. The output of these searches will be the update sql, which again should be pasted into a query analyser window. As the stored procedures do not […]
2004-02-10
289 reads
SQL Server Log Reader
This script outputs the data in chronological order from the current SQL Server log.Output columns are: Log Entry Time, Event Source, Log Entry Text. This data matches with the data that can be seen under the SQL Server logs view in Enterprise Manager.The script is stand alone, but could easily be parameterised to work as […]
2004-02-10
912 reads
generate excel-html file
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation.
2004-02-08
564 reads
XTAB - CROSSTAB UTILITY
sp_XTAB (prototype) produces pivoted (crosstab) views/output with a minimum of fuss.No messing with code, just tell XTAB what you want to pivot.Tested to 764 pivoted columns, XTAB can generate up to 63000 characters of dynamic sql. Example (deliberately over-simplified)----------------------updated 27 January 2004Use NorthwindEXEC sp_XTAB 'Northwind','xtEMPL_COUNTRY','Orders','EmployeeID','ShipCountry', '', 'OrderID','COUNT','NULL', '', 'SELECT xtEMPL_COUNTRY.* FROM xtEMPL_COUNTRY' -- Include optional […]
2004-01-24
428 reads
Check if IP address is in private IP range
Function to allow for checking if an IP address is a private IP address. Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address.Requires function IPStringToNumber which is included in the post
2004-01-23
1,377 reads
Foreign Key DDL wizard
This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database. This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP. It will then generate, and execute, all […]
2004-01-22
308 reads
2004-01-22
434 reads
T-SQL UDF to test for 'File In Use' ect.
Useful for testing if file is available for manipulation prior to trying to "process" it.From forum thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19344Thought I may as well add it to the Scripts Library.
2004-01-16
343 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
Alamat Telp BCA KCP Kenten (+62) 838-4945-0961
Wa:083849450961 Jl. MP. Mangkunegara Jl. Villa Kenten No.20-21, 8 Ilir, Kec. Ilir Tim. II,...
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers