Total Pageviews
Saturday, September 28, 2013
Wednesday, February 20, 2013
Reseeding a SQL Server Table
Indentity column will be reset to the value specified.
DBCC CHECKIDENT (tablename, RESEED, 5)
DBCC CHECKIDENT (tablename, RESEED, 5)
Sunday, January 20, 2013
Validating upload control for file extentions
Regular expression ="^.+(.doc|.DOC|.docx|.DOCX|.txt|.TXT|.pdf|.PDF)$"
Sunday, January 13, 2013
Finding column name on SQL Server database
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%DocumentID%'
ORDER BY schema_name, table_name;
Subscribe to:
Posts (Atom)