DotNetShoutout - Stories tagged with SQL Server

SQL Server

atom rss
13
Shouts
spam Shout it Mute it

Transact-SQL Delayed Execution
published 1210 days, 2 hours, 26 minutes ago posted by BlackWaspBlackWasp 1217 days, 14 hours, 14 minutes ago
Friday, January 29, 2010 10:35:37 AM GMT Thursday, January 21, 2010 10:46:49 PM GMT
Transact-SQL includes the WAITFOR statement. This command allows the execution of a script or procedure to be blocked for a period of up to twenty-four hours. The process can be delayed until a specified time or for a number of hours, minutes and seconds. (more)
category: Data | clicked: 0 | comment | | source: www.blackwasp.co.uk
tags: SQL Server, SQL
2
Shouts
spam Shout it Mute it

How to know the number of days in a month in t-sql
posted by PraveenPraveen 1218 days, 17 hours, 15 minutes ago
Wednesday, January 20, 2010 7:46:38 PM GMT
Some times we can get requirement to know the number of days in a given month. For example, while calculating how many days remaining in a month or last day of month or any other scenarios. Here is a small script that will give you the number of days for given month. Example purpose, i am retrieving month from the current date. declare @numberOfDaysInMonth int; set @numberOfDaysInMonth =DAY(DATEADD(m, 1,DATEADD(d, 1 -DAY(getdate()),getdate()))- 1); (more)
category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, T-SQL, Month
3
Shouts
spam Shout it Mute it

Expand Collapse columns in a table SSRS
posted by PraveenPraveen 1222 days, 17 hours, 17 minutes ago
Saturday, January 16, 2010 7:44:41 PM GMT
Problem: How to make columns collapsible, expandable in table Sql server reporting services. Solution: I asked to some people, how to do this, lot of people proposed me to use matrix. But my data is simple data and has 14 columns like firstname, last name, state, city, zipcode, q1, q2, q3, h1,h2, h3 etc… I need to display the columns q1, q2, q3; h1,h2,h3 expansible and collapsible. By default when user see the report, i need to show only firstname, last name, state, city, zipcode, q1, h1 columns. But... (more)
category: Data | clicked: 3 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, SSRS, Reports
9
Shouts
spam Shout it Mute it

Scheduling jobs in Sql server Express
published 1224 days, 6 minutes ago posted by PraveenPraveen 1225 days, 17 hours, 20 minutes ago
Friday, January 15, 2010 12:54:58 PM GMT Wednesday, January 13, 2010 7:40:53 PM GMT
I know, at some point you need this when you use sql express. Sql express is the limited edition of Sql server. So, it doesn't contain all the features. To schedule we need sql server agent service. But it comes only with sql server. So, creating jobs are not possible with sql express. So, is there any way? Yes. Today I found a nice article on it. And that is perfect. Take a look at it and let me know your ideas on it. http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express Hope you like... (more)
category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, jobs, Scheduling, SQL Express
2
Shouts
spam Shout it Mute it

Date formatting in Sql server reporting services
posted by PraveenPraveen 1226 days, 16 hours, 20 minutes ago
Tuesday, January 12, 2010 8:41:30 PM GMT
When we work with reporting services, we come across with different requirements to display the date in different formats. So, we need to know the formats we can give to get required value. Sql server reporting services supports different formats as T-sql and C# does. So, I just want to give the valid formats I use to display the date in required format. =Format(Fields!DateCreated.Value, “M/d/yy”) - 3/14/1986 =Format(Fields!DateCreated.Value, “d-MMMM-yy”) - 14-March-86 =Format(Fields!Dat... (more)
category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, Formatting, Date, Reports
2
Shouts
spam Shout it Mute it

Fix to Divided by zero problem in Sql server reports
posted by PraveenPraveen 1226 days, 16 hours, 20 minutes ago
Tuesday, January 12, 2010 8:40:53 PM GMT
When we work with reports, most of the times we need to do complex calculations and logic. When we do calculations, there are chances of using the division operation. So, need of checking the divided by zero problem every time. So the solution I propose is, write a simple custom function and call it wherever needed. For every report there is a part called Code and there we can write the custom VB code. Public Function CheckDividedByZero(ByVal param1 As Double, ByVal param2 As Double) As Double  ... (more)
category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, Reports
8
Shouts
spam Shout it Mute it

Data Formatting in sql server reporting services
published 1229 days, 53 minutes ago posted by PraveenPraveen 1230 days, 23 hours, 43 minutes ago
Sunday, January 10, 2010 12:07:57 PM GMT Friday, January 08, 2010 1:18:32 PM GMT
In Sql server reporting services the formatting the data is pretty much simple as we have plenty of built in options available for percentage, numbers, decimal, currency etc. So, just them to data format and display the data as you want. Below are most commonly use format for the usual reports.c – Currencyd – Decimaln – Numberp – Percentage. If you want two decimal places in decimal number then in the format option [Text box properties -> format] then the  format should be d2. In percentage if you want ... (more)
category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL Server, Formatting, Reports
16
Shouts
spam Shout it Mute it

Innovation Showcase : Creating PHP CRUD Apps with SQL Server on-premise or in the Azure Cloud
published 1230 days, 32 minutes ago posted by bobfamiliarbobfamiliar 1231 days, 21 hours, 48 minutes ago
Saturday, January 09, 2010 12:29:34 PM GMT Thursday, January 07, 2010 3:12:58 PM GMT
07 January 2010Creating PHP CRUD Apps with SQL Server on-premise or in the Azure Cloud The SQL CRUD Wizard for PHP is a sample .NET application that can be used to generate a simple "Create, Read, Update, Delete" PHP application from a Microsoft SQL Server database table. The generated PHP application supports paging, sorting and simple CSS customization. The project is open source and hosted on CodePlex. Details at the Interoperability@Microsoft site. Technorati Tags: Open Source,PHP,SQL Server,Wind... (more)
category: Data | clicked: 1 | comment | | source: blogs.msdn.com
tags: SQL Server, Windows Azure, SQL Azure, PHP
7
Shouts
spam Shout it Mute it

Web 2.0 | Reading and Writing BLOB Data to MS SQL or Oracle Database
published 1251 days, 2 hours, 47 minutes ago posted by farooqkaiserfarooqkaiser 1251 days, 18 hours, 23 minutes ago
Saturday, December 19, 2009 10:14:29 AM GMT Friday, December 18, 2009 6:38:22 PM GMT
In this article, i will examine how to store and retrieve binary files such as image or PDF into MS SQL or Oracle database. Reading a File into a Byte Array 1:byte[] mbarrImg = null; 2:using (FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.Read, FileShare.Read)) 3: { 4: mbarrImg = newbyte[fs.Length]; 5:int iBytesRead = fs.Read(m_barrImg, 0, (int)fs.Length); 6: fs.Close(); 7: } Saving BLOB data from a file to Oracl... (more)
category: Data | clicked: 2 | 1 comment | | source: www.fairnet.com
tags: SQL Server, .NET, C#, Oracle
2
Shouts
spam Shout it Mute it

Solving problems in configuring sql server for session mode 'sql server'
posted by kcherupakcherupa 1255 days, 7 hours, 32 minutes ago
Tuesday, December 15, 2009 5:29:10 AM GMT
Before going to details let me explain my experience on this. I was working on a project which pushed us to use bulky data in session. So we thought that it wouldn't be reliable to use the session in "InProc" mode as the asp.net worker process consumes lot of RAM and leads to crash the service. To avoid this we decided to use the session state in sql server mode. Telling the asp.net application to use sql server for session state is easy as shown below. But to make the above to work, we need to setup... (more)
category: Data | clicked: 0 | comment | | source: cherupally.blogspot.com
tags: SQL Server, session mode, Configures
10
Shouts
spam Shout it Mute it

SQL Server Service accounts
published 1269 days, 20 hours, 23 minutes ago posted by sqlarticlessqlarticles 1271 days, 3 hours, 34 minutes ago
Monday, November 30, 2009 4:38:20 PM GMT Sunday, November 29, 2009 9:26:47 AM GMT
Most entry level DBAs still have the confusion on what is a service account and which is the best to be used and when. This article will take you through that. Depending on the selection that you made while installing SQL Server, you will have the services installed in your server. (more)
category: Data | clicked: 1 | 1 comment | | source: www.sql-articles.com
tags: SQL Server, sqlarticles, service account
Previous 1 2 ... 35 36 37 38 39 40 41 42 43 44 Next