|
|
-
antonsc229 Commented 1 Months ago through Blogs
There is another way to handle multiple result sets in procedure, it available in SQL 2012. http://raresql.com/2012/07/02/sql-server-2012-executing-stored-procedure-with-result-sets/...
|
|
|
-
antonsc229 Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
antonsc229 Liked 1 Years ago through Blogs
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...
|
-
antonsc229 Liked 1 Years ago through Syndicated Blogs
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution with you. The challange was to keep track of changes on a table that we had only a readonly access to, and keep a history of the changes. Furthermo...
|
-
antonsc229 liked 1 Years ago through Scripts
This is a script to to identify the unused indexes within a database. The column 'ReadsPerWrite' is an important field to consider. ...
|
|
|
-
antonsc229 Liked 1 Years ago through Blogs
In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code
set nocount on
select
space(17-len(replicate(char(94),no)))+ replicate(char(94),no*2-1)
from
(
select top 10 row_num...
|
-
antonsc229 Liked 2 Years ago through Blogs
A computed column in SQL Server is an expression which is based on another column in the same table. Consider the following example
create table test_table
(
id int,
names varchar(100),
cust_id as right('00000'+cast(id as varchar(10)),5)
)
...
|