|
|
-
|
|
My colleague Divya showed me how to transfer the bookmarks saved in IE to firefox.
a) Click Firefox top menu Bookmarks which opens the popup.
b) Click on the menu "import and backup-> import data from another browser
c) Complete the wizard displ......
|
|
-
22
Liked
| 15
Learned
| 10
Comments
|
|
Aggregate functions always return at least one row. So using aggregate functions to check for the existance of data will not give correct results. See the results returned from these queries
[code]
declare @t table(i int)
if exists(select i from @t......
|
|
-
|
|
Often in many stored procedures, we will throw same error message by using RaiseError(). Instead we can register that error message using sp_addmessage and use the error message in all the stored procedures.
For example, often we will throw same ty......
|
|
-
|
|
Microsoft has released cumulative update packages for both SP2 and SP3.
1. Cumulative update package 7 for SQL Server 2008 Service Pack 2
2. Cumulative update package 2 for SQL Server 2008 Service Pack 3
For more details see:
[code]
http://sup......
|
|
-
|
|
Today I got an error in javascript because of "innerText" property. I found this property is not working in mozilla browser and working in other browsers. Later I found that innerText property is not compatible with mozilla browser and instead we can us......
|
|
-
18
Liked
| 21
Learned
| 5
Comments
|
|
Careful! If you are using your old scripts to create database in SQL 2012, It might fail. In SQL Server 2012, Minimum database size is increased to 3MB. In before versions it is 2MB. So, if you run the same script with initial size specified as 2MB, it ......
|
|
-
|
|
Earlier i submitted script to upload file(s) via FTP in SQL Server here http://beyondrelational.com/justlearned/posts/600/script-to-upload-files-via-ftp-in-sql-server.aspx. You can find here the same but it's for download the file from FTP.
[CODE]
......
|
|
-
|
|
Yesterday, While priniting an MS-Office word document, my colleague asked how to take print of more than one page in a single sheet.
Go to top menu File.Select
Print->General tab ->properties->finishing->pages per sheet......
|
|
-
|
|
When a DBA observes performance problems with a SQL Server instance, usually the first action he/she takes is to run some diagnostic queries that help him/her to identify the most expensive queries running on the server. Sometimes, you may observe that ......
|
|
-
|
|
In MVC, These 3 objects works are like properties, and can be used to share data between view and controller. Basic use of these objects is to communicate between view and controller. using this you can get or set chuck amount of data.
In Controller......
|
|