Create Database in SQL Server by Sql script

Put below script in sql Editor and change Database_Name to your Database name

IF (NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = 'Database_Name' OR name = 'Database_Name')))
Begin

CREATE DATABASE [Database_Name]

ALTER DATABASE Database_Name MODIFY FILE
( NAME = N'Database_Name' , SIZE = 3048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

ALTER DATABASE Database_Name MODIFY FILE
( NAME = N'Database_Name' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

End

Comments

MIME Types list

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of email to support: Text in character sets other than ASCII Non-text attachments: audio, video, images, application programs etc. Message bodies with multiple parts Header information in non-ASCII character sets MIME Types list Suffixes Mime .3dm x-world/x-3dmf .3dmf x-world/x-3dmf .a application/octet-stream .aab application/x-authorware-bin .aam application/x-authorware-map .aas application/x-authorware-seg .abc text/vnd.abc .acgi text/html .afl video/animaflex .ai application/postscript .aif audio/aiff .aif audio/x-aiff .aifc audio/aiff .aifc audio/x-aiff .aiff audio/aiff .aiff audio/x-aiff .aim application/x-aim .aip text/x-audiosoft-intra .ani application/x-navi-animation .aos application/x-nokia-9000-communicator-add-on-software .aps application/mime .arc ap...

How To Check if table exists in c#

Use this query to check table is exist or not "select case when exists((select * from information_schema.tables where table_name = 'Table_Name')) then 1 else 0 end " You Get result 1 for if Exist and 0 for Not Exist

What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?

ExecuteScalar is typically used when your query returns a single value. If it returns more, then the result is the first column of the first row. An example might be SELECT @@IDENTITY AS 'Identity'. ExecuteReader is used for any result set with multiple rows/columns (e.g., SELECT col1, col2 from sometable). ExecuteNonQuery is typically used for SQL statements without results (e.g., UPDATE, INSERT, etc.).

Asp .Net Solution

Search This Blog