Search In
Sometimes we required to generate a comma separated list of columns values. In SQL Server, we can make a comma separated list by using COALESCE function
Ex:
Declare @strmail varchar(max)
Select @strmail=COALESCE(@strmail+';' , ' ')+ email from
How to create cell span of more than one column in a table.
To create a cell span of more than one column in a row we add the attribute colspan to that column and designate its value.The value of colspan determine the number of columns a cell span w
How to create cell span of more than one column in a table.
To create a cell span of more than one row in a column we add the attribute rowspan to that column and designate its value.The value of rowspan determine the number of rows a cell span woul
Below mentioned command is used to find a particular text in all stored procedures
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%EmailOnTRX%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)
In SQL Server there are situations when you need to import assemblies to perform a specific task
For doing that you need to write the path where assembly is present and provide the permissions to the assembly and associating with the particular use
To get the name ,data type and size of the table we will write the following query
We will use the SQL predefined function for it by writing a SQL query
SELECT columnname as 'Column Name', datatype as 'Data Type',
charactermaximumlength a
I receive a huge amount of messages from my landing page, created in Mobirise website builder. It's a mess.
I want to put them in a separate database, so I could see them in an order. Is it possible? I didn't find an answer in Mobiri
Technology investments are something that could literally pay off. It comes with many advantages such as a high return and growth prospects. Technology investments have reached a wide variety of industries. But it's important to focus on some of
Every XML has two elements i.e.
1) Attributes and
2) Value
SELECT magazineId AS '@id'
, magazineName AS '@name'
, CoverPage AS '@coverPage'
, isActive AS '@status'
, publishDate AS '@publishDate'
, expiryDate AS '@expiryDate'
Hi,
The tutorial will help you to set an image on collectionView Cell and when you click on any image play the video.
//
// ViewController.m
// YouTubeVideo
//
// Created by lalit on 4/7/15.
// Copyright (c) 2015 lalit. All rights reserved.
//
