Comparing data type of sql server and ms access in c#

		Jet Engine (Access)	Sql-Server	C#
		Text	char, nchar, varchar, nvarchar	string
		Memo	text, ntext, the above with len>255	string
		Byte	tinyint	byte
		Integer	smallint	short
		Long Integer	integer (int)	int
		Single	real	float
		Double	float	double
		Replication ID	float	Guid
		Decimal	decimal	decimal
		Date/Time	smalldatetime, datetime, datetime2	DateTime
		Binary     (8 bytes)	timestamp, rowversion (Since V2008)	byte[]    (8 bytes)
		Currency	smallmoney, money	decimal
		AutoNumber	int + identity property	int
		Yes/No	bit	bool
		OLE Object	image	byte[]
		Hyperlink	<no equivalent>	string
		<no equivalent>	binary, varbinary	byte[]

Delete All File in Folder from "*.bak" Format File

Method 1:

DECLARE @DateString CHAR(8)

SET @DateString = '04/10/2014'

EXECUTE master.dbo.xp_delete_file 0,  N'E:\10-04-2014\',N'bak',@DateString, 1

 
Method 2:


EXEC sp_configure 'show advanced options', 1
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

EXECUTE master.dbo.xp_cmdshell  'del E:\10-04-2014\Test_db.bak'

Create Folder

EXEC master.dbo.xp_create_subdir '<path>'

Ex: EXEC master.dbo.xp_create_subdir 'E:\10-04-2014\'

How to list files inside a folder with SQL Server

EXEC xp_dirtree '<path>', 10, 1

EX: EXEC xp_dirtree 'E:\10-04-2014\', 10, 1

Get All Sup dir in folder

EXEC master.sys.xp_subdirs 'e:\\'

EXEC master.sys.xp_dirtree 'E:\',1,1;

Current database schema, table name, Column name, data type, max length

Current database schema, table name, Column name, data type, max length, precision, scale, is_nullable, is_ansi_padded

SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema], 
        T.[name] AS [table_name], AC.[name] AS [column_name], 
        TY.[name] AS system_data_type, AC.[max_length],
        AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded]
FROM sys.[tables] AS T 
  INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id]
 INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id] 
WHERE T.[is_ms_shipped] = 0
ORDER BY T.[name], AC.[column_id]

sql reset id column

  How To: Reset Identity column in SQL Server

Deleted all the existing records

DBCC CHECKIDENT ('TableName', reseed, 0)