ASPSnippets: Questions

makumbi

Use While Loop for updating data in Table in SQL Server

makumbi

[Solved] SQL Server Stored Procedure Error: incorrect syntax near else

Bhavesh2...

Count no of employees date wise from single column in SQL Server

pandeygo...

Select data that will expire in next 30 days in SQL server

indradeo

Query to return Pivoted result in SQL Server

pandeygo...

Return GUID value after insert in SQL Server

Richa

Parse JSON and update only if not duplicate in SQL Server

Richa

[Solved] SQL Server Error: Violation of PRIMARY KEY constraint Cannot insert duplicate key

pandeygo...

Update Boolean value in selected column in last Row in SQL Server

pandeygo...

Count Active Inactive and Total records in SQL Server

pandeygo...

Display count of Active, Inactive and Total records using Join query in SQL Server

pandeygo...

Select all records whose EndDate is greater than Current Date in SQL Server

mukesh1

SQL Server: Find Max for each row in Pivot Table

malar

Check record exists by splitting particular column value in SQL Server

shubhkar...

Display current quarter start and end date of specified date in SQL Server

RichardS...

Trusted connection in SQL Server Authentication connection string

RichardS...

Create User for SQL Server on Plesk server

RichardS...

Upload MSSQL server database to Plesk control panel

RichardS...

Restore Database from MDF file to SQL Server Database

RichardS...

Transfer Table records and stored procedures from one Database to another in SQLServer

Questions

Use While Loop for updating data in Table in SQL Server

[Solved] SQL Server Stored Procedure Error: incorrect syntax near else

Count no of employees date wise from single column in SQL Server

Select data that will expire in next 30 days in SQL server

Query to return Pivoted result in SQL Server

Return GUID value after insert in SQL Server

Parse JSON and update only if not duplicate in SQL Server

[Solved] SQL Server Error: Violation of PRIMARY KEY constraint Cannot insert duplicate key

Update Boolean value in selected column in last Row in SQL Server

Count Active Inactive and Total records in SQL Server

Display count of Active, Inactive and Total records using Join query in SQL Server

Select all records whose EndDate is greater than Current Date in SQL Server

SQL Server: Find Max for each row in Pivot Table

Check record exists by splitting particular column value in SQL Server

Display current quarter start and end date of specified date in SQL Server

Trusted connection in SQL Server Authentication connection string

Create User for SQL Server on Plesk server

Upload MSSQL server database to Plesk control panel

Restore Database from MDF file to SQL Server Database

Transfer Table records and stored procedures from one Database to another in SQLServer