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
461 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
291 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
429 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,383 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
309 reads
2004-01-22
435 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
344 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers