Introduction:SQL Server 7.0 introduced a new class of functions that return a wide range of property information that isn't readily available in SQL Server 6.5 and earlier versions. These functions have three general classes: TypeProperty, which returns information about a data type; ObjectProperty, which returns information about objects in the current database; and ColumnProperty, which […]
2002-07-19
144 reads
2002-07-19
581 reads
This script will provide the first four values required for estimating the size of a database table. It will satisfy steps one and two in MS estimation process for the amount of space required to store the data in a MS SQL Server v7.0 or v2000 table:1 Specify the number of rows present in the […]
2002-07-19
505 reads
Copy and paste this script into Query Analyzer and run it.Use this script to generate a simple security string of 0's and 1's.
2002-07-19
390 reads
Lists objects from database. Similar to 'dir' command from DOS 🙂Typical usage sp_dir 't' 'order*', 1 - returns list of all tables whose name start with 'order' plus their columns and data typessp_dir 'p' 'custom*_sp' - returns list of all stored procedures whose name start with 'custom' and end up with '_sp'For list of […]
2002-07-19
499 reads
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
925 reads
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
714 reads
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
776 reads
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
1,019 reads
there are 2 extended STORED PROCEDURES xp_dirtree will get the directory name and nesting level from a given parameter root directory xp_subdirs will get the directories list in the first sub level from a given parameter root directory
2002-07-18
921 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...
WhatsApp:083179431313 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa Timur 66217
WhatsApp:083179431313 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik, Jawa Timur...
WhatsApp:083179431313 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
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