¸öÈË×ܽáµÄ¼¸Ìõ±È½ÏÓÐÒâ˼µÄsqlÓï¾ä
--------------------------------------------------------------------
-- ×÷ÕߣºÕŰ®¹ú
-- ÈÕÆÚ£º2010-01-23 15:00:17
-- ÃèÊö: һЩ±È½ÏÓÐÒâ˼µÄSQLÓï¾ä
-- Version:
-- Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
-- Feb 9 2007 22:47:07
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
--------------------------------------------------------------------
--Ê×ÏÈ´´½¨Ò»¸ö²âÊÔÓõıí
--Ò»ÏÂÓï¾äÖÐÓõ½µÄ±ítb¾ùÖ¸Õâ¸ö²âÊÔ±í
--1¡¢Äã²ÂÏÂÃæÕâÌõÓï¾äÄܵõ½Ê²Ã´½á¹û£¬Õâ¸öºÜ³£ÓÃ
if object_id('tb') is not null
drop table tb
go select getdate()
create table tb(id int identity ,name varchar(10))
insert into tb select 'ÕÅÈý'
union all select 'ÀîËÄ'
union all select 'ÍõÎå'
union all select 'ÕÔÁù'
go
select * into ta from tb where 1<>1
--2¡¢ÏÂÃæÕâÌõÓï¾ä»á±¨´íÂð£¿ÎªÊ²Ã´£¬ÔõôÐ޸IJÅÄÜÈÃËüÊä³ö “ÕýÈ·” ÕâÁ½¸ö×Ö
select case when 1>1 then 1
when 1=1 then 'ÕýÈ·'
when 1<1 then 2
end
--3¡¢ Ôõô²ÅÄÜ×öµ½ÏÂÃæµÄÈýÌõͬʱִÐеõ½µÄ½á¹ûÊÇÃüÁîÒѳɹ¦Íê³É¡£
--¶ø²»ÊÇselect¸½½üÓÐÓï·¨´íÎó
select
select 1
select
--4¡¢ ˼¿¼Ò»ÏÂÕâ¸öÎÊÌâ
--ÔÚmasterÖн¨¸ö±í£¬ÔÚÆäËü¿âÀï·ÃÎÊ(ͬһ·þÎñÆ÷)£¬²»ÔÊÐíʹÓÃÏÞ¶¨Ãû£¬ÈçºÎ²ÅÄÜÖ±½Ó·ÃÎÊ´Ë±í£¿
--5¡¢ datalength() ·µ»ØÓÃÓÚ±íʾÈκαí´ïʽµÄ×Ö½ÚÊý¡£
-- Äã²ÂÏÂÃæµÄ½á¹û»áÊÇʲô?Ϊʲô
select datalength('1'),datalength(1),datalength(getdate()),datalength('2010-01-23 13:01:37.280')
--6¡¢Äã¿ÉÒÔÊÔÊÔÏÂÃæµÄÈý¸öÓï¾ä£¬ÎªÊ²Ã´µÚÒ»¸ö»áÓÐÓï·¨´íÎ󣬶øµÚ¶þ¸ö½á¹ûÊÇÕýÈ·µÄ
--¢ñ£º
select * from tb ord
Ïà¹ØÎĵµ£º
ʲôÊÇÅÅÐò¹æÔò£¨collation£©
¹ØÓÚSQL ServerµÄÅÅÐò¹æÔò£¬¹À¼Æ´ó¼Ò¶¼²»Ä°Éú£¬ÔÚ´´½¨Êý¾Ý¿âʱÎÒÃǾ³£ÒªÑ¡ÔñÒ»ÖÖÅÅÐò¹æÔò£¨conllation£©£¬Ò»°ãÎÒÃÇ»áÁôÒ⵽ÿһÖÖÓïÑÔµÄÅÅÐò¹æÔò¶¼ÓÐÐí¶àÖÖ£¬±ÈÈç±ê×¼´ó½¼òÌåÖÐÎÄChinese_PRCµÄÅÅÐò¹æÔò¾ÍÓÐÊýÊ®ÖÖÖ®¶à
ÕâЩÅÅÐò¹æÔòÓÐʲô×÷ÓÃÄØ£¿ÈÃÎÒÃÇÏÈÀ´¿´¿´MS¹Ù·½µÄ½âÊÍ£º
ÅÅÐò¹æÔ ......
¶¯Ì¬Óï¾ä
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃexecÖ´ÐÐ
Select * from tableName
exec('select * from tableName')
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN
2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL
declare @fname varchar(20)
set @fname = 'FiledName'
Select @fnam ......
SQL ServerÊý¾ÝÀàÐÍ2009Äê02ÔÂ02ÈÕ ÐÇÆÚÒ» 11:20Êý¾ÝÀàÐÍÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬ÊÇÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖÓïÑÔ¶¼ÓÐËü×Ô¼ºËù¹ÌÓеÄÊý¾ÝÀàÐÍ£¬SQL ServerÌṩһÏÂ25ÖÖ¹ÌÓеÄÊý¾ÝÀàÐÍ¡£ SQL ServerÊý¾ÝÀàÐÍÒ»ÀÀ±í
¡¡¡¡·Binary [(n)]
·Varbinary [(n)]
·Char [(n)]
·Varchar[(n)]
· ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
//sqlserverÉí·ÝÑéÖ¤
//string sqlconn = "ser ......
ÒÔǰÔÚ°²×°sqlµÄʱºò£¬Èç´ËÌáʾ£¬ÎÒÖ»ÒªÖØÐÂÆô¶¯¼´¿É£¬¿ÉÊǽñÌìÖØÐÂÆô¶¯ÁËN´Î¼ÆËã»ú£¬ÎÊÌâÈ´Ë¿ºÁûÓнâ¾ö£¬ÒÀÈ»ÌáʾÕâÑùµÄ»°¡£“ÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£” Ö»ºÃgoogleÒÔÏ£¬×îÖÕµÃÖªÊǰ²×°³ÌÐòÔÚÏÈǰµÄ°²×°¹ý³ÌÖÐÔÚϵͳע²á±íÁôÏÂijЩÐÅÏ¢£ ......