2013年03月__iorilan

12月 11月 10月 09月 08月 07月 06月 05月 03月 02月 01月

原创 powershell seach const variable

##search const1>.declare some const , save to E:\1.txtpublic const string a = "1";public const string b = "2";public const string c = "3";public const string d = "4";2>.save co

2013-03-29 23:30:04 1547

原创 powershell connect sql server

#power shell connect sql server and retrieve data$SQLServer = "qs-pc" #use Server\Instance for named SQL instances! $SQLDBName = "GasStation"$SqlQuery = "select * from Station" $SqlConne

2013-03-29 23:27:40 1472

原创 powershell basic

#powershell bisic ##set execution policya>Set-ExecutionPolicy RemoteSignedb>get-executionpolicy##powershell array$arr = @()$arr+= 1;$arr+= 2;$arr+= 3;$arr##ha

2013-03-29 23:26:29 1556

原创 Create Job in Sql server

step 1: Enable Sql server Agent Servicestep 2 : Start Sql Server , you will see the Agent step 3: right click "jobs" folder ,add new job give a name to the job . step 4 : add your

2013-03-22 14:47:22 1597

原创 how to execute sql script in c#

A . Creating a Visual C# SMO project in Visual Studio.NETStart Visual Studio 2008 (or Visual Studio 2005).On the File menu, click New Project. The New Project dialog box appears.

2013-03-09 22:31:02 1704

原创 get table names and table columns from db

private const string SqlGetAllTables = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' "; private string SqlGetAllColumns = "SELECT COLUMN_NAME,DATA_TYPE

2013-03-09 22:28:31 1307