|
|
-
|
|
Hi all This is to inform you SQL PraRup have completed 100’s Download in 5 Day. If you not used yet this too , Download and Use this powerful formatting tool which gives us feature's like Auto Format/Indents all SQL Server Objects at ones Cus...
|
|
-
|
|
Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME or ANY....
|
|
-
|
|
Hi all, We are please to announce Our SQL Server Object formatting tool ready to go live and we all can use it for formatting SQL Server Object. This tool is now available on Codeplex. Why is know as SQL PraRup ? This just give tool Indian touch !...
|
|
-
|
|
Spreadsheet is widely used by people in every industry due to flexibility for business data computing and analysis as well as visualized calculation. The nontechnical people can perform some rather complex calculations without having to learn the SQL. But the common business spreadsheet can't conduct relational query....
|
|
-
|
|
FILESTREAM data can be accessed by TSQL as well as through the Win32/Managed APIs. Accessing FILESTREAM data using TSQL is not recommended for a number of reasons such as the inability to stream data when reading or writing through TSQL. The recommended...
|
|
-
|
|
Extending the Windows user experience of file searches to SQL server is a bit of a challenge because the asterisk [*] is a wild-card character in Windows whereas SQL Server uses percentage [%]. The percentage [%] is valid in a file name which adds to the complications. Today's post presents an approach to realize such a requirement using the ESCAPE keyword....
|
|
-
|
|
The currency symbol $ represents the value 0. Find more examples at http://beyondrelational.com/modules/1/justlearned/tips/8577/arithmetic-operations-with-.aspx
The datatype of the returned value from $ is money.
Consider the following exampledeclare @...
|
|
-
|
|
Few days back, i was working to add new table in publication in transaction publication. After adding a article in publication and after reinitialized, i see nonclustered index was not copied at subscriber database. I tried reinitialized one more time a...
|
|
-
|
|
Hi all , On PASS Business Analytics Conference(PBAC) in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download Here ). "Today we are announcing the availability of the project codename "GeoFlow" Preview for Exce...
|
|
-
|
|
Changing the SQL Server collation once a SQL Server instance has been installed is a tedious process because it involves recreating the master database. Many believe that the server collation is picked up by default and must be changed by master database recreation only. In this post, I show how to ensure that the installation itself always uses the required collation....
|
|