#MS SQL SERVER, #SQL INTERVIEW QUERY How get list of all Supporting language in SQL Server ? Interview Question Write down the query to get list of all supported language by SQL Server? Ans: SELECT name ,* FROM sys . syslanguages Result: 21:12 Share
#MS SQL SERVER, #SQL INTERVIEW What is Self Join in SQL Server : Interview Question with Example <b> SQL Self Join :</b> The SELF JOIN is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL st 02:34 Share
#MS SQL SERVER, #SQL INTERVIEW Print 1 to 10 Using While Loop in SQL Server : Interview Question <b> Write down the T-SQL Script to print then number from 1 to 10?</b> Ans: declare @i int ; set @i = 1 ; while ( @i <= 10 ) Begin print ( @i ); set @i = @i + 1 ; end <b> Outpu 02:21 Share
#MS SQL SERVER, #SQL INTERVIEW Can you drop the database currently you working on? SQL Server Interview questions <b> Can you drop the database currently you using/working, in same session?</b> Ans: No<b> Lets see:</b> Here we are going to try to drop the database with name " 02:14 Share
#MS SQL SERVER, #SQL INTERVIEW How to Insert Same Records Multiple Time in SQL Server Without Using any While Loop <b> Write a query to insert your name 1000 times without Using While Loop in SQL Server?</b><b> Ans: </b> I will use Go statement post-fix with no of record want to in 21:13 Share
#MS SQL SERVER, #SQL INTERVIEW What are magic table in SQL Server? Magic tables are nothing but the logical tables maintained by SQL server internally. There are two types of Magic tables available in SQL server Inser 00:01 1 Share
#SQL INTERVIEW, #SQL INTERVIEW QUERY How to get the list of tables changed with in the database in last 5 days? Write SQL Query, Interview Question SELECT name , create_date , modify_date FROM sys . objects WHERE modify_date >= GETDATE ()- 5 and type = 'U' (this query will list out all table which ha 20:13 Share
#SQL INTERVIEW, #SQL INTERVIEW QUERY How to Convert HTML Table in SQL Table using TSQL DECLARE @Xml xml set @Xml = '<tr> <td>Vikas Ahlawat</td> <td>MCA</td> 01:08 Share
#MS SQL SERVER, #SQL INTERVIEW TRICKY SQL INTERVIEW QUERIES QUESTIONS ANSWERS FOR EXPERIENCED SQL DEVELOPERS Hey guys, I am writing this post after many days, after many comment by SQL Guys, Every one want to see new post related to SQL Interview questions, 20:38 7 Share
#SQL INTERVIEW, #SQL INTERVIEW QUERY COMPLEX / DIFFICULT SQL QUERIES EXAMPLES FOR INTERVIEW SET-8.4 Here we again come with the hard/tricky sql server interview queries examples for sql server Interview preparations. Following is query is based on s 09:40 20 Share
#INTERVIEW QUESTIONS, #MS SQL SERVER HOW PRINT A TRIANGLE OF STARS USING PL/SQL IN SQL SERVER/ INTERVIEW QUERIES One of the most complex PL/SQL interview queries is "<strong> How you will print a triangle of stars in sql server using?</strong> "<strong> HOW PRINT A TRIANGLE OF ST 09:43 Share
#INTERVIEW QUESTIONS, #MS SQL SERVER MS SQL SERVER TRICKY/COMPLEX INTERVIEW QUERIES QUESTIONS ANSWERS : PDF SET-10 <b> MOST COMPLEX/TRICKY MS SQL SERVER (2005-08-12) QUERIES INTERVIEW QUESTIONS SET-10</b> <b></b> This set contains most Tricky/complex MS SQL Server queries interview 19:27 25 Share
#INTERVIEW QUESTIONS, #SQL INTERVIEW QUERY SELECT QUERIES: Small Tricky SQL SERVER Queries Interview Questions and Answers SET-9 <b> SET-9</b> <b> Objective Type :Small Tricky SQL SERVER Queries Interview Questions and Answers for experienced and fresher</b> Hey here I come with tricky sql query 23:36 28 Share
