Monday, June 10, 2013
How to make footer fixed to the bottom in Bootstrap?
By new class in Bootstrap 2.2.1: navbar-fixed-bottom
How to add Bootstrap into ASP.NET MVC 3?
http://www.codeproject.com/Articles/404633/Transform-ASP-NET-MVC3-Default-Template-with-Twitt
Download different themes from
http://bootswatch.com/
Download different themes from
http://bootswatch.com/
How to upgrade ASP.NET MVC 3 to MVC 4?
By nuget package:
PM> Install-Package UpgradeMvc3ToMvc4
https://nuget.org/packages/UpgradeMvc3ToMvc4
PM> Install-Package UpgradeMvc3ToMvc4
https://nuget.org/packages/UpgradeMvc3ToMvc4
Friday, May 31, 2013
How to update BLOB field in SQL Server?
UPDATE myTable
SET theBlobField =
(SELECT BulkColumn FROM OPENROWSET (BULK 'C:\logo.png, SINGLE_BLOB) a)
WHERE [ID] = 1
SET theBlobField =
(SELECT BulkColumn FROM OPENROWSET (BULK 'C:\logo.png, SINGLE_BLOB) a)
WHERE [ID] = 1
How to save binary (BLOB) field into local file from SQL Server database by SQL?
DECLARE @SQLIMG VARCHAR(MAX), @IMG_PATH VARBINARY(MAX), @TIMESTAMP VARCHAR(MAX), @ObjectToken INT DECLARE IMGPATH CURSOR FAST_FORWARD FOR SELECT csl_CompanyLogo from mlm_CSCompanySettingsLocalizations OPEN IMGPATH FETCH NEXT FROM IMGPATH INTO @IMG_PATH WHILE @@FETCH_STATUS = 0 BEGIN SET @TIMESTAMP = 'd:\' + replace(replace(replace(replace(convert(varchar,getdate(),121),'-',''),':',''),'.',''),' ','') + '.bmp' PRINT @TIMESTAMP PRINT @SQLIMG EXEC sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT EXEC sp_OASetProperty @ObjectToken, 'Type', 1 EXEC sp_OAMethod @ObjectToken, 'Open' EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @IMG_PATH EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @TIMESTAMP, 2 EXEC sp_OAMethod @ObjectToken, 'Close' EXEC sp_OADestroy @ObjectToken FETCH NEXT FROM IMGPATH INTO @IMG_PATH END CLOSE IMGPATH DEALLOCATE IMGPATH
Reference:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101754
Subscribe to:
Posts (Atom)