For generate random alphanumeric string in sql server, use following query:
SELECT CAST((ABS(CHECKSUM(NEWID()))%10) as varchar(1)) + CHAR(ASCII('a')+(ABS(CHECKSUM(NEWID()))%25)) + CHAR(ASCII('A')+(ABS(CHECKSUM(NEWID()))%25)) + left(NEWID(),5)
This will return alphanumeric string with 8 digit.If you want to use this query to sql server function then refer my another blog from following link:Use NEWID() in sql server functi...
Thursday, October 11, 2018
Wednesday, October 10, 2018
How to use NEWID() in sql server function
Sql server function not allow to use NEWID() function.Solution:-> Create view in same database from following query:CREATE VIEW [dbo].[GetNewID] AS SELECT NEWID() AS new_idNow you can use SELECT new_id FROM [dbo].[GetNewID] instead of NEWID() in your query in sql server functio...
Friday, April 27, 2018
get data for candle chart as per specific interval from sql server
Query for get data as per specific interval
Assume tablename=UserOrders,column=Price,column for date=CreatedDate, column for confirm order=Status, column for delete row status=IsActive:
Query:
For @interval you can pass any int value.(for ex. for 1 day interval you can pass 1440)
DECLARE
@interval INT
SELECT DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,CreatedDate)/@interval)*@interval,0) [date],MAX(Price) high,Min(Price) as low,
ISNULL((SELECT TOP 1 Price FROM
UserOrders WHERE DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,CreatedDate)/@interval)*@interval,0)=DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,U.CreatedDate)/@interval)*@interval,0)...
Monday, March 19, 2018
Redirect every request to https from http in angular 5
Write in app.component.ts file:
import
{ environment } from
'../environments/environment.prod';
ngOnInit()
{
if (!isDevMode()
&& environment.production)
{
if (location.protocol
=== 'http:') {
window.location.href
= location.href.replace('http',
'https');
}
}
}
Write your environment.prod.ts file like:
export const environment = {
production: true
};...
Manage Audit using DbContext in Entity Framework 6
By Vimal Vataliya
1:44 AM
Audit,
Audit in entity framework,
Track changes in entity framework
Leave a Comment
Create table in sql server (AuditMaster):
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [AuditMaster](
[AuditId] [int] IDENTITY(1,1) NOT NULL,
[TableName] [nvarchar](100) NOT NULL, -- for table name
[PrimaryKeyValues] [nvarchar](100) NOT NULL, -- for identity value of affected table
[Description] [nvarchar](max) NOT NULL, -- store one string
here for...