PC-SPIM - MIPS: 2011

Import Excel to SQL

BULK INSERT 'tablename ' FROM 'path filename.csv'

WITH (FIELDTERMINATOR = ';');
Read More

RESTORE DATABASE YourDatabaseName

RESTORE DATABASE YourDatabaseName
FROM DISK = N'(path to your BAK file)'
WITH FILE = 1,
MOVE N'(your DB name)' TO N'(your SQL path)database.MDF',
MOVE N'(your DB name)_LOG' TO N'(your SQL path)database_LOG.LDF',
NOUNLOAD,
REPLACE,
STATS = 10
GO

By
http://stackoverflow.com/questions/6217679/create-restore-database-from-backup-sql-server-express
Read More

Service Studio 4.X

Plataform Server 4.X

PlatformServer-4.2.4.26

PlatformServer-4.2.4.23

PlatformServer-4.2.4.20

PlatformServer-4.2.4.19

PlatformServer-4.2.4.16

PlatformServer-4.2.4.15

PlatformServer-4.2.4.13

PlatformServer-4.2.4.12

PlatformServer-4.2.4.8

PlatformServer-4.2.4.5

PlatformServer-4.2.4.62

PlatformServer-4.2.4.54

PlatformServer-4.2.4.51

PlatformServer-4.2.4.49

PlatformServer-4.2.4.45

PlatformServer-4.2.4.43

PlatformServer-4.2.4.38

PlatformServer-4.2.4.33
Read More

Integration Studio Version 4.X

IntegrationStudio-4.2.4.55

IntegrationStudio-4.2.4.49

IntegrationStudio-4.2.4.43

IntegrationStudio-4.2.4.38

IntegrationStudio-4.2.4.13

IntegrationStudio-4.2.4.26

IntegrationStudio-4.2.4.38_2

IntegrationStudio-4.2.4.16

IntegrationStudio-4.2.4.15

IntegrationStudio-4.1.3.48

IntegrationStudio-4.2.4.9

IntegrationStudio-4.2.4.8

IntegrationStudio-4.2.4.5
Read More

CONVERT and CAST SQL

DECLARE @value decimal (5, 2)
SET @value = 193.57
SELECT CAST(CAST(@value AS varbinary(20)) AS decimal(10,5)) +6.43

OR another

SELECT CONVERT(decimal(10,5), CONVERT(varbinary(20), @value ))
Read More

Ruby on Rails

Hello my friends :)

another Manual but this is Ruby on Rails

Filter Date

EnterParameters
@dt_Incio
@dt_fim

((@dt_inicio = @Nulldate and @dt_fim = @Nulldate) OR
((CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) >= @dt_inicio AND
(CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) <= @dt_fim))
Read More

How to replace single quotes

How to solution replace " for ' it's simple you can use ASCII table chr(34)

To solve such problems, use the command like this

replace(,chr(34),”'“)
Read More

Nulldate Filter Outsystems/SQL

((@dt_inicio = @Nulldate and @dt_fim = @Nulldate) OR
((CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) >= @dt_inicio AND
(CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) <= @dt_fim)) AND
({EMAIL}.[Subject] LIKE ('%' + @SearchKeyword + '%') OR {EMAIL}.[Message] LIKE ('%' + @SearchKeyword + '%') OR @SearchKeyword = NULL)
Read More

You Can view how to size your tables

DECLARE
@max INT,
@min INT,
@owner NVARCHAR(256),
@table_name NVARCHAR(256),
@sql NVARCHAR(4000)

DECLARE @table TABLE(
ident INT IDENTITY(1,1) PRIMARY KEY,
owner_name NVARCHAR(256),
table_name NVARCHAR(256))

IF (SELECT OBJECT_ID('tempdb..#results')) IS NOT NULL
BEGIN
DROP TABLE #results
END

CREATE TABLE #results(
ident INT IDENTITY(1,1) PRIMARY KEY, --Will be used to update the owner.
table_name NVARCHAR(256),
owner_name NVARCHAR(256),
table_rows INT,
reserved_space NVARCHAR(55),
data_space NVARCHAR(55),
index_space NVARCHAR(55),
unused_space NVARCHAR(55))

INSERT @table(owner_name, table_name)
SELECT
su.name,
so.name
FROM
sysobjects so
INNER JOIN sysusers su ON so.uid = su.uid
WHERE
so.xtype = 'U'

SELECT
@min = 1,
@max = (SELECT MAX(ident) FROM @table)

WHILE @min <= @max
BEGIN

SELECT
@owner = owner_name,
@table_name = table_name
FROM
@table
WHERE
ident = @min

SELECT @sql = 'EXEC sp_spaceused ''[' + @owner + '].[' + @table_name + ']'''
INSERT #results(table_name, table_rows, reserved_space, data_space, index_space, unused_space)
EXEC (@sql)

UPDATE #results
SET owner_name = @owner
WHERE ident = (SELECT MAX(ident) FROM #results)

SELECT @min = @min + 1
END

SELECT * FROM #results
Read More

Worldwide Launch of Agile Platform 6.0

Worldwide Launch of Agile Platform 6.0 from OutSystems on Vimeo.

BRUTALLLLLLLLLL
Read More

Table TEMP for BIG Tables(ROWS)

SELECT

{TRANSACTION}.[Id],{TRANSACTION}.[PostDate],

{TRANSACTION}.[Iban], {TRANSACTION}.[Amount]

INTO #TEMP

FROM {TRANSACTION}

WHERE {TRANSACTION}.[Nconta]= <variable>

SELECT #TEMP.*

FROM #TEMP

HTML 5- Facebook

http://cdn.livestream.com/grid/LSPlayer.swf?channel=facebookeducation&clip=pla_98824c1a-a2e1-4831-9b9e-c5cd23f5d8eb&autoplay=false
Read More

HTML 5 on Visual Studio 2010 and 2008

Some love and others hate, HTML 5 seems to be coming to share the waters.
It is possible to work with HTML 5 in Visual Studio 2010 and Visual Studio 2008 for this follow the steps below:
1) The first thing to do is download a file package that is in this link, it have a file with the xml schema, files and records of the four windows.
2) Now we will copy or move the file "html_5.xsd" to "C: \ Program Files \ Microsoft Visual Studio 10.0 \ Common7 \ Packages \ schemas \ html"

http://www.4shared.com/photo/crBo94ti/OnExplorer.html

3) Execute the registry file "VS-2010-x64.reg" or "VS-2010-x86.reg"according to your installed version 64 bits or 32 bits.

4) Now we will validate these changes, open up VS 2010 and go to "Tools> Options> Text Editor HTML>> Validation ", and HTML5 validation profile must be available as shown in the picture below.

http://www.4shared.com/photo/v2NgC8ba/OnVisualStudio.html

5) Restart Visual Studio 2010 or 2008 and good work.

html5-vs2010.rar Install Step two to install
HTML5Setup.msi Step one to install

Code by http://rodrigodotnet.wordpress.com/2010/10/13/visual-studio-2010-com-suporte-para-html5/

Read More

Hacks Css

/* Firefox */
@-moz-document url-prefix()
{
.arrowlistmenu { margin-top:-10px }
}

/* Safari */
@media screen and (-webkit-min-device-pixel-ratio:0)
{
.arrowlistmenu { margin-top:-10px }
}
Read More

Get Years From 1980

Send the RecordList Years below1980

public void MssGetYears(out RLYearsRecordList ssOutput) {
            ssOutput = new RLYearsRecordList(null);
            int currentYear = DateTime.Now.Year;

            for (int i = currentYear; i >= 1980; i--)
            {
                RCYearsRecord rcYear = new RCYearsRecord();
                rcYear.ssSTYears.ssYear = i.ToString();
                ssOutput.Append(rcYear);
            }
            // TODO: Write implementation for action
        }

Code By http://informatictips.blogspot.com/
Read More

Radom Colours

        public void MssRandomColour(out string ssColour)
        {
            ssColour = string.Empty;
            Random random = new Random();
            System.Threading.Thread.Sleep(250);
            char[] valid = { 'A', 'B', 'C', 'D', 'E', 'F', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0'};
            StringBuilder sb = new StringBuilder("");
            for(int i = 0; i < 6; i++)
            {
                sb.Append(valid[random.Next(valid.Length)]);
            }
            ssColour = "#" + sb.ToString();

            // TODO: Write implementation for action
        }
Read More

ConvertToKbAndMb

public void MssConvertToKbAndMb(string ssbytes, out string ssKb, out string ssMb)
{
            ssKb = string.Empty;
            ssMb = string.Empty;

            // Convert bytes to megabytes.
            double megabytes1 = ConvertBytesToMegabytes(double.Parse(ssbytes));

            ssMb = Math.Round(megabytes1, 2).ToString() + " Mb";

            // Convert bytes to kilobytes.
            double kilobytes = ConvertBytesToKilobytes(double.Parse(ssbytes));

            // Write the result.
            ssKb = Math.Round(kilobytes).ToString() + " Kb";

            // TODO: Write implementation for action
        } // MssConvertToKbAndMb

        static double ConvertBytesToMegabytes(double bytes)
        {
            return (bytes / 1024f) / 1024f;
        }

        static double ConvertBytesToKilobytes(double bytes)
        {
            return bytes / 1024f;
        }
Read More

PC-SPIM - MIPS

Home

Labels

Blog Archive

BlogRoll

Followers

Whats your IP