Table Structure Get From Database in Sql Server
If We Want To get Any Table Structure from Database .
Show How Many Column Created and Datatype also Then Use This Code
Create Procedure in Sql Server
CREATE Procedure dbo.Gettable @tablename nvarchar(100) as ...
Saturday, 25 June 2016
Unicque Row Num and Same Rank in Sql server
Use Of Row_Number() ,Rank() function , Dense_Rank()
Row_Number()
This function will assign a unique id to each row returned from the query.
Consider the following query:
DECLARE @Table TABLE (
Col_Value varchar(2)
)
INSERT INTO @Table (Col_Value)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT
Col_Value,
...
Friday, 24 June 2016
COALESCE function
Concatenate many rows into a single text string using SQL Server
Using COALESCE function-
What is COALESCE function-
Concatenate many rows into a single text string with comma separated using SQL Server COALESCE function.
My table format is like this:
(Select Name from Tbl_Customer)
Name
Jeet
Nitin
Pulkit
Rahul
Vibha
I...
Wednesday, 15 June 2016
Rank Given In Table
Rank Given in Table in SQL Server
If We Want to Give Indviual Rank And Same Rank to Same data Then Use
Use Of ROW_NUMBER() Function
1.This function will assign a unique id to each row returned from the query.
2.RANK gives you the ranking within your ordered partition. Ties are
assigned the same rank, with the next ranking(s) skipped....
Create Table
Create Table In Sql Server
Syntax-
CREATE TABLE TableName(ColumnName1 INT PRIMARY KEY IDENTITY,ColumnName2,ColumnName3)
Ex.
CREATE TABLE Tbl_CityMaster(Id INT PRIMARY KEY IDENTITY,CityName nvarchar(20),C_Id in...
Show Table Data
This IS Code For Show Table Data..
If We Want to Get Data Inserted in Any Table And Copy then use this Code in SQL Server
Syntax-
DECLARE @Fields VARCHAR(max); SET @Fields = '[ColumnName1], [ColumnName2], [ColumnName3]' -- your fields, keep []
DECLARE @Table VARCHAR(max); SET @Table = 'Table Name' -- your...
Monday, 13 June 2016
Use SQL Server Functions
SQL Aggregate Functions
This functions return a single value, calculated from values in a column.
Like Ex.-
AVG() - Returns the average value.
Syntax - SELECT AVG(column_name) FROM table_name
COUNT() - Returns the number of rows.
Syntax - SELECT COUNT(column_name) FROM table_name
FIRST() -...
Friday, 10 June 2016
CSS 3D Transforms
.container{
/* How pronounced should the 3D effects be */
perspective:800px;
-webkit-perspective:800px;
background: radial-gradient(#e0e0e0, #aaa);
width:350px;
height:380px;
margin:0 auto;
border-radius:6px;
...
Wednesday, 8 June 2016
Current Date
Show Current Date-
I Want To Show Current Date Then Use-
SELECT GETDATE() AS CurrentDate
OutPut-
2016-06-08 12:11:00.083
More Format In Date Then Use-
Ex. 1:
SELECT CONVERT(varchar(20),GETDATE(),100) AS CurrentDate
OutPut-
...
Tuesday, 7 June 2016
Ajax FilteredTextBox Extender
How To Use FilterTextBoxIn Asp.net.
SOURCE OF PAGE Firstly Add Directory on page
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
Only Restrict For Upper case
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></asp:ToolkitScriptManager>
<asp:TextBox...
