Sql server

Change Microsoft Sql Server Collation 1 min read

• Sql server

Change Microsoft Sql Server Collation

Mahesh Javiya 11 years ago

Change Collation Name Below script generate alter table query for all tables of selected db, after executing below query and script then 1. Right click on... Read More

Split string table value function sql server 1 min read

• Sql server

Split string table value function sql server

Mahesh Javiya 12 years ago

Split string table value function sql server Function return a table. @String : value with separator ex: 1,2,3@Delimiter : define separator as characterif pass blank... Read More

drop all foreign key constraints in a database 1 min read

• Sql server

drop all foreign key constraints in a database

Mahesh Javiya 12 years ago

drop all foreign key constraints in a database Using below code you can esaly remove all foreign-key constraints of tables. SELECT ‘IF EXISTS (SELECT *... Read More

Insert Statement Script Generator Procedure 2 min read

• Sql server

Insert Statement Script Generator Procedure

Mahesh Javiya 12 years ago

Insert statement generator for database CREATE PROC [dbo].[InsertGenerator] (@tableName varchar(100)) as –Declare a cursor to retrieve column specific information for the specified table DECLARE cursCol... Read More

Generate Http post Request From sql server 1 min read

• Sql server

Generate Http post Request From sql server

Mahesh Javiya 13 years ago

Generate Http post Request From sql server CREATE procedure HTTP_POST(  @sUrl varchar(200),  @response varchar(8000) out) As Declare @obj int ,@ hr int ,@status int ,... Read More

Db Cleaner 3 min read

• Sql server

Db Cleaner

Mahesh Javiya 13 years ago

/* Drop all non-system stored procs */DECLARE @name VARCHAR(128)DECLARE @SQL VARCHAR(254) SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND... Read More

Find Duplicate value in table 1 min read

• Sql server

Find Duplicate value in table

Mahesh Javiya 14 years ago

Find Duplicate Value with count select ColumnName, count(ColumnName) from TableName group by ColumnName having count (ColumnName) > 1;... Read More

Read Data from .txt file in sql 1 min read

• Sql server

Read Data from .txt file in sql

Mahesh Javiya 14 years ago

LOAD DATA LOCAL INFILE ‘C:\\[your folder path to the data file]\\GEODATASOURCE-WORLD-MAJOR-CITIES-SAMPLES.TXT’ INTO TABLE `countrystatecitydb`.`countrystatecity` CHARACTER SET utf8 FIELDS TERMINATED BY ‘\t’0 LINES TERMINATED BY ‘\r\n’;... Read More

xp command shell to create file on server 1 min read

• Sql server

xp command shell to create file on server

Mahesh Javiya 14 years ago

xp command shell to create file on serverExec Master.dbo.Sp_Configure ‘Show Advanced Options’, 1 RECONFIGURE WITH OVERRIDE Exec Master.dbo.Sp_Configure ‘XP_CmdShell’, 1 RECONFIGURE WITH OVERRIDE exec master..xp_cmdshell... Read More

Store Procedure to get a Multiple Category 1 min read

• Sql server

Store Procedure to get a Multiple Category

Mahesh Javiya 14 years ago

WITH CATEGORYVIEW (cat_Id, cat_ParentId,cat_orgname, cat_name,Main_catId,MainCatName ,cat_image,cat_displayorder,cat_IsShow) AS ( SELECT cat_Id, cat_ParentId,cat_name,cast(cat_name as varchar(255)),cast(cat_Id as varchar(255)),cast(cat_name as varchar(255)),cat_image,cat_displayorder,cat_IsShow FROM [CATEGORY_MST] WHERE isnull(cat_ParentId,0) = 0 UNION ALL... Read More