SQL/LINQ
文章平均质量分 69
zhangxiao86
这个作者很懒,什么都没留下…
展开
-
SQL Programming for Qian Order (SQL Server)
--Create table Table1(id int,Rndvalue int)Declare @OrderDetails Table(Orderid int,Price int,discountedPrice int, Discount varchar(20),SaleDate date)Declare @index intselect @index=1Declare @r原创 2012-02-11 08:21:46 · 281 阅读 · 0 评论 -
LINQ Learning Summary
c.Template_Tags.Any(x => x.Tag.Translation.Contains(tsc.tag_t_part))In Linq, the contains is same as the "like %" function in T-SQL***********************************************************原创 2012-02-25 21:40:08 · 267 阅读 · 0 评论 -
SQL Prepared for Interview
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?SELECT * FROM Persons WHERE LastName原创 2012-07-07 08:50:11 · 366 阅读 · 0 评论 -
4pm sql command backup
1, turn on Email report for all agents of IPAV, if they have any property.update [findahome].[dbo].[AgentContactFrequency] set Frequency = 7 where AgentId in ( SELECT Distinct(acf.AgentId) FRO原创 2012-07-11 06:17:59 · 284 阅读 · 0 评论 -
SQL 增删改查 参考 基础
一、增:有4种方法 1.使用insert插入单行数据: 语法:insert [into] [列名] values 例:insert into Strdents (姓名,性别,出生日期) values ('开心朋朋','男','1980/6/15') 注意:into可以省略;列名列值用逗号分开;列值用单引号因上;如果省略表名,转载 2012-07-08 07:30:47 · 761 阅读 · 0 评论 -
ADO.NET Insert command function
'=========================================================== '=========================================================== ' Function: gInsertPropBrochure_others ' Purpose: Optional Insert原创 2012-05-21 04:27:52 · 377 阅读 · 0 评论 -
The Search Function For Complete Letting
1, Load the Search Box (If no any property in db, then don't display this condication)using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;usin原创 2012-04-01 18:05:14 · 378 阅读 · 0 评论 -
SQL INSERT / UPDATE WITH SELECT
update command UPDATE [findahome].[dbo].[Ad_Bank] SET Balance = 2000 where idAgencyOffice IN (SELECT idOffice from [findahome].[dbo].[AgencyOffice] ao JOIN [findahome].[dbo].[Agency] ag ON ao.i原创 2012-03-26 17:32:51 · 311 阅读 · 0 评论 -
sql server 2008 copy data from one table to another
Let us take a look at an example where we will generate script database. In our example, we will just take one table for convenience.Right Click on Database >> Tasks >> Generate Scripts >>原创 2012-03-25 23:03:23 · 502 阅读 · 0 评论 -
LINQ Exception: System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException
There are two relationed tablesWhen want use the following code to update the record in table cat_user, it will meet an Exception:System.Data.Linq.ForeignKeyReferenceAlreadyHasValueExcepti原创 2012-03-03 23:32:16 · 611 阅读 · 0 评论 -
SQL Server 2008 User Account Create (For Frank's website)
After open SQL server 2008:click the Security --> Login --> new Login --> give the login name and password ---> unclick Enforce password policy and following three optionsThe ok, the new user is c原创 2012-02-19 23:17:47 · 593 阅读 · 0 评论 -
PL-SQL Oracle --- Order List for Qianqian(Oracle)
CREATE TABLE test5(orderid number(10), price number(10),afterdiscount number(10),discount varchar2(20),saledate DATE);DECLARE randomNum NUMBER; discounted NUMBER; havediscount varchar2(20); nodi原创 2012-02-12 01:05:59 · 274 阅读 · 0 评论 -
LINQ & Generic Basic
The Quick sample to show the basic LINQ. easier to operate an Arrayusing System;using System.Linq;using System.Collections.Generic;public class Class1{ public static void Main() {原创 2012-08-18 22:01:01 · 234 阅读 · 0 评论