TCS SQL Interview Questions
HTML-код
- Опубликовано: 5 авг 2024
- Video talks about
Top SQL Interview Questions
Top SQL Interview Questions and answers
sql faq
sql interview questions qith answers
Top 10 Frequently Asked Interview Questions in SQL
Top 10 SQL Interview Questions and Answers
Video talks about
SQL Procedure Interview Questions
SQL Interview Questions
SQL Interview Questions and answers
Top SQL Interview Questions
SQL Interview call
SQL FAQ's
top sql faq
sql training videos
sql stored procedure
stored procedure in sql server
advantages of using stored procedure
sql procedure questions
differences between Stored Procedure and Functions in SQL
What are stored procedures-Advantages of Stored procedures in sql
sql tutorial
SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators
Step by step SQL Training videos
SQL Tutorial - Наука
Perfecto, now i will prepare good to my next interview!
so nice common next program
You have missed to explain difference between joins and union:
In simple terms, joins combine data into new columns. If two or more tables are joined together, then the data from the first table is shown in one set of column alongside the second table’s column in the same row and so on.
Unions combine data into new rows. If two or more tables are “unioned” together, then the data from the first table is in one set of rows, and the data from the second table in another set and so on.the rows are in the same result.
thanks !!
@@bcoa57amaykhatri94 Joins are Used to retrive the data from multiple tables in a single time
Where as the union is used to combine multiple SQL statements into single SQL statements
In joins comparision Happens Vertically
In union comparision Horizontally
For apply join between two table we need some matching from both the table
For apply Union between two tables we need some prerequisites.
Thank you it was useful
Thanks for your feedback..
Good one
Thanks for your feedback .. appreciate your time..
Thank you. It's very useful.
Thanks for your feedback.
Good job
Thanks
good video session sir
Thanks for your feedback..
Can u please make video on scenario based interview questions for 5 + year experienced in msbi
instablaster
too much adds and say watch his videos
Thank you
You're welcome
hi sir saturday i have exam for SQL can you please help me regarding this and in TCS company i have exam and it will be multiple choice questions
can you share any pdf related to my exam
Very good explanation 👍...am having two years of experience in bpo profile recently I trained on SQL and plsql can I move to IT sector isit possible without keeping any fake experience can I get the job....
Did u get job in SQL
Max 999 non clustered index can be created on a table...
Hi, your way of sharing info is good ! Pls share the link to your videos based on SQL topics
Is it for experience ???
Very informative thanks
Thanks for your feedback .. appreciate your time...
Training2SQL MSBI kindly upload more interview questiona for 6 to 8 yrs experience holders
sure .. thanks for watching...
Hi
I have table with millions records
How to excute and hoe to optimize
I created indexes also
Hello andi, I want to learn sql server and msbi.
Too much ads....
thank you for the video. i had a question on a complex query. if i want to transfer data from table A to table B , how can i do that using sql? plus , Table A’s col-1 data should be transferred to col-2 of Table B, Table A col-2 to Table B col-3 and so on
Insert into tableB (col2, col3)
Select col1, col2 from tableA
Run both statements at a time & you will be good.
we can use out parameter in function
But it's create some prblm when u execute the query..I'm little bit confused somewhere it's say yes somewhere it's say no🥺
String functions
Is it useful to learn MSBI? I Mean any openings
We have couple of openings now a days .. its up to you on upskilling ...
Nice explanation for about interview questions
Thanks and welcome
Is this DBA or developer
Q)
I have 5 flat files in a folder we need to process 1st flat file and need to skip the 2nd flat file ,again need to process the 3rd flatfile.and need to skip the 4th flat file again need to process the 5th flat file for loading the data to destination...How do we achieve this?????
File system task
How to get first & last record from the table in sql server ?
multiple ways to get it.. Sort the data in asc/desc and take top 1 in both the cases. Or use row number with sub query get the values.
@@Training2SQLMSBI true
Tcs interview questions okala vuntay vere company aithe okala vuntaya😂😂😂😂😂😂😂😂😂😂😂😂😂
hi sir you explaining way are not well not understand exact meaning what you want to say....
how to remove duplicates rows entire table ,can u plz answer
set rowcount(1) delete row set row count (0)
Truncate
Use:- select distinct (*) from table;
hi sir learning course link and interview topics
Please check all my videos ..
Create procedure based on 2 parameters are state and city.
1. If I pass state then get employee details state wise
2. If I pass city then get employee details city wise
3. If I pass both then get employee details of state and city.
Create a procedure with state & city parameters. Inside the procedure, write select statements using IF, ELSE IF & ELSE. So based on the parameters passed by the user, respective select statements get executed. Hope it helps.
dai .................
We can use transaction commands (rollback, commit ) in truncate
No, we can't
yes. we can use.
Hii, DDL commands are auto commited they cannot be rolled back,
In SQL Server Delete, Truncate and Drop commands can be ROLLED back without any issues only when they are used in transactions.
No
Can anyone please tell me how to give the table name dynamically in SELECT query. Thanks in advance.
You to need to create table or check the table?
use dynamic SQL quires
DECLARE @sqlCommand varchar(1000)
DECLARE @tableName varchar(75)
SET @tableName = '''Employee'''
SET @sqlCommand = 'SELECT * from ' + @tableName
EXEC (@sqlCommand)
What is the use of this video..every time you say u have to watch your video for each question...