SQL Script To Find For A Particular Column In A Database
This small script help u to find the column exists in the list of tables in a database.
2008-10-17
910 reads
Scripts
The Ultimate Duplicate Index Finder
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
2008-10-17 (first published: 2008-08-01)
3,346 reads
2008-10-16 (first published: 2008-08-12)
1,469 reads
Linked Server Dependencies
This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.
2008-10-15 (first published: 2008-09-05)
1,859 reads
Delimited String Parsing Functions - 2D set
Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-14 (first published: 2008-08-05)
1,056 reads
Create Sample Data Script
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
748 reads
2008-10-10 (first published: 2008-07-20)
1,903 reads
Demonstration on how to pivot data using temp tables
This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for 🙂
2008-10-10
1,058 reads
The Ultimate Index Lister (Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.
2008-10-09 (first published: 2008-08-01)
2,506 reads
Create Role for specific set of Objects based on a set of Conditions.
This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
2008-10-08 (first published: 2008-07-23)
1,330 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Bonjour à tous, La semaine dernière, nous avons effectué une mise à niveau de...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers