Ravi Luhar

Search This Blog

Rakh du Tuje meRi baHo mE

on July 28, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

Rakh du Tuje meRi baHo mE SambHal kAr
Na laGe koi kharoCh tuJe
Hai meRi pYari tU na laGe koI naZar tUje
bAs tuHi tu haI Bas khWahisH Tu...

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to find all tables containing column with specified name - MS SQL Server

Hello Friends, sometime you face in database where we use same colums in database, or where this colum is connected. Today i face this thing so i get this solution fom MS SQL Server's INFORMATION_SCHEMA. Check this Quarry for find tables where we can find colum. select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%COLUMN_NAME%' order by TABLE_NAME Here check this Quarry,replace your column name to COLUMN_NAME and run in sql server, you get list of data that contain column related tables where colun are used.

YouTube Banner Size and Template

Hello Friends Now social trend is videos and short videos.so users take some platform like youtube and tiktok and instagram now a days. here this blog i wrote for help user to make youtube channel banner. Youtube channel banner main size is 2560 x 1140 . but this size is devide part in device.so user need to manupilate banner image for it.here i give one sample image to take idea about it. here you can see differnt size for differnt device. For TV: 2560 x 1440 Desktop: 2560 x 423 Tablet: 1855 x 423 Mobile: 1546 x 423 for your help i put psd file so you can easyli setup banner image. Click here to Download .PSD File

call store procedure and action for insert and get data

here i create call for store procedure and action for insert and get data,check the code create web confing connection string for db add key="ConnectionString" value="Data Source=###;Initial Catalog=db;User ID=sa;Password=#pwd#" Create class for sql operations using System; using System.Data; using System.Xml; using System.Data.SqlClient; using System.Collections; using System.Configuration; using System.Data.Common; public class SqlHelper { private static string SetConnection() { return Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]); } public static int ExecuteNonQuery( CommandType commandType, string commandText, params SqlParameter[] commandParameters) ...

Powered by Blogger

Rakh du Tuje meRi baHo mE

Comments

Post a Comment