sqlserver写程序,sqlserver写sql语句
C#如何编写一段程序，能控制SqlServer数据库服务重启？
public string RunDosCommand(string command)
成都创新互联是一家网站设计公司，集创意、互联网应用、软件技术为一体的创意网站建设服务商，主营产品：成都响应式网站建设公司、成都品牌网站建设、营销型网站建设。我们专注企业品牌在网站中的整体树立，网络互动的体验，以及在手机等移动端的优质呈现。成都网站建设、网站制作、移动互联产品、网络运营、VI设计、云产品.运维为核心业务。为用户提供一站式解决方案，我们深知市场的竞争激烈，认真对待每位客户，为客户提供赏析悦目的作品，网站的价值服务。
{
Process process = new Process();
process.StartInfo.FileName = "cmd.exe";
process.StartInfo.UseShellExecute = false;
process.StartInfo.RedirectStandardInput = true;
process.StartInfo.RedirectStandardOutput = true;
process.StartInfo.RedirectStandardError = true;
process.StartInfo.CreateNoWindow = true;
process.Start();
process.StandardInput.WriteLine(command);
process.StandardInput.WriteLine("exit");
return process.StandardOutput.ReadToEnd();
}
command 参数可以输入如
net start mssqlserver
net stop mssqlserver
编写一个SQLSERVER 存储过程
代码是最好的文字，不多说，请看我的代码，并给分，呵呵。
--step1. 建表
if exists(select * from sysobjects where id=object_id('student') and objectproperty(id,'IsTable')=1)
drop table student
go
create table student
(
id int identity(100,10) not null
,sname varchar(10) not null
,sno varchar(30) not null
)
go
--step2.建存储过程
if exists(select * from sysobjects where id=object_id('proc_demo') and objectproperty(id,'IsProcedure')=1)
drop procedure proc_demo
go
create procedure proc_demo
@o_maxid int output
as
set nocount on
--如果希望大小写敏感，使用第一句，因为SQL Server默认是大小写不敏感的
--update student set sno='cay_'+sno where ascii(substring(sname,1,1))=87 and ascii(substring(sname,2,1))=65 and sno not like 'cay_%'
update student set sno='cay_'+sno where sname like 'WA%' and sno not like 'cay_%'
print convert(varchar(10),@@rowcount)+'条记录符合条件并被处理'
select @o_maxid=max(id) from student where id=100
if(@o_maxid is null) print '没有找到符合条件的最大记录'
set nocount off
go
--测试数据1
truncate table student
set identity_insert student on
insert into student(id,sname,sno)values(1,'WA1','1');
insert into student(id,sname,sno)values(2,'wa2','2');
insert into student(id,sname,sno)values(3,'3','3');
set identity_insert student off
go
--测试数据2
truncate table student
insert into student(sname,sno)values('WA1','1');
insert into student(sname,sno)values('wa2','2');
insert into student(sname,sno)values('3','3');
go
--测试过程
declare @maxid int
exec proc_demo @maxid out
print '最大id是'+convert(varchar(10),@maxid)
go
帮我写个分页的程序?(c# Sqlserver)
%@ Import Namespace="System.Data"%
br%@ Import Namespace="System.Data.SqlClient" %
brscript language="C#" runat="server"
brvoid Page_load()
br{
brif (!IsPostBack)
br{
brstring strConnection = "server=127.0.0.1;";
brstrConnection += "database=ztx;uid=sa;password=wxj;";
brSqlConnection sqlConnection1 = new SqlConnection(strConnection);
brstring strSql = "select top 20 i_id,i_caption,i_count,substring(i_content,1,20) as i_content from content";
brSqlDataAdapter sqlAdapter = new SqlDataAdapter(strSql, sqlConnection1);
brDataSet objDataSet = new DataSet();
brsqlAdapter.Fill(objDataSet);
brViewState["objDataSet"]=objDataSet
brbind();
br}
br}
br
brprotected void abc(object source, DataGridPageChangedEventArgs e)
br{
br
brzhangtianxing.CurrentPageIndex = e.NewPageIndex;
brbind();
br}
br
br protected void button1(object sender, EventArgs e)
br {
br zhangtianxing.CurrentPageIndex += 1;
br bind();
br }
br private void bind()
br {
br DataSet objDataSet = (DataSet)ViewState["objDataSet"];
br zhangtianxing.DataSource = objDataSet;
br zhangtianxing.DataBind();
br }
br/script
brhtml
brhead
brtitle中国新闻搜索中心/title
br/head
brbody
br
brform id="Form1" runat="server"
brtabletrtdasp:datagrid ID="zhangtianxing" runat="server" AllowPaging="True" PageSize="3" / /td/trTrtd
brasp:LinkButton OnClick="button1" ID="LinkButton1" runat="server"LinkButton/asp:LinkButton /td/tr/table
br/form
br/body
br/html
用 delphi写个程序把SQLserver一个表中的数据逐行写入txt文件
方法比较多，就说两种先
var i,j:Integer;
s:string;
myfile:textfile;
begin
with query1 do
begin
close;
sql.clear;
sql.add('select * from sb_fcs');
open;
end;
AssignFile(myfile,'d:\2.txt');
Rewrite(myfile);
try
for i:=0 to query1.recordcount-1 do
begin
for j:=0 to query1.FieldCount-1 do
BEGIN
s:=query1.fields[j].name+':'+query1.fields[i].asstring+',';
writeln(myfile,s);//myfile 为要写的txt文件
end;
query1.next;
end;
finally CloseFile(myfile);
END;
end;
方法二：
s1:string;
s:tstringlist;
with query1 do
begin
s1:='';
for i:=0 to fieldcount-1 do s1:=s1+fields[i].asstring+' ';
s.add(s1);
循环读入
next;
end;
s.savetofile('c:\a.txt');
新闻名称：sqlserver写程序,sqlserver写sql语句
本文路径：http://cdiso.cn/article/hdijch.html
