Ajit Agarwal C#Zone: 2017

Saturday 25 November 2017

Store Procedure for crud operation with transaction and exception handling (try catch block)

CREATE TABLE [dbo].[tblCustomer](
[CustID] [bigint] NOT NULL,
[CustName] [nvarchar](50) NULL,
[CustEmail] [nvarchar](50) NOT NULL,
[CustAddress] [nvarchar](256) NULL,
[CustContact] [nvarchar](50) NULL,
CONSTRAINT [PK_tblCustomer] PRIMARY KEY CLUSTERED
(
[CustID] ASC,
[CustEmail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE PROCEDURE [dbo].[SP_CUSTOMER_INSERT]

(

@CustName NVarchar(50)

,@CustEmail NVarchar(50)

,@CustAddress NVarchar(256)

,@CustContact NVarchar(50)

)

AS BEGIN

SET NOCOUNT ON;

BEGIN TRY

BEGIN TRANSACTION

DECLARE @CustID Bigint

SET @CustID = isnull(((SELECT max(CustID) FROM [dbo].[tblCustomer])+1),'1')

Insert INTO tblCustomer(CustID,CustName,CustEmail,CustAddress,CustContact)Values(@CustID,@CustName,@CustEmail,@CustAddress,@CustContact)

Select 1

Commit Transaction

End Try

BEGIN CATCH

DECLARE @ErrorMessage NVARCHAR(4000),@ErrorSeverity INT,@ErrorState INT;

SELECT @ErrorMessage = ERROR_MESSAGE(),@ErrorSeverity = ERROR_SEVERITY(),@ErrorState = ERROR_STATE();

RAISERROR (@ErrorMessage,@ErrorSeverity,@ErrorState);

Rollback Transaction

END Catch

End

CREATE PROCEDURE [dbo].[SP_CUSTOMER_DELETE]

@CustID BIGINT

BEGIN

SET NOCOUNT ON;

BEGIN TRY

BEGIN TRANSACTION

DELETE tblCustomer

WHERE [CustID] = @CustID

SELECT 1

COMMIT TRANSACTION

END TRY

BEGIN CATCH

DECLARE @ERROR_MEASSAGE NVARCHAR(4000),@ERRORSERVERITY INT , @ERRORLINE INT ,@ERRORSTATE INT;

SELECT @ERROR_MEASSAGE=ERROR_MESSAGE(),@ERRORSERVERITY=ERROR_SEVERITY(),@ERRORLINE=ERROR_LINE(),@ERRORSTATE=ERROR_STATE();

RAISERROR (@ERROR_MEASSAGE ,@ERRORSERVERITY,@ERRORLINE,@ERRORSTATE);

ROLLBACK TRANSACTION

END CATCH

END

CREATE PROCEDURE [dbo].[SP_CUSTOMER_UPDATE]

@CustID BIGINT

,@CustName NVarchar(50) =NULL

,@CustEmail NVarchar(50) =NULL

,@CustAddress NVarchar(256) =NULL

,@CustContact NVarchar(50) =NULL

BEGIN

SET NOCOUNT ON

BEGIN TRY

BEGIN TRANSACTION

UPDATE [dbo].[tblCustomer]

SET CustName=@CustName,

CustAddress=@CustAddress,

CustContact=@CustContact

WHERE CustID=@CustID AND [CustEmail]=@CustEmail

COMMIT TRANSACTION

END TRY

BEGIN CATCH

SELECT 1

DECLARE @ErrorMessage NVARCHAR(200),@ErrorSeverity INT ,@ErrorState int,@ErrorLinenumber INT;

select @ErrorMessage =ERROR_MESSAGE(),@ErrorSeverity=ERROR_SEVERITY(), @ErrorState=ERROR_STATE(),@ErrorLinenumber=ERROR_LINE();

SELECT @ErrorMessage,@ErrorSeverity,@ErrorState,@ErrorLinenumber

RAISERROR(@ErrorMessage,@ErrorSeverity,@ErrorState,@ErrorLinenumber)

ROLLBACK TRANSACTION

END CATCH

END

CREATE PROCEDURE [dbo].[SP_SELECT_CUSTOMER_BY_ID]

@CustID BIGINT

AS BEGIN

SET NOCOUNT ON;

BEGIN TRY

BEGIN TRANSACTION

SELECT * FROM [dbo].[tblCustomer]

WHERE CustID=@CustID

SELECT 1

COMMIT TRANSACTION

END TRY

BEGIN CATCH

DECLARE @ERRORMESAGE NVARCHAR(400),@ERRORSERVERITY INT,@ERRORSTATUS INT, @ERRORLINE INT,@ERRORPROCEDURE NVARCHAR(50);

SELECT @ERRORMESAGE=ERROR_MESSAGE(),@ERRORsERVERITY=ERROR_SEVERITY(),@ERRORSTATUS=ERROR_STATE(),@ERRORLINE=ERROR_LINE(),

@ERRORPROCEDURE=ERROR_PROCEDURE();

RAISERROR (@ERRORMESAGE,@ERRORsERVERITY,@ERRORSTATUS,@ERRORLINE,@ERRORPROCEDURE)

ROLLBACK TRANSACTION

END CATCH

END

---------------------------------------------------------------------
Note: -Default exception in SQL Server 2014 is

ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_LINE() AS ErrorLine, ERROR_MESSAGE() AS ErrorMessage;

The severity parameter specifies the severity of the exception.

Tuesday 14 November 2017

Paging store Procedure to increase the performance data loading

DECLARE @PageNum AS INT;
DECLARE @PageSize AS INT;
SET @PageNum = 2;
SET @PageSize = 10;

WITH OrdersRN AS
(
    SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, OrderID) AS RowNum
          ,OrderID
          ,OrderDate
          ,CustomerID
          ,EmployeeID
      FROM dbo.Orders
)

SELECT * 
  FROM OrdersRN
 WHERE RowNum BETWEEN (@PageNum - 1) * @PageSize + 1 
                  AND @PageNum * @PageSize
 ORDER BY OrderDate
         ,OrderID;

Friday 3 November 2017

Splite Function use4

declare @receivedsetupPeriod varchar(1000),@currentperiod varchar(1000),@toperiod varchar(1000),@fromperiod varchar(1000)
select @receivedsetupPeriod = tbl_ReceivalbeSetupPeriodId,@currentperiod = CurrentPeriod,@toperiod = [TO],@fromperiod= [FROM] from tbl_ReceivableSetup

select R.Id,R.Item as receivedid,C.Item as Currentperiod,T.Item as [To],F.Item as [From] from
dbo.SplitString(@receivedsetupPeriod,',') R
Join
dbo.SplitString(@currentperiod,',') C ON R.Id=C.Id
Join
dbo.SplitString(@toperiod,',') T ON T.Id=C.Id
Join
dbo.SplitString(@fromperiod,',') F ON T.Id=F.Id

Monday 9 October 2017

How to Identify Error Line , Message in store Procedure (1)at time of Exception Handling .

CREATE TABLE [dbo].[tbl_dbLogs](
[LogSerialId] [int] IDENTITY(1,1) NOT NULL,
[Error_line] [int] NULL,
[ERROR_MESSAGE] [nvarchar](max) NULL,
[ERROR_PROCEDURE] [nvarchar](100) NULL,
[CreateDate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

Alter Procedure SP_PaymentToSupplierEmployee_Periodically

@tbl_OrganizationId nvarchar(50)

BEGIN

SET NOCOUNT ON;

Begin try

SELECT

COUNT(tbl_PaymentToSupplierEmployeeId) As TotalTransaction, DateName(wk,PaymentDate)As [Week],DateName(d, PaymentDate)As [days], DateName(dw,PaymentDate) As [DayName], DateName(m,PaymentDate) AS [month],

DateName(qq,PaymentDate) As [Quarter],DateName(yy, PaymentDate) As [Year],

SUM(Total) As TotalRevenue, case when IsPosted='False' then count(IsPosted)end As pending,

CASE WHEN IsPosted='true' then count(IsPosted)end As Posted

FROM tbl_PaymentToSupplierEmployee

--WHERE IsDeleted='False' And tbl_OrganizationId='42D1401E-EA99-42E2-8954-2969858CE625'

WHERE IsDeleted='False' And tbl_OrganizationId=@tbl_OrganizationId

GROUP BY PaymentDate,IsPosted

End try

Begin catch

insert into tbl_dbLogs([Error_line],[ERROR_MESSAGE],[ERROR_PROCEDURE],CreateDate)values(ERROR_LINE(),ERROR_MESSAGE(),ERROR_PROCEDURE(),GetDate())

End catch

End

Sunday 24 September 2017

How to fetch/ retrieve data in period order (Day,week,Month,Quarter,year) from SQL Server with aggregate function.

CREATE Procedure SP_PaymentToSupplierEmployee_Periodically
@tbl_OrganizationId nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
SELECT
COUNT(tbl_PaymentToSupplierEmployeeId) As TotalTransaction, DateName(wk,PaymentDate)As [Week],DateName(d, PaymentDate)As [days], DateName(dw,PaymentDate) As [DayName], DateName(m,PaymentDate) AS [month],
DateName(qq,PaymentDate) As [Quarter],DateName(yy, PaymentDate) As [Year],
SUM(Total) As TotalRevenue, case when IsPosted='False' then count(IsPosted)end As pending,
CASE WHEN IsPosted='true' then count(IsPosted)end As Posted
FROM tbl_PaymentToSupplierEmployee
WHERE IsDeleted='False' And tbl_OrganizationId=@tbl_OrganizationId
GROUP BY PaymentDate,IsPosted
END

Thursday 7 September 2017

How to consume wcf service using Jquery.

Data Base:-

CREATE TABLE [dbo].[tbl_registration](
[FormID] [int] IDENTITY(1,1) NOT NULL,
[ModelName] [nvarchar](50) NULL,
[RegFees] [float] NULL,
[RegNo] [nvarchar](50) NOT NULL,
[SmartNo] [nvarchar](50) NULL,
[CustomerName] [nvarchar](50) NULL,
[Address] [nvarchar](150) NULL,
[Location] [nvarchar](50) NULL,
[Contactno] [nvarchar](50) NULL,
[EngineNo] [nvarchar](50) NULL,
[chassisaNo] [nvarchar](50) NULL,
[PurchaseDate] [datetime] NULL,
[validupto] [datetime] NULL,
[RegDate] [datetime] NULL,
[username] [nvarchar](50) NULL,
CONSTRAINT [PK_tbl_registration] PRIMARY KEY CLUSTERED
(
[RegNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE procedure [dbo].[SP_RegistrationDetails]

@FormID int

AS BEGIN

Select * from tbl_registration

where FormID= @FormID

END

-------------------------------------------------------------------------------------------------------------------------

File--New--Project eg- Demo

Add-New Item -registrationDetails.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace Demo

{

public class registrationDetails

{

public int FormID { get; set; }

public string ModelName { get; set; }

public Decimal RegFees { get; set; }

public string RegNo { get; set; }

public string SmartNo { get; set; }

public string CustomerName { get; set; }

public string Address { get; set; }

public string Location { get; set; }

public string Contactno { get; set; }

public string EngineNo { get; set; }

public string chassisaNo { get; set; }

public string PurchaseDate { get; set; }

public string validupto { get; set; }

public string RegDate { get; set; }

public string username { get; set; }

}

}

Add-New Item-WCF Service(Ajax-Enable) eg-RegistrationServices

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Activation;

using System.ServiceModel.Web;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace Demo

{

[ServiceContract(Namespace = "")]

[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

public class RegistrationServices

{

[OperationContract]

public registrationDetails GetRegistrationById(int FormID)

{

registrationDetails rd = new registrationDetails();

string cs = ConfigurationManager.ConnectionStrings["dmo"].ConnectionString;

using (SqlConnection con = new SqlConnection(cs))

{ SqlCommand cmd = new SqlCommand("SP_RegistrationDetails", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter param = new SqlParameter();

param.ParameterName = "@FormID";

param.Value = FormID;

cmd.Parameters.Add(param);

con.Open();

SqlDataReader sdr = cmd.ExecuteReader();

while (sdr.Read())

{

rd.ModelName = sdr["ModelName"].ToString();

rd.RegFees = Convert.ToDecimal(sdr["RegFees"]);

rd.RegNo = sdr["RegNo"].ToString();

rd.SmartNo = sdr["SmartNo"].ToString();

rd.CustomerName = sdr["CustomerName"].ToString();

rd.Address = sdr["Address"].ToString();

rd.Location= sdr["Location"].ToString();

rd.Contactno = sdr["Contactno"].ToString();

rd.EngineNo = sdr["EngineNo"].ToString();

rd.chassisaNo = sdr["chassisaNo"].ToString();

rd.PurchaseDate = sdr["PurchaseDate"].ToString();

rd.validupto = Convert.ToString(sdr["validupto"]);

rd.RegDate = Convert.ToString(sdr["RegDate"]);

rd.username = Convert.ToString(sdr["username"]);

}

return rd;

}

web Config :-

</connectionStrings>

---------------------------------------------------------------------------------------------------------

Add-New Item-Web Form egWebForm1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Demo.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

https://github.com/ajitagarwal89/WCF-USING-JQUERY

Saturday 1 July 2017

Delegate in c#

What is Delegate in C#.

Delegate is an object which holds the references to a method within the delegate object.It is type safe object and invoking the method asynchronously manner.

Advantage of Delegates

1 Improved the performance of Application
2 Call a method asynchronous.

Type of Delegate
1. Single Delegate and
2 Multicast Delegate
3 Generic Delegate

Single Delegate :-A delegate is need to pass single parameter as reference to a method with the delegate object.

using System;
using System.Collections.Generic;
using System.Text;

namespace DelegateTest
{
public delegate void Calc(int x, int y);

    class A    {
        public void add(int x, int y)
        {
            Console.WriteLine("The Sum is " + (x + y));
        }

        public void sub(int x, int y)
        {
            Console.WriteLine("The Difference is " + (x - y));
            Console.ReadLine();
        }
    }

    class Program    {
        static void Main(string[] args)
        {
            A obj = new A();
            //make an object of class A
  Calc objsum= new numtest(obj.add);
  objsum(10, 20);
  Calc objsub= new numtest(obj.sub);
  objsub(10, 20);
        }
    }
}

https://msdn.microsoft.com/en-us/library/system.delegate.aspx

Multicast Delegate: - When we need to pass more than one parameter as reference to a method within delegate object.

Wednesday 28 June 2017

How to find schema changes report in SQL Server ?

Select o.name As [Objcet_Name],
s.name [Schema_Name],
o.type_desc [Description],
o.create_date [Creation_Date],
o.modify_date [Modified_Date]
from sys.all_objects o
Left outer join sys.schemas s
on o.schema_id=s.schema_id
where create_date >(GETDATE()-7) or modify_date >(GETDATE()-7)

Or

We can check SSMS Wizard .

Step 1:- Select Database

Step 2:-click right mouse button and Select Report.

Step 3:- Select Standard

Step 4: finally Select Schema change History .

Tuesday 20 June 2017

How to rest asp.net control in web form.

Protected void Clear()
{
foreach(Control ctrl in Form.Control)
{
//Text Box Control
if(ctr is TextBox)
{
((TextBox )(ctrl)).Text="";
}
// Label Control
else if(ctrl is Label)
{
((Label)(ctrl)).Text = "";
}
//DropDownList controls
else if(ctrl is DropDownList)
{
((DropDownList)(ctrl)).ClearSelection();
or
((DropDownList)(ctrl)).selectedIndex = 0;
}
//CheckBox controls
else if (ctrl is CheckBox)
{
((CheckBox)(ctrl)).Checked = false;
}
//RadioButton controls
else if (ctrl is RadioButton)
{
((RadioButton)(ctrl)).Checked = false;
}
}
}

Tuesday 6 June 2017

ASP.NET Interview Q&A

How to Delete Cookies?

HttpCookie currentUser=HttpContext.Current.Request.Cookies["CookiesValue"];
HttpContext.Current.Response.Cookies.Remove("CookiesValue");
currentUser.Expires=DataTime.Now.AddMinutes(-20);
currentUser.value=null;
HttpContext.Current.Response.SetCookie(currentUser);

Delegate is an object which holds the references to a method within the delegate object.It is type safe object and invoking the method asynchronously manner.

Advantage of Delegates

1 Improved the performance of Application
2 Call a method asynchronous.

Type of Delegate
1. Single Delegate and
2 Multicast Delegate
3 Generic Delegate

Single Delegate :-A delegate is need to pass single parameter as reference to a method with the delegate object.

Multicast Delegate: - When we need to pass more than one parameter as reference to a method within delegate object.

--- String and number Reverse--

namespace ConsoleApp3
{
class Program
{
static void Main(string[] args)
{ //---reverse string ----
//Console.WriteLine("Enter a number for reverse");
//int number = Convert.ToInt32(Console.ReadLine());
//int revers = 0;
//while (number > 0)
//{
// int rem = number % 10;
// revers = (revers * 10) + rem;
// number = number / 10;
//}
//Console.WriteLine(revers);
//Console.ReadLine();
//-- Reverse string--
Console.WriteLine("enter your name");
string name = Console.ReadLine();
var temp = "";
for (int i = name.Length - 1; i >= 0; i--)
{
temp += name[i].ToString();

}
Console.WriteLine(temp);
Console.ReadLine();

}
}
}

----- Duplicate character in string --
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp4
{
class Program
{
static void Main(string[] args)
{
Console.Write("Enter a word");
string data = Console.ReadLine();

RemoveDuplicatecharacter(data);
}
static string RemoveDuplicatecharacter(string value)
{
string result = string.Empty;
string temp = string.Empty;
foreach (char data in value)
{
if (temp.IndexOf(data) == -1)
{
temp += data;
result += data;
}
}
Console.WriteLine(result);
Console.Read();
return result;

}
}
}

SQL INTERVIEW QUESTION

tbl_employee

EmployeeId EmployeeName Gender
1 ABC male
2 YYC Female
Question: update all male into female and all female into Male
Ans';-
Update tbl_employee
Set Gender=case Gender When 'Male' Then Female When 'Female' Then 'Male' Else gender End.

----------------------------------------------------------------------------------------------------------------------------------------

Different between Store procedure and function are

SNo	Function	Store Procedure
1	Function must return a value.	Stored procedure may or not return values.
2	Will allow only Select statement, it will not allow us to use DML statements.	Can have select statements as well as DML statements such as insert, update, delete etc
3	It will allow only input parameters, doesn’t support output parameters.	It can have both input and output parameters.
4	It will not allow us to use try-catch blocks.	For exception handling, we can use try-catch blocks.
5	Transactions are not allowed within functions.	Can use transactions within Stored procedures.
6	We can use only table variables, it will not allow using temporary tables.	Can use both table variables as well as a temporary table in it.
7	Stored procedures can’t be called from function.	Stored Procedures can call functions.
8	Functions can be called from the select statement.	Procedures can’t be called from Select/Where/Having etc statements. Execute/Exec the statement can be used to call/execute the stored procedure.
9	function can be used in join clause as a result set.	Procedures can’t be used in Join clause

Q- HowTo find out the Nth highest salary (for example: here I am finding 3rd highest salary),

A-

SELECT EmpId, LastName, Salary FROM Employee

EmpId LastName Salary

1 Agarwal 50000

2 Agarwal 50000

4 Kumar 60000

5 Agarwal 75000

6 Agarwal 75000

SELECT EmpId,LastName, Salary FROM Employee a1 WHERE 3-1= (SELECT COUNT(DISTINCT Salary) FROM Employee a2 WHERE a2.Salary > a1.Salary)

EmpId LastName Salary

1 Agarwal 50000

2 Agarwal 50000

SELECT TOP 1 SAL FROM(SELECT DISTINCT TOP 2 SAL FROM EMP ORDER BY SAL DESC) AS TEMP
Order by SAL ASC

----------------------------------------------------------------------------------
-- PAGING---
----------------------------------------------------------------------------------
SELECT * FROM (SELECT ROW_NUMBER() OVER( Order By OrderItems_PKey) AS RowNum,* FROM OrderItems) AS RESULT
WHERE RowNUM >=10 AND RowNum <=20
order by RowNum

------------------------------------------------------------------------------
select * from InventoryItem-- DELETIG THE DUPLICATE REOCRED
------------------------------------------------------------------------------
DELETE from InventoryItem
where InventoryItem_ID Not in
(select max (InventoryItem_ID)
from InventoryItem
group by Name)
-------------------------------------------------------------------------
SELECT * FROM Orders--- SECOND COSTLY ORDER VALUE

SELECT max(GrandTotal)FROM Orders WHERE GrandTotal NOT IN (SELECT MAX(GrandTotal) FROM Orders);
------------------------------------------------------------------------------------------------
--To get list of primary AND FOREIGN KEY IN ENTIRE DATABASE------------
--------------------------------------------------------------------------------------------
select distinct
constraint_Name as [ConstraintName],
Table_Name As [Table Name]from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
------------------------------------------------------------------------------

How to find second or nth maximum salary from Employee table?
Here EMP is Table and SAL Is Salary Filed

SELECT * FROM EMP emp1
WHERE(2)=(SELECT COUNT(DISTINCT(emp2.SAL)) FROM EMP emp2 WHERE emp2.SAL >=emp1.SAL)

----------------------------------------------------------------------------------------------------------------

Friday 3 March 2017

Find out the second highest no in array.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ArrayManipulation

{

class Program

{

static void Main(string[] args)

{

int[] myarr = new Int32[] { 1, 8, 9, 88, 77, 76, 22, 225 };

int mxval = 0;

int secondHv = 0;

int sum = 0;

int count = 0;

int avg = 0;

foreach (int i in myarr)

{

if (i > mxval)

{

secondHv = mxval;

mxval = i;

}

else if (i > secondHv)

secondHv = i;

sum += i;

count++;

avg = sum / count;

}

Console.WriteLine(mxval);

Console.WriteLine(secondHv);

Console.WriteLine(sum);

Console.WriteLine(count);

Console.WriteLine(avg);

Console.ReadLine();

}

Ajit Agarwal C#Zone

Saturday 25 November 2017

Store Procedure for crud operation with transaction and exception handling (try catch block)

Tuesday 14 November 2017

Paging store Procedure to increase the performance data loading

Friday 3 November 2017

Splite Function use4

Monday 9 October 2017

How to Identify Error Line , Message in store Procedure (1)at time of Exception Handling .

Sunday 24 September 2017

How to fetch/ retrieve data in period order (Day,week,Month,Quarter,year) from SQL Server with aggregate function.

Thursday 7 September 2017

How to consume wcf service using Jquery.

Saturday 1 July 2017

Delegate in c#

Wednesday 28 June 2017

How to find schema changes report in SQL Server ?

Select o.name As [Objcet_Name],
s.name [Schema_Name],
o.type_desc [Description],
o.create_date [Creation_Date],
o.modify_date [Modified_Date]
from sys.all_objects o
Left outer join sys.schemas s
on o.schema_id=s.schema_id
where create_date >(GETDATE()-7) or modify_date >(GETDATE()-7)

Or

Tuesday 20 June 2017

How to rest asp.net control in web form.

Tuesday 6 June 2017

ASP.NET Interview Q&A

SQL INTERVIEW QUESTION

Friday 3 March 2017

Find out the second highest no in array.

How to get logged in User's Security Roles using Java Script in dynamic CRM 365.

Report Abuse

Labels

Saturday 25 November 2017

Tuesday 14 November 2017

Friday 3 November 2017

Monday 9 October 2017

Sunday 24 September 2017

Thursday 7 September 2017

Saturday 1 July 2017

Wednesday 28 June 2017

Select o.name As [Objcet_Name], s.name [Schema_Name], o.type_desc [Description], o.create_date [Creation_Date], o.modify_date [Modified_Date] from sys.all_objects o Left outer join sys.schemas s on o.schema_id=s.schema_id where create_date >(GETDATE()-7) or modify_date >(GETDATE()-7)

Or

Tuesday 20 June 2017

Tuesday 6 June 2017

Friday 3 March 2017

Select o.name As [Objcet_Name],
s.name [Schema_Name],
o.type_desc [Description],
o.create_date [Creation_Date],
o.modify_date [Modified_Date]
from sys.all_objects o
Left outer join sys.schemas s
on o.schema_id=s.schema_id
where create_date >(GETDATE()-7) or modify_date >(GETDATE()-7)