|
|
-
|
|
You can execute procedure at start up of SQL Server instance.
To do that follow steps below:
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
GO
RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'scan for startup procs'...
|
|
-
10
Liked
| 10
Learned
| 10
Comments
|
|
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
|
-
|
|
Just learned from Kunal's blog that we can open pdf in Word 2013 and that will look just like you opened a word document
...
|
|
-
|
|
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ser...
|
|
-
|
|
SQL Server 2012 Reporting Service provides new feature of Data Alerts by email.
For example :- Sending an email to Director of sales when any invoice having more than $250K amount....
|
|
-
|
|
SQL Server 2012 Reporting Service provides new feature of Data Alerts by email.
For example :- Sending an email to Director of sales when any invoice having more than $250K amount....
|
|
-
|
|
While writing a query with joining two tables from two different dbs, a collation error was encountered.
'Cannot resolve collation conflict for equal to operation.'
Fix:
add keyword `COLLATE DATABASE_DEFAULT` after join .
SELECT
F...
|
|
-
|
|
I was just browsing the history of Microsoft Business intelligence when I learned that "Microsoft entered the market of OLAP tech w/ SQL server 7.0 (1998) after acquiring the technology from Panorama Software"...
|
|
-
16
Liked
| 12
Learned
| 11
Comments
|
|
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click** on...
|
|
-
|
|
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replicatio...
|
|