Need to Transform a table with Summaries to be plugged into EXCEL or place a table of info in one row. This is cool and has been a real time saver!!! Simply save as a Template file in your favorite template folder. In Query Analyzer go to Menu Tools... Options... General... Note the path of […]
2002-04-26
1,834 reads
Script showing how to count the number of Yes /No answers in the string Inspired by tip that didn't work on Microsoft website
2002-04-26
560 reads
This procedure will be useful for developers/ database designers / DBAs to find the rowlength instantly.To find the row length of a user table, just copy this script into Query analyser and pass the table name for which you want to find the rowlength. @TabName is the table name parameter, if we donot provide this […]
2002-04-25
2,930 reads
Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.
2002-04-25
960 reads
Detect SQL Server Instance(s) using reg.exe from the resource kit, just pass the host name! (and make sure reg.exe from the resouce kit is in the ../tools/bin directory. SS2k Only.Enjoy!
2002-04-23
1,100 reads
How about getting the data when the table data is first queried? The following script checks to see if the specified table (@MyTable) has been updated today. If so, just return the data found. If not, then get the data from a "fresher source". Great for ASP that performs table reporting and needs "baked daily" […]
2002-04-23
1,569 reads
This function provides easy email address creation from employee's LastName, First name.Enjoy!!
2002-04-23
1,342 reads
This script will show how quickly update records in one table with information from another or insert records if they are completely new.
2002-04-23
2,230 reads
This procedure will generate a delete stored procedure against a provided table and column name in your database. It will search for foriegn key constraints and create a delete statement for each one found in the database. The procedure has three parameters:@table_name nvarchar(128) = the name of the source table@column_name nvarchar(128) = the name of […]
2002-04-22
301 reads
Need a quick way to list shared folders? Do it in one call. Great for ASP page popups and user drop-down lists.Let's say that you want to display a list of projects, just call usp_GET_ProjectFolder and VIOLA! Only works with 2k; however, can be ported to ss7 if the udf is ported to a proc […]
2002-04-22
368 reads
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
Comments posted to this topic are about the item Collecting Data Is Hard
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers