Home - Learn & Grow with Popular eLearning Community - JanBask

dummy-image

rachit_6798

com-icon3

Discussions

What is the CURRENT_DATE or current date value function for SQL Server?

Asked by rachit_6798 in Salesforce, Asked on Aug 23, 2021

0
ANSWER

447
Views

How to find all occurrences of a substring?

Asked by rachit_6798 in Devops, Asked on Jul 18, 2021

0
ANSWER

480
Views

AngularJS access parent scope from child controller

Asked by rachit_6798 in Devops, Asked on Jul 1, 2021

0
ANSWER

480
Views

How can stored procedure retrieve from a database?

Asked by rachit_6798 in SQL Server, Asked on Jan 5, 2020

5 | 0

0
ANSWER

605
Views

What are all operations not allowed in user defined functions?

Asked by rachit_6798 in SQL Server, Asked on Feb 15, 2020

5 | 0

0
ANSWER

689
Views

How to use the out parameter and In/out parameter while executing the procedure?

Asked by rachit_6798 in SQL Server, Asked on Feb 5, 2020

4 | 0

0
ANSWER

717
Views

Can we execute procedure inside a procedure? Can you create a recursive procedure?

Asked by rachit_6798 in SQL Server, Asked on Feb 3, 2020

7 | 0

0
ANSWER

655
Views

How to capture exceptions which are raised during the execution of procedure via table

Asked by rachit_6798 in SQL Server, Asked on Jan 29, 2020

4 | 0

0
ANSWER

618
Views

How can we roll-back to a specific point while executing a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 29, 2020

4 | 0

0
ANSWER

629
Views

How to create a Multi-statement table valued function?

Asked by rachit_6798 in SQL Server, Asked on Jan 28, 2020

4 | 0

0
ANSWER

592
Views

How can one transaction be successful in multiple transaction and one fails

Asked by rachit_6798 in SQL Server, Asked on Jan 28, 2020

9 | 0

0
ANSWER

993
Views

What are temporary Stored procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 28, 2020

9 | 0

0
ANSWER

853
Views

How can we find the stored procedure in the database if we have just some idea of the procedure name?

Asked by rachit_6798 in SQL Server, Asked on Jan 27, 2020

9 | 0

0
ANSWER

626
Views

How to decide which one to use table variables or any temporary table or a permanent table in a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 27, 2020

8 | 0

0
ANSWER

596
Views

How to modify/alter and delete/drop a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 26, 2020

4 | 0

0
ANSWER

683
Views

What are the different types of procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 25, 2020

7 | 0

0
ANSWER

918
Views

How will the transaction work with nested procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 25, 2020

7 | 0

0
ANSWER

739
Views

What are the places where temporary stored procedures can be used?

Asked by rachit_6798 in SQL Server, Asked on Jan 25, 2020

7 | 0

0
ANSWER

604
Views

What are the stored procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 20, 2020

8 | 0

0
ANSWER

571
Views

How many ways can procedures be executed?

Asked by rachit_6798 in SQL Server, Asked on Jan 19, 2020

5 | 0

0
ANSWER

587
Views

How can data insert/update/delete in a table using a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 18, 2020

6 | 0

0
ANSWER

709
Views

How to optimize a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 18, 2020

9 | 0

0
ANSWER

641
Views

Is it allowed to perform DDL/DML operations on tables in the procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 17, 2020

8 | 0

0
ANSWER

737
Views

How can you send mail on an exception raised in procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 16, 2020

7 | 0

0
ANSWER

1.3K
Views

How to debug a stored procedure using print statements and time analyses for each statement?

Asked by rachit_6798 in SQL Server, Asked on Jan 16, 2020

7 | 0

0
ANSWER

3.7K
Views

How can a table be passed as parameter to another procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 14, 2020

4 | 0

0
ANSWER

642
Views

What is deferred name resolution in SQLs server?

Asked by rachit_6798 in SQL Server, Asked on Jan 14, 2020

4 | 0

0
ANSWER

612
Views

How can you pass parameter and get the data back from the procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 13, 2020

6 | 0

0
ANSWER

598
Views

How can you perform multiple different operations using a procedure without impacting any other object?

Asked by rachit_6798 in SQL Server, Asked on Jan 13, 2020

7 | 0

0
ANSWER

607
Views

How can stored procedure help in preventing SQL injection?

Asked by rachit_6798 in SQL Server, Asked on Jan 13, 2020

6 | 0

0
ANSWER

595
Views

What are the Benefits of Stored Procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 12, 2020

6 | 0

0
ANSWER

569
Views

What are functions in SQL server?

Asked by rachit_6798 in SQL Server, Asked on Jan 12, 2020

7 | 0

0
ANSWER

573
Views

How to create a function/ view/ trigger/ procedure inside a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 11, 2020

5 | 0

0
ANSWER

638
Views

How to create scalar function?

Asked by rachit_6798 in SQL Server, Asked on Jan 10, 2020

6 | 0

0
ANSWER

609
Views

How to set up an audit for the tables using procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 10, 2020

6 | 0

0
ANSWER

630
Views

How are temporary tables used in stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 9, 2020

6 | 0

0
ANSWER

676
Views

How to create a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

4 | 0

0
ANSWER

578
Views

System functions are segregated into how many types will be examples of each type.

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

6 | 0

0
ANSWER

567
Views

How can you send mail from a procedure with an attachment?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

5 | 0

0
ANSWER

597
Views

How are table variables used in stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

5 | 0

0
ANSWER

573
Views

Can we maintain multiple transactions inside a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 7, 2020

5 | 0

0
ANSWER

717
Views

What are the different procedure attributes in SQL server?

Asked by rachit_6798 in SQL Server, Asked on Jan 7, 2020

5 | 0

0
ANSWER

723
Views

How to find (max, AVG, COUNT, SUM, and MIN) in the row/ columnFor calculating the operations on the column we will have to find max, AVG, COUNT, SUM, and MIN of salary then below will be operation:

Asked by rachit_6798 in SQL Server, Asked on Dec 29, 2019

7 | 0

0
ANSWER

563
Views

How to find the first day for the current month, last day of the current month, first day of next month, last day of next month, First day of previous month, last day of current month, first day of current year, last day of current year?

Asked by rachit_6798 in SQL Server, Asked on Dec 19, 2019

4 | 0

0
ANSWER

40.0K
Views

State some Uses of function.

Asked by rachit_6798 in SQL Server, Asked on Dec 16, 2019

5 | 0

0
ANSWER

554
Views

Difference between nullif and isnull

Asked by rachit_6798 in SQL Server, Asked on Nov 21, 2019

7 | 0

0
ANSWER

1.0K
Views

If you are given an xml (as a table) as input and you want to store that XML in the database. How can be work with update/ insert from the XML

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

502
Views

How to remove duplicate rows from a given table, when there is a unique key based on more than one column.And you have to keep the latest record based on the modified date/ create date

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

1.8K
Views

How can you fetch the data from different types of server (oracle/ big data/Teradata) to SQL server, within a procedure?

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

488
Views

Which function you will use if you have to give one rank to one person no duplicate ranks, whether value is same or not.

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

645
Views

How to use table variables and temporary tables in function?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

521
Views

What all joins do functions and tables support?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

536
Views

What are differences and similarities between CharIndex, patindex?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

570
Views

Difference between ceiling, Floor, Abs, Round?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

1.3K
Views

Difference and similarities between scope_identity, @@identity and ident_current

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

683
Views

Parent Categories

Copyright 2022 | JanBaskTraining.com