User Defined Data Types In SQL Server
by Srikanth Gupta4/29/2011
User defined data types is useful to maintain the data type consistency in the database design. For example Phone Number is a field in sever...Read More >>
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
How to truncate table which is being referenced by a FOREIGN KEY constraint?
by Srikanth Gupta8/27/2010
DELETE FROM [table name]; DBCC CHECKIDENT([table name],RESEED,0);Read More >>
Retrieving SQL select table rows as a single row comma separated
by Srikanth Gupta8/25/2010
Try Following Query to retrieving SQL select table rows as a single row comma separated. DECLARE @vResult VARCHAR(MAX) SELECT @vResult =...Read More >>
Subscribe to:
Posts
(
Atom
)