TSQL

Welcome to the 'TSQL' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'TSQL'.

Latest blogosphere posts tagged “TSQL”

• How do -You- use SQL Server

  
  Home of the Scary DBA — Authority: 126
  I’ve been tagged by a misplaced yankee, uh, New Englander, whatever . The question is, how do I/we use SQL Server where I work. That’s a tough one. It would make a much shorter, and easier, blog post to describe the things we don’t use it for. However, keeping with the spirit of these tags, I’ll try to lay ...
  2 days ago

• XQuery For Idiots

  
  Home of the Scary DBA — Authority: 126
  I’m still struggling with learning XQuery. My latest little revelation was small, but vital. The difference between: @inXML.nodes(/rss/channel/item) and @inXML.nodes(/rss[1]/channel[1]/item) Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that ...
  3 days ago

• Validate Email Addresses in SQL Server

  
  Sql Server Blog — Authority: 121
  I will be honest here – doing email address validation in SQL Server is one of the most challenging tasks a T-SQL programmer faces. Stefan Plattner sometime back on the forums shared a query to validate Email Address. I have been using this query in my applications and thought of sharing this with all of you ...
  5 days ago

• Find Number of Weeks in a Month using SQL Server

  
  Sql Server Blog — Authority: 121
  I have been asked this question plenty of times – How do I calculate the number of weeks in a month. The answer to this query depends on how do you define a week. For simplicity purposes, I will take a week from Sunday to Saturday as depicted in the calendar So November has 5 weeks! Let us write the query ...
  1 week ago

• Making date and time sense from the SQL Server Agent job history table

  
  MSMVPS.COM — Authority: 614
  Read More......( read more )
  1 week ago

• Making date and time sense from the SQL Server Agent job history table

  
  CraigN.NET — Authority: 108
  A bit of Transact-SQL code to help make sense of the sysjobhistory table date and time values.
  1 week ago

• CRM: Dell will propose the solutions of Salesforce. COM with its PC

  
  Script For All — Authority: 132
  CRM: Dell will propose the solutions of Salesforce. COM with its PC – Actualits – ZDNet. FrExit Windows 7 complete records id=”; talkbackform”; >; Your comment You N `ê your steps identifié to take part [...]
  1 week ago

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  stevienova.com — Authority: 105
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  1 week ago

• Tired of hearing “M” is to “T-SQL” what X is to Y…

  
  .Net Braindrops — Authority: 114
  I have heard a couple of variations of these analogies. I do not like them. I think they are simply absurd. At last PDC, “M” was to “SQL” what C is to Assembler. This year it was, what VB is to C. And now I even read this: The code name “M” language is like a more manageable (though more limited) form ...
  1 week ago

• Getting the name of the table in which a column with specified name appears

  
  Kris' blog — Authority: 115
  Sometimes you need to find out in which tables a certain column name exists. For examplewhen you want to find out where it’s being used as a foreign key. Here’s a handy scriptto use in T-SQL. SELECT OBJECT_NAME(object_id), * FROM sys.columns WHERE name = columnname This makes use of the OBJECT_NAME ...
  1 week ago

• title

  
  Script For All — Authority: 132
  Patch Tuesday Oracle: 38 corrective measures of scurit annoncs – Actualits – ZDNet. FrExit Windows 7 complete records id=”; talkbackform”; >; Your comment You N `ê your steps identifié to take part &worsen; the discussion, [...]
  1 week ago

• Update a Column with Random Numbers in SQL Server

  
  Sql Server Blog — Authority: 121
  In this blog post, I will show you how to update a database column with Random Numbers Let’s create a sample table DECLARE @TT table ( ID smallint , StudentID smallint , DayAlloted smallint ) -- Create Sample Data INSERT INTO @TT VALUES ( 101, 1, 0); INSERT INTO @TT VALUES ( 102, 2, 0); INSERT ...
  1 week ago

• Convert Month Number to Month Name in SQL Server

  
  Sql Server Blog — Authority: 121
  One of my blog readers mailed me asking a simple way to convert a month number to month name. Here’s the simplest way in my opinion: DECLARE @Mth smallint SET @Mth = 11 SELECT DateName (mm, DATEADD (mm,@Mth,-1)) as [MonthName] OUTPUT Similarly if you want to list all the month names for a year using ...
  2 weeks ago

• passing data between two SQL Server databases

  
  IT answers — Authority: 459
  New Question Created by LL123
  2 weeks ago

• T-SQL: Using cursor with Common Table Expressions

  
  Mehroz's Experiments — Authority: 105
  Cursors aren’t a bad choice for certain scenarios. Few days back, I was writing a stored procedure that was to be scheduled as a SQL agent job. I needed to send emails for each row of a result set and hence concluded that a Fast Forward cursor (Read Only, Forward only cursor) would be a nice choice. I created ...
  2 weeks ago

• Winning TSQL Challenge 12

  
  Mehroz's Experiments — Authority: 105
  It’s a source of great pleasure for me that I am included in the winners for TSQL challenge 12 . Here’s my post describing my solution and here’s the analysis by Jacob Sebastian, the founder and president of TSQL Challenges.
  2 weeks ago

• Executing a Stored Procedure using SQLCMD

  
  Sql Server Blog — Authority: 121
  Here’s how to execute a SQL Server Stored Procedure using SQLCMD. For demonstration purposes, I will be executing the ‘CustOrderHist’ Stored Procedure in the Northwind database. This procedure accepts the CustomerID and returns a list of orders placed by the Customer. Open your Command Prompt. I have a named ...
  2 weeks ago

• Drop All Objects in a SQL Server 2005 Database

  
  PimpThisBlog.com - Latest published stories — Authority: 466
  This post documents a T-SQL script used to dynamically delete all objects in a database.
  3 weeks ago

• Extracting DotNetNuke User Information With SQL

  
  PimpThisBlog.com - Latest published stories — Authority: 466
  It is not uncommon to have a client request a list of site users in a particular role. You can obviously get this information from the DotNetNuke user interface but its very easy to get this directly from the tables in SQL Management Studio and then export to a CSV or Excel file for easy distribution. Below is an ...
  3 weeks ago

• Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block

  
  Simple Talk rss feed — Authority: 422
  In which Phil is asked to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting ...
  3 weeks ago

Comments about TSQL