manish-sqlserver.blogspot.com
MS - Sql Server: Convert String into camel case
http://manish-sqlserver.blogspot.com/2012/10/convert-string-into-camel-case.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Saturday, October 20, 2012. Convert String into camel case. SELECT dbo.CamelCase('maNISh pATHaK') Output: Manish Pathak. Subscribe to: Post Comments (Atom). New Delhi, Delhi, India. Https:/ in.linkedin.com/in/manishpathak79. View my complete profile. Get All Tables and Its Column Name of a DB. UDF - Distence B/W two Lat Long. Convert String into camel case. Convert Number into RomanNo. Get Last date of Month. Simple template. Powered by Blogger.
manish-sqlserver.blogspot.com
MS - Sql Server: Convert Number into RomanNo
http://manish-sqlserver.blogspot.com/2012/10/convert-number-into-romanno.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Saturday, October 20, 2012. Convert Number into RomanNo. CREATE Function GetRomanNo(@N as varchar(20) RETURNS VARCHAR(100) AS BEGIN DECLARE @s varchar(100), @r varchar(100), @i bigint, @p int, @d bigint SET @s = ' SET @r = 'IVXLCDM' - Roman Symbols /* There is no roman symbol for 0, but I don't want to return an empty string */ IF @n=0 SET @s = '0' ELSE BEGIN SELECT @p = 1, @i = ABS(@n) WHILE(@p. Subscribe to: Post Comments (Atom).
manish-sqlserver.blogspot.com
MS - Sql Server: March 2011
http://manish-sqlserver.blogspot.com/2011_03_01_archive.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Sunday, March 20, 2011. Concept behind SQL Query execution. When you submit a query to a Sql Server DB then a number of process on the server go to work on that query. Some process occure in the Relational Engine. Some process occure in the Storage Engine. The process in storage engine such as locking, index maintenence and transection occure. Note : The execution plan is created in the relational engine. The output of this process is a Parse Tree.
manish-sqlserver.blogspot.com
MS - Sql Server: June 2011
http://manish-sqlserver.blogspot.com/2011_06_01_archive.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Tuesday, June 28, 2011. How to generate an AutoAlphaNumeric Code in SQL. To know @ just copy and paste. Set @sLength = 8 - Can be changed. Set @AutoCode = '. SET @counter = 1. SELECT @nextChar = CHAR(48 CONVERT(INT, (122-48 1)*RAND() ). IF ASCII(@nextChar) not in (58,59,60,61,62,63,64,91,92,93,94,95,96). SELECT @AutoCode = @AutoCode @nextChar. SET @counter = @counter 1. Use of Coalesce in SQL Query. To know @ just copy and paste. 102,'US',301,'NY'),.
manish-sqlserver.blogspot.com
MS - Sql Server: Get Last date of Month
http://manish-sqlserver.blogspot.com/2012/10/get-last-date-of-month.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Saturday, October 20, 2012. Get Last date of Month. Set @DT = '1/15/2012'. SELECT DATEADD(MM, DATEDIFF(MM, 0, @DT) 1, 0)-1 AS MonthEndDate. Subscribe to: Post Comments (Atom). New Delhi, Delhi, India. Https:/ in.linkedin.com/in/manishpathak79. View my complete profile. Get All Tables and Its Column Name of a DB. UDF - Distence B/W two Lat Long. Convert String into camel case. Convert Number into RomanNo. Get Last date of Month.
manish-sqlserver.blogspot.com
MS - Sql Server: Get All Tables & Its Column Name of a DB
http://manish-sqlserver.blogspot.com/2012/10/get-all-tables-its-column-name-of-db.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Wednesday, October 10, 2012. Get All Tables and Its Column Name of a DB. Select T2.name as 'TableName',T1.name as 'ColumnName' from sys.columns T1 inner join sys.tables T2 on (T1.object id = T2.object id) order by TableName. Subscribe to: Post Comments (Atom). New Delhi, Delhi, India. Https:/ in.linkedin.com/in/manishpathak79. View my complete profile. Get All Tables and Its Column Name of a DB. UDF - Distence B/W two Lat Long.
manish-sqlserver.blogspot.com
MS - Sql Server: February 2011
http://manish-sqlserver.blogspot.com/2011_02_01_archive.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Tuesday, February 22, 2011. Types of Views in Sql Server. There are 3 type of views in Sql Server:. 1 - Standard View. 2 - Indexed View. 3 - Partitioned View. 1 - Standard View. Standard View is a genral view that we know all about. 2 - Indexed View. 3 - Partitioned View. A view is a partitioned view that join horizontally partitioned data from a set of member tables across one or more servers. Friday, February 18, 2011. Suppose you are working on ...
manish-sqlserver.blogspot.com
MS - Sql Server: October 2012
http://manish-sqlserver.blogspot.com/2012_10_01_archive.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Saturday, October 20, 2012. Get nth highest and lowest salary of an employee. Declare @Tbl table(sal int). Insert into @Tbl(sal) values(12),(15),(20),(25),(8),(20),(18),(10). Set @TopNthSal = 3. Select distinct * from @Tbl order by sal desc. Select max(sal) as 'N-Highest' from @Tbl where sal not in ( select distinct top(@TopNthSal-1) sal from @Tbl order by sal desc ). Get Last date of Month. Set @DT = '1/15/2012'. Convert Number into RomanNo. CREAT...
manish-sqlserver.blogspot.com
MS - Sql Server: Get nth highest and lowest salary of an employee
http://manish-sqlserver.blogspot.com/2012/10/get-nth-highest-and-lowest-salary-of.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Saturday, October 20, 2012. Get nth highest and lowest salary of an employee. Declare @Tbl table(sal int). Insert into @Tbl(sal) values(12),(15),(20),(25),(8),(20),(18),(10). Set @TopNthSal = 3. Select distinct * from @Tbl order by sal desc. Select max(sal) as 'N-Highest' from @Tbl where sal not in ( select distinct top(@TopNthSal-1) sal from @Tbl order by sal desc ). Subscribe to: Post Comments (Atom). New Delhi, Delhi, India.
manish-sqlserver.blogspot.com
MS - Sql Server: UDF - Distence B/W two Lat Long
http://manish-sqlserver.blogspot.com/2012/10/udf-distence-bw-two-lat-long.html
MS - Sql Server. MS SQL Server Blog. DWH and MS BI Blog. Thursday, October 18, 2012. UDF - Distence B/W two Lat Long. Subscribe to: Post Comments (Atom). New Delhi, Delhi, India. Https:/ in.linkedin.com/in/manishpathak79. View my complete profile. Get All Tables and Its Column Name of a DB. UDF - Distence B/W two Lat Long. Convert String into camel case. Convert Number into RomanNo. Get Last date of Month. Get nth highest and lowest salary of an employee. Simple template. Powered by Blogger.