T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Looking for Explanation for this

  For the queries below, the first one returns nothing, but the second one returns NULL Why does the …

  AndrewSQLDBA

  16 replies

  15 years, 6 months ago

  By: Paul White

• Unique Key on Text datatype

  Hi, here is my query that I wrote create table Login (LoginID int identity(5,5) Not null Primary K…

  RaviShankar1234

  8 replies

  15 years, 6 months ago

  By: Paul White

• How to convert DDMonYYYY into yy-mm-dd 00:00:00

  Hi how to convert DDMonYYYY into yy-mm-dd 00:00:00 Ex: i have date 13MAR2009:00:00:00 in varchar ..…

  dheer

  3 replies

  15 years, 6 months ago

  By: Paul White

• Calculating distance between 2 Easting & Northing values (UK)

  Yo! I have a db of location easting and northing values (from the Royal Mail PAF db) and I want to …

  Simon G

  6 replies

  15 years, 6 months ago

  By: Simon G

• Policy for certain logins password expiration check

  I have to create a policy on my server which checks password expiration enabled for each login or n…

  dallas13

  4 replies

  15 years, 6 months ago

  By: Welsh Corgi

• Passing the detail of a check constraint to an error message when using UDTTs

  Hi, I have created a table variable in SQL 2008 that is based on a user defined table type. The UD…

  barry.hostead

  9 replies

  15 years, 6 months ago

  By: Paul White

• xp_readmail

  Hi All I have configured sql mail on my server, xp_sendmail is working fine and sends email to rece…

  vsjayashri

  13 replies

  15 years, 6 months ago

  By: Elliott Whitlow

• No Profiler Trace Results

  Hello, I created a custom template on and select existing connection, rpc:starting, rpc:complete…

  doc_sewell

  4 replies

  15 years, 6 months ago

  By: Welsh Corgi

• How to Find the compatibility Level of the Storedprocedure/Functions.

  hi All How to Find the compatibility Level of the Storedprocedure/Functions. I mean If i Create a…

  deepak.a

  4 replies

  15 years, 7 months ago

  By: Steve Cullen

• Table Valued Parameters - Passing to Stored Procedures

  I have poked around this site looking for an answer to the question below. Hopefully I didn't miss…

  meichner

  4 replies

  15 years, 7 months ago

  By: meichner

• Query designer, some options are greyed out

  Hello, I'm trying to use query designer and am having a few problems. I have opend a new query win…

  Fishbarnriots

  7 replies

  15 years, 7 months ago

  By: doc_sewell

• UNC Path of filename

  How could I get the UNC path for a dirve letter filename such as local C:\templates\Template1.doc …

  C# Gnu

  7 replies

  15 years, 7 months ago

  By: C# Gnu

• Group all items per ID in one row

  Ok, so after alot of time, i finally got enough help to get me to this point and I am hoping that s…

  showtime-855194

  6 replies

  15 years, 7 months ago

  By: Raghavendra Mudugal

• want to retrive the date based on the date for every three months

  Hi i having the one table called oefforts , in that there is column called created date , in which…

  SAT_SQL

  4 replies

  15 years, 7 months ago

  By: Raghavendra Mudugal

• Looks like connection time out

  Hi, I am developing a small app in vb.net which takes the backup of database and then drops it. App…

  Sachin Diwakar

  12 replies

  15 years, 7 months ago

  By: Sachin Diwakar