Some one ask me for Some interesting small query not logical but for some fun.
I said yes sure I have some simple query by this probably wh started SQL Server will be little bit confuse to answer some of the mention question .I don't tell you the answer please answer all who knows on comment . Questions are given below
SELECT 15
SELECT $
SELECT COUNT(*)
SELECT COUNT('7')
SELECT 'Code' + 1
SELECT 'Code' + '1'
SELECT (SELECT 'Code')
SELECT SELECT 'Code'
SELECT * FROM 'TableName'
SELECT COUNT(*) + COUNT(*)
SELECT SUM(1+2*3)
SELECT MAX(1+2*3)
SELECT MAX(1,3,4)
SELECT MAX('Cherry')
SELECT COUNT(SELECT columnname FROM TableName)
I said yes sure I have some simple query by this probably wh started SQL Server will be little bit confuse to answer some of the mention question .I don't tell you the answer please answer all who knows on comment . Questions are given below
Sql Server intresting Query
SELECT $
SELECT COUNT(*)
SELECT COUNT('7')
SELECT 'Code' + 1
SELECT 'Code' + '1'
SELECT (SELECT 'Code')
SELECT SELECT 'Code'
SELECT * FROM 'TableName'
SELECT COUNT(*) + COUNT(*)
SELECT SUM(1+2*3)
SELECT MAX(1+2*3)
SELECT MAX(1,3,4)
SELECT MAX('Cherry')
SELECT COUNT(SELECT columnname FROM TableName)
Nice
ReplyDelete