|
|
-
|
|
Pinal Dave, in his site, posted an interesting solution on finding out maximum number between two numbers. Here are some alternate methods that I know
Method 1 : Use max function
declare @value1 decimal(5,2) = 9.22
declare @value2 decimal(5,2) = 8.34
select max(val) from
(
select @value1 as......
|
|
|
|
-
|
|
Ok. Here is some Fun. This is the script that will produce zero without using any number in the code. Post your code if you find any such method
select
$,
$+,
$+.,
-$,
$*$,
+$-,
($),
$.,
($.),
-+$-,
+-$+.,
-$+.+$.,
'$,'-$+,
'$,.'-$-.
Run the code and see the output.......
|
|
-
|
|
Though it is optional to execute a stored procedure without using EXEC or EXECUTE, it is needed when you use GO(or any other batch seperator) as the stored procedure name.
Create this procedure
create procedure GO
as
select 1 as number
Execute the procedure by
GO
It will not execute be......
|
|
-
|
|
I am starting this series of questions which will be posted every month. You may find them interesting to answer. This is the question for this month.
What does SQL Server return for the following select statement?
SELECT 7A
Post your answer and breifly explain the output.
Keep following t......
|
|
-
|
|
Table and Database designers
and uncheck......
|
|
-
|
|
Jacob Sebastian, founder of Beyondrelational.com has added a section in the site called Just Learned where the bloggers can post informations that they have learned themself or from other sources. This is a good section that you can know many things that you might not know earlier. I have also poste......
|
|
-
|
|
The unique identifier datatype is used to uniquely identify a row across various databases in the network. The value has 36 characters inclusive of digits from 0 to 9,alphabets from A to F and hypen. Suppose you have a string of 36 characters and want to know if it is really an uniqueidentifier. You......
|
|
-
|
|
This follows my other three posts at http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-ii.aspx http://beyondrelationa......
|
|
-
|
|
This follows my other two posts at http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2011/05/03/sql-server-s-equivalent-of-oracle-functions-part-ii.aspx
ORACLE SQL Server
......
|
|