Code Master - A reference guide for programmer's

Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Sunday, October 28, 2018

Search Inside a SQL Procedure

›
SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ...
Sunday, January 7, 2018

Encrypt and Decrypt string using SQL

›
Sample Code Declare @myData nvarchar(max) = 'My data', @seqKey nvarchar(20) = 'UniQKey07x@a', @encryptedData ...
Wednesday, October 18, 2017

Show all Date Time Formats in Sql Server

›
SQL Query DECLARE @i int=0 L1: IF @i<200 BEGIN BEGIN TRY print convert(nvarchar(max),@i+0) +'. ' ...
Tuesday, July 11, 2017

How to check a temporary table exists in SQL Server

›
Use this sql query IF OBJECT_ID('[Your_DB_Name..#[Temp_Table_Name]') IS NOT NULL BEGIN --Action-- END Example ...
Monday, June 30, 2014

SQL Query Practice - Interview Question and Answers

›
Table Name : Employee EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 1 John...
›
Home
View web version
Powered by Blogger.