|
|
-
|
|
What do we mean by Microsoft Business intelligence suite and it'scomponents- SSIS,SSAS,SSRS?...
|
|
-
|
|
Data security is the cornerstone of every business application. There is no arguing to the fact that confidential information needs to be protected by overlapping layers of security. Another aspect of security is data integrity....
|
|
-
|
|
What do we mean by Business Intelligence and how we can achieve an Intelligent Business?...
|
|
-
|
|
RAND function in SQL Server is used to generate a random value between 0 and 1. When you use RAND in the SELECT statement, it generates the same value for the entire resultset. One of my friends asked me if it is possible to have different random values...
|
|
-
|
|
Money is one of the datatypes in SQL Server and it can be used to store monetary values. It will not only accept integer and decimal values but formatted values too. For example you can express values that include comma and currency symbol
Consider the ...
|
|
-
|
|
Some days ago, i worked to get failed jobs detail and an alert for the same. I used some system tables from msdb database to fetch the details for same. And msdb.dbo.sysjobhistory is one of the table among them which used in the script. But this table n...
|
|
-
|
|
Recently I encountered one error, while converting text datatype to varchar datatype and then adding some string to it to convert into xml. I noticed that the Length of the value is 8000 characters around however when I actually copy and paste the recor...
|
|
-
|
|
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 !...
|
|