USE Arm_DB Go IF OBJECT_ID(‘TBL_Persons’,’U’) IS NOT NULL DROP TABLE TBL_Persons CREATE TABLE TBL_Persons ( ID INT IDENTITY PRIMARY KEY ,NAME Char(50) ) GO ALTER TABLE TBL_Persons ADD Lname Nvarchar(70) Go ALTER TABLE TBL_Persons ALTER COLUMN NAME NVARCHAR(50) GO INSERT… Read More ›
SQL Server
How to save image or any others file type directly from file in SQL Server with binary format
USE Arm_DB GO IF OBJECT_ID(‘TBL_Image’,’U’) IS NOT NULL DROP TABLE TBL_Image CREATE TABLE TBL_Image ( [ID] INT IDENTITY(1,1) ,[Image] VARBINARY(MAX) CONSTRAINT PK_TBL_Image PRIMARY KEY CLUSTERED (ID) ) Go INSERT INTO TBL_Image(Image) SELECT * FROM OPENROWSET(BULK ‘C:\Users\Public\Pictures\Sample Pictures\Koala.JPG’,SINGLE_BLOB ) i
How to create Database in SQL Server with TSQL
USE master GO CREATE DATABASE Arm_DB ON ( NAME = Arm_DB_Dat ,FILENAME = ‘C:\Arman\Mine\MyBlog\Database\Arm_DB_Dat.MDF’ ,SIZE = 20 ,MAXSIZE = 200 ,FILEGROWTH = 8 ) LOG ON ( NAME = Arm_DB_Log ,FILENAME = ‘C:\Arman\Mine\MyBlog\Database\Arm_DB_Log.LDF’ ,SIZE = 15MB ,MAXSIZE = 125MB ,FILEGROWTH… Read More ›
