|
|
-
Paras Dave Learned 5 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Paras Dave Liked 5 Months ago through Just Learned
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Paras Dave Commented 5 Months ago through Blogs
Congratulations!
I love your tips and blog....
|
-
Paras Dave Liked 5 Months ago through Blogs
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
-
Paras Dave Posted 5 Months ago through Just Learned
**Hold Control and shift key while Clicking on Program icon**.
**For example:** You want to open visual studio with administrator rights then **Ctrl + Shift + Click on visual studio icon**...
|
|
|
-
Paras Dave Posted 8 Months ago through Just Learned
Found following Work-arounds:
1. Use SP_HELPTEXT 'YourProcedureName', set “Result to Text” (Ctrl +T) and copy script from result section.
2. SELECT OBJECT_DEFINITION(OBJECT_ID('YourProcedureName'))
3. SELECT DEFINITION FROM sys.sql_modules WHERE OB...
|
-
Paras Dave Posted 8 Months ago through Just Learned
Found following Work-arounds:
1. Use SP_HELPTEXT 'YourProcedureName', set “Result to Text” (Ctrl +T) and copy script from result section.
2. SELECT OBJECT_DEFINITION(OBJECT_ID('YourProcedureName'))
3. SELECT DEFINITION FROM sys.sql_modules WHERE OB...
|
-
Paras Dave Learned 8 Months ago through Just Learned
Wordpress.com allows us to post code on blogs using [sourcecode] tag. For instance, a SQL code will be posted using:
[code]
[sourcecode language="SQL"]
your code here
[/sourcecode]
[/code]
For more information URL: http://en.support.wordpr...
|
-
Paras Dave Liked 8 Months ago through Just Learned
Wordpress.com allows us to post code on blogs using [sourcecode] tag. For instance, a SQL code will be posted using:
[code]
[sourcecode language="SQL"]
your code here
[/sourcecode]
[/code]
For more information URL: http://en.support.wordpr...
|