Bakup SQL Server 2008 to SQL Server 2005

http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx

Resources:
[1]Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)
http://go.microsoft.com/fwlink/?LinkId=65111

Music using Spotify

http://www.spotify.com/download/?autodl

Power Builder::Tips

DropDown ListBox
http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html


Clear datawindow
long ll_i, ll_rc

ll_rc = dw_1.RowCount()

for ll_i = 1 to ll_rc
dw_1.deleterow(1)
next

dw_1.AcceptText()
dw_1.Update(True, True)

--or--

dw_1.Reset() //will never delete the rows from DB, It will just clear the datawindow buffers.


Work with dates
========================================================
dt_today = today()
li_maand = month(dt_today )
li_jaar = year(dt_today )
li_dag = day(dt_today )


apply filter
========================================================
ls_filtro = "columna1 > 100 and columna2 > 30"

dw_1.SetFilter(ls_filtro)

dw_1.Filter( )




references
[0] http://powerbuilder-undiaalavez.blogspot.com/

[1] Tutorial Power Builder 9.0 http://edyovando.galeon.com/INICIO.HTML
[2] Trucos datawin
http://infolenguajes.galeon.com/datawin.htm
[3] http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html

[4] List of Functions Available in Datawindow Expressions
http://pbbraindump.wordpress.com/2008/05/15/list-of-functions-available-in-datawindow-expressions/
[5] http://solocodigofuente.com/ejemplos-de-codigo-fuente-en-visual-basic-net/uso-del-control-dropdownlistbox-listbox-listview-de-power-builder/
[6] http://powerbuilder-undiaalavez.blogspot.com/2011_02_01_archive.html

http://ingpcastillo.com/personal/Manual/MANUAL_DE_POWER_BUILDER.pdf
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/power-builder/respuestas/2317534/datawindows-avanzado



http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html

http://es.scribd.com/doc/6878574/Powerbuilderuso-de-Cursores
http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/159c2bf7ef4f114e?pli=1

SQL Server::Collation

referencias:
http://www.portalfox.com/index.php?name=News&file=article&sid=477&mode=nested&order=0&thold=0

http://www.guillesql.es/Articulos/SQLServerFAQ_Intercalacion_Cambiar_Collation.aspx

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

SQL Server::Identificar versión y edición

Cómo determinar la versión de SQL Server
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

SELECT @@VERSION