-
Wriete a Email sending code given below ?
public static void SendMail(string mailto, string from, string Subject, string body) { string mailbody = body; MailAddr...
READ MORE
-
Write a script given below generate sql server database backup using command prompt ?
C:\Users\HP>sqlcmd -S LAPTOP-0JOL6IEH\MSSQLSERVER2022 -U sa -P sa123 -Q "BACKUP DATABASE sewayojan_live TO DISK='D:\dbbackpform...
READ MORE
-
Write a query using COUNT and HAVING clause ?
SELECT FamilyId, COUNT(FamilyId) FROM tblFamilyMembersDetails_VD GROUP BY FamilyId HAVING COUNT(FamilyId) > 2
READ MORE
-
Replace Data in Column Sql server Query
UPDATE users SET loginId = REPLACE(loginId, 'GBPU', 'GMVN') WHERE loginId LIKE 'GBPU%';
READ MORE
-
First Name Split Query into First Name , Middle Name or Last Name
SELECT MEMBERID, FirstName INTO #Javed FROM (SELECT memberid, FullName, FirstName, CASE WHEN 0 = CHARINDEX(' ...
READ MORE
-
Full Name text split in firstname,middlename,lastname and aslo conconate firstname+middlename given below query with database table
SELECT FullName, FullName.FirstName, CASE WHEN 0 = CHARINDEX(' ', FullName.REST_OF_NAME) THEN NULL --no more s...
READ MORE
-
Javascript Json Datatable
<table class="table table-striped- table-bordered table-hover table-checkable table-sm" id="table_pend10"> ...
READ MORE
