|
|
-
Adam Tokarski Liked 1 Years ago through Blogs | 1 Point
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to display line number in query window.
When...
|
-
Adam Tokarski learned 1 Years ago through Blogs | 1 Point
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to display line number in query window.
When...
|
|
|
-
Adam Tokarski Liked 1 Years ago through Blogs | 1 Point
Today my friend asked me that ISNUMERIC function is not working properly. I checked, the issue was with some special char, might be MSSQL will improve this functionality in coming versions. For now, if we change the way of calling, it will show you the...
|
-
Adam Tokarski Posted 1 Years ago through Blogs | 10 Points
Talk about strange error with date interpretations (encountered only at MSSQL2005) depending on languages versions....
|
-
Adam Tokarski refreshed 1 Years ago through Blogs | 1 Point
There are many ways to know the version of the Current Server using a query. They are shown below
1 Use @@version
select @@version
2 Use system procedure sp_server_info and see the value of attribute_value column where attribute_name is DBMS_VER
...
|
-
Adam Tokarski Liked 1 Years ago through Blogs | 1 Point
Today one of my friend ask me, can we use Order by clause dynamically ? I said yes, but there are few limitations while using case in order by clause see the below example.
This script will return Error:DECLARE @TOP INT = 10, @FLD VARCHAR(20)='AGENT_I...
|
-
Adam Tokarski Liked 1 Years ago through Blogs | 1 Point
I had blogged about Different ways to know structure of the tables. One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc.
Consider the follow...
|
-
Adam Tokarski learned 1 Years ago through Blogs | 1 Point
I had blogged about Different ways to know structure of the tables. One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc.
Consider the follow...
|
-
Adam Tokarski refreshed 1 Years ago through Blogs | 1 Point
Output clause has been added to SQL 2005 which can mainly used to grab the identity values. This has been really helpful addition to SQL 2005. You can get more information regarding output clause here.
I have faced couple of incidents in last six month...
|