Works faster than sp_help on retrieving of object's information.
Usage:
sp_desc object_name.
e.g :
brideweserk,
2008-09-10 (first published: 2008-07-12)
Works faster than sp_help on retrieving of object's information.
sp_desc object_name.
e.g :
DROP PROCEDURE sp_desc GO CREATE PROCEDURE sp_desc @objname VARCHAR(256) AS DECLARE @a VARCHAR(256),@b VARCHAR(120),@ss VARCHAR(256),@owner VARCHAR(64); SELECT @a=v.name,@b=v.type_desc,@ss=ss.name,@owner=sp.name FROM sys.all_objects v JOIN sys.schemas ss on v.schema_id=ss.schema_id JOIN sys.database_principals sp on ss.principal_id=sp.principal_id WHERE v.name=@objname SELECT @a AS object_name,@b AS object_type,@ss as schema_name,@owner as owner; SELECT c.name AS field_name,st.name [type],c.max_length [length],c.collation_name FROM sys.all_objects v JOIN sys.all_columns c ON v.object_id=c.object_id JOIN sys.types st ON c.user_type_id=st.user_type_id WHERE v.name=@objname go
For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.
2003-01-13
18,069 reads
Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer.
2002-06-28
4,567 reads
This article demonstrates how to store checkbox results as integers in a database...perfect for surveys!
2002-06-27
4,427 reads
This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
5,990 reads