sql
SQL - Pivot with Grand Total Column and Row
SQL - Pivot with Grand Total Column and Row CREATE PROCEDURE [dbo].[PY_getPYdetails] @ pageIndex int = null , @ pageSize int = null , @ …
sql
create update combined sql server procedure
CREATE PROCEDURE [dbo].[sp_CreateUpdateCompany] ( -- Add the parameters for the stored procedure here @CompanyId uniqueidentifier = '00000000-0000-0000-0000-000000000000' , @Com…
sql
Date functions in Sql server
CREATE FUNCTION [dbo].[DateFormate] (@ input Date) RETURNS NVARCHAR(50) AS BEGIN DECLARE @Date NVARCHAR(50) SET @Date = CONVERT (NVARCHAR,@ input , 103) RETURN @Date END CR…
sql
sample store procedure for searching, sorting, count and paging
CREATE PROCEDURE csp_GetAllPatients @orderBy NVARCHAR(250) = 'Name' ,@isDescending BIT = 1 ,@pageNumber INT = 1 ,@rowsPerPage INT =10 ,@searchWord NVARCHAR(250) = null AS BEGIN …
sql
Search all tables in Database
Create store procedure to search all table in Database Search all table in database in sql server 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 …
sql
encrypt and decrypt in sql
Encryption, Decryption in Sql 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 -- encrypt function CREATE function [dbo].[Encrypt](@str nvarchar( max )) returns varbinary( m…
