LINQ to SQL ²éѯÊý¾Ý¿âºÍʹÓô洢¹ý³Ì
ÈçÏÂÁгö²éѯ±í´ïʽ£¬³£ÓòÙ×÷·û£¬ÓëSQLÓï¾ä¶ÔÓ¦¡£
where ¹Ø¼ü×ÖµÄʹÓÃ
public void MyWhere()
{
NorthwindDataContext dc = new NorthwindDataContext();
//²éѯ²úÆ·Ãû³ÆÒÔL¿ªÍ·µÄ¼Ç¼
var query = from p in dc.Products
where p.ProductName.StartsWith("L")
select p;
//Á½¸öwhere¹ýÂËÁ½¸öÌõ¼þ£¬µÚ¶þ¸öwhere»áÔÚµÚÒ»¸öwhere»ù´¡ÉϽøÐеڶþ´ÎÌõ¼þν´Ê
var query1 = from p in dc.Products
where p.ProductName.StartsWith("L")
where p.ProductName.EndsWith("i")
select p;
foreach (Products item in query1)
{
Response.Write(item.ProductID + " | " + item.ProductName + "<br />");
}
}
join Á¬½Ó²Ù×÷
Í϶¯Êý¾Ý¿âµÄOrders±íµ½Éè¼ÆÆ÷ÖÐÀ´£¬½á¹ûÈçÏÂ
Éè¼ÆÆ÷»á¸ù¾Ý±íÔÚÊý¾Ý¿âÖÐÉ趨µÄÒÀÀµ¹ØÏµ£¬Éú³É±í¶ÔÏóÖ®¼äµÄÒÀÀµ¹ØÏµ£¬²é¿´±í¹ØÏµ£¬¿ÉÒÔ´ò¿ªSQL Server ¹ÜÀíÆ÷£¬´ò¿ªÊý¾Ý¿âÓÒ¼üµã»÷±í£¬Ñ¡Ôñ²é¿´ÒÀÀµ¹ØÏµ¡£
¿ÉÒÔ¿´µ½OrderÒÀÀµCustomer
Èç¹ûÄãÏë¸ø±íÌí¼Ó»òÕß¹ÜÀíÒ»¸öFKµÄ»°¿ÉÒÔ¿´ÏÂͼ£¬Èç¹ûÏëÌí¼Ó¾ÍÓÒ»÷¡¢¼üĿ¼¡¢Ìí¼Ó¼ü£¬ÈçÏÂͼ
ÔÙµã»÷±íºÍÁй淶ºóÃæµÄ°´Å¥
Ñ¡ÔñÖ÷±íºÍÁжÔÓ¦±¾±íÄǸöÁУ¨Íâ¼ü£©È·¶¨£¬µã±£´æ£¬Ë¢ÐÂһϾͿÉÒÔ¿´µ½ÁË
´úÂ룺
public void MyJoin()
{
// PERFORMING JOINS
NorthwindDataContext dc = new NorthwindDataContext();
dc.Log = Console.Out;
var query = from c in dc.Customers
join o in dc.Orders on c.CustomerID equals o.CustomerID
orderby c.CustomerID
select new
{
c.CustomerID,
c.CompanyName,
c.Country,
o.OrderID,
o.OrderDate
};
foreach (var item in query)
{
Response.Write(item
Ïà¹ØÎĵµ£º
×î½ü,Òò¸öÈ˵çÄÔÓ²ÅÌËð»µ,йºÈëÁË500GµÄ´óÓ²ÅÌ,°²×°ÁËwindows7,ÔÚwin7Éϰ²×°Á˶à¸öÐéÄâxp»ú,ÐéÄâ»úÓëʵ¼ÊµÄ»úÆ÷(Ö÷»ú)×é³ÉÁËÒ»¸ö¾ÖÓòÍø,ʵÏÖÔÚÐéÄâ»úÖÐͨ¹ýÔ¶³ÌÁ¬½ÓÖ÷»úµÄsql server.ÏÖ½«ÎÒµÄÊÔÑé¹ý³Ì½éÉÜÈçÏÂ,¹©ÓÐÐËȤ³¢ÊԵĴóÏÀ²Î¿¼.
1. °²×°ÐéÄâ»ú»·¾³.
ÏȰ²×°window7.0Æì½¢°æ (רҵÓëÆóÒµ°æÒ²¿ ......
´Ó¹ÙÍøÏÂÔØSQL Server 2008µÄ180ÌìÊÔÓðæÆäʵÓëÕýʽ°æÄÚÈÝÊÇ»ù±¾ÏàͬµÄ£¬Î¨Ò»µÄÇø±ð¾ÍÔÚÓÚ°²×°ÅäÖÃÎļþÖÐËù°üº¬µÄkey¡£¸÷ÖÖ°æ±¾µÄSQL ServerÔÚ½øÐе½ÕâÒ»²½Ö®Ç°¶¼ÊÇÍêȫһÑùµÄ£º
Microsoft® SQL Server® 2008 Enterprise Evaluation£º¿ª·¢ÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Enterprise Evaluatio ......
create function fun_getPY(@str nvarchar(4000))
returns nvarchar(4000)
as
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--Èç¹û·Çºº×Ö×Ö·û£¬·µ»ØÔ×Ö·û
set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901
......
Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba" ÒÔsysdbaÉí·ÝµÇ¼
c:\>sqlplus/nolog ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
Æô¶¯
SQL> startup &nb ......
SQL°æ±¾Éí·ÝÖ¤¸ñʽÑéÖ¤ 0Ϊ´íÎó£¬1ΪÕýÈ·
CREATE function [dbo].[IsID](@str nvarchar(18),@sex int)--´«ÈëÁ½¸ö±äÁ¿ Éí·ÝÖ¤ºÍÐÔ±ð(ÄÐ1Å®2)
returns bit
as
begin
declare @len int
declare @result bit
--set @result=0
set @len=len(@str)
if(@len!=18 and @len!=15)--³¤¶ÈÊÇ18λ»ò15λ
begin
& ......