Skip to main content

Problem And Solutions

Search This Blog

How do you change column names in SQL Server

on March 25, 2011

Get link
Facebook
X
Pinterest
Email
Other Apps

Exec sp_rename 'oldtablename.oldcolmnname', 'newcolumnname','COLUMN'
for example :-
Exec sp_rename 'employee.DateofBirth','DOB','COLUMN'

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Popular Posts

Bing ...........

www.bing.com is Microsoft 's new online portal , the next generation of Windows Live Search Engine. Bing's search capability is sensitive to the type of information being searched for and brings up information on the search results that is more relevant. The Bing search page is attractive and graphical, and it calls out the vertical search types with which it excels via a list of links. One of the big draws here is that complex searches—where you're shopping for a particular product or trying to book a trip, for example—can take place entirely within the confines of Bing. So rather than click in and out of a Spartan list of links, you can instead do research in-place. Bing's travel experience is particularly well designed and is integrated with the price-forecasting capabilities of the Microsoft FareCast service. Likewise, the shopping experience integrates with Microsoft's Cash Back technology, so your PayPal account will automatically be credited if you buy via a...

VB Script to show Expiration Date in BGInfo

'======================================== ' First, get the domain policy. '======================================== Dim oDomain Dim oUser Dim warningDays warningDays = 30 Set LoginInfo = CreateObject("ADSystemInfo") Set objUser = GetObject("LDAP://" & LoginInfo.UserName & "") strDomainDN = UCase(LoginInfo.DomainDNSName) strUserDN = LoginInfo.UserName Set oDomain = GetObject("LDAP://" & strDomainDN) '======================================== ' Determine the last time that the user ' changed his or her password. '======================================== Set oUser = GetObject("LDAP://" & strUserDN) 'intUAC = oUser.Get("userAccountControl") '======================================== ' Add the number of days to the last time ' the password was set. '======================================== whenPasswordExpires = DateAdd("d", 180, oUser....

windows mobile 6.5 disable autocomplete

To disable autocomplete function : change the following registry entry and do a Warmboot. Before edit the registry, must unlock the registry first !!! [ HKEY_CURRUNT_USER\ControlPanel\Sip] " SuggWords"=dword:00000000 Remote Edit Registry : CeRegEditor Main features: - keys/values create and edit - fast search - export/import keys to/from REG file - create "image" registry with compare and restore service - free for private and commercial use - registry compare to CAB or REG files - open REG/RGU, CAB, HV as regular registry, with all edit functions available ...and many more link to web site: http://ceregeditor.mdsoft.pl?lang=en link to software: http://ceregeditor.mdsoft.pl/ceregedit_setup.exe

Powered by Blogger