Search This Blog

Krishan Kayat

windows phone

Enjoyable moments of Training Time

Get link
Facebook
X
Pinterest
Email
Other Apps

December 30, 2010

Miscellaneous

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to enable call waiting : windows phone 7.5 Mango (samsung omnia w)

July 19, 2012

Dial *43# to enable call waiting on your GSM connection To disable call waiting, dial #43#

how to get list of tables, functions and stored procedure created last month in sql server

April 08, 2015

SELECT [name] ,create_date ,modify_date FROM sys.tables where create_date >='03/01/2015' SELECT * FROM sys.procedures WHERE create_date >='03/01/2015' SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF') -- scalar, inline table-valued, table-valued

Delete Duplicate Records in DataBase sql server

November 21, 2012

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%) from tblname group by b.coloumnname) Hope it helped you........ plz comments.........

Labels

ASP.NET
Extra blogs
interview question in sql server
ios
iphone
Miscellaneous
Samsung Omnia w
SQL Server 2008
windows 7