Ammyy

Etiquetas de Technorati: Ammyy,Sortir,Pantalla,Completa

www.ammyy.com

Per sortir de pantalla completa: Ctrl+Alt+Shift+F

Com esborrar els usuaris i passwords guardats al SQL Server Management Studio

Etiquetas de Technorati: SQLServer

SQL Server Management Studio 2014, esborra l’arxiu: C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

SQL Server Management Studio 2012, esborra l’arxiu: C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

SQL Server Management Studio 2008, esborra l’arxiu: C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Per S.O.: Vista / 7 / 8.

Com agafar la data i la hora de dos camps diferents en una consulta SQL

 

SELECT        Data, hora, CONVERT(varchar(10), Data, 103) AS Expr2, CONVERT(varchar(8), hora, 108) AS Expr3, CONVERT(datetime, CONVERT(varchar(10), Data, 103) + ' ' + CONVERT(varchar(8), hora, 108), 103)

                         AS Expr1

FROM            Moviments

ORDER BY Expr1

Etiquetas de Technorati: SQL,SQLServer,Data,Hora