T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• datetime field

  i have a field in my table , its type is DateTime, now i want to write a storeprocedure for compari…

  nazaninahmady_sh

  5 replies

  14 years ago

  By: Lynn Pettis

• To create the sql server health check

  Can any one help to create a script to find out sql server health check i.e (We want to create aut…

  bala2

  8 replies

  14 years ago

  By: TheSQLGuru

• How to Set the execution order of DDL Triggers

  Hi ... Any one help to me , How to Set the execution order of DDL Triggers , I hvae 4 DDL triggers …

  PRAMANA.DBA

  1 replies

  14 years ago

  By: Lowell

• Connect to SQl Server from Unix

  Is there a microsoft recommended way of connecting to SQL Server from a Unix box? If YES then pleas…

  itskanchanhere

  1 replies

  14 years ago

  By: Ant-Green

• Kinda fancy reports with multiple counts and multiple group by

  Ok, I don't have an easy way to provide some sample data for this, but hopefully this is a simple c…

  pixelwiz

  5 replies

  14 years ago

  By: CapnHector

• SQL to Access conversion

  Hi All, I want to convert the following SQL statement into Access 2010 SQL so i can run the query i…

  martin.kerr 34088

  2 replies

  14 years ago

  By: toddasd

• Error Output using T-SQL

  Hi, Please give any ideas on implementing error output using T-SQL. I am trying to import data from…

  UnionAll

  3 replies

  14 years ago

  By: Ron McCullough

• Help with creating a trigger

  I don't usually do triggers, but because my senior DBA is out on vacation, I need some help... So h…

  SQL_Enthusiast

  5 replies

  14 years ago

  By: CapnHector

• sql parameters

  I am working on a sql server 2008 r2 database to run adhoc queries. I would like to be able to run …

  dianerstein 8713

  9 replies

  14 years ago

  By: Grant Fritchey

• I'm Sure its Something Simple! Returning Different Companies Based on Parameter

  Hi All Need help, I think I've just been looking at this for too long and got brain freeze and am m…

  Andy Hyslop

  5 replies

  14 years ago

  By: Andy Hyslop

• How to deploy scripts??

  Hi all, I am in a new project where I am the only SQL Server resource. I have been provided SSMS fo…

  itskanchanhere

  8 replies

  14 years ago

  By: CapnHector

• rebuild index with -2

  hello guys, i have a sql 2008 r2 instance database that is around 40 GBs. In this database there i…

  DBA-640728

  13 replies

  14 years ago

  By: Gail Shaw

• Sql server Transactions are Atomic .Looking for a Live Example

  hi everyone, I have tried the below Sql as a try out to Confirm and see if Transaction in Sqlserv…

  chaithu559

  2 replies

  14 years ago

  By: Suresh B.

• load data and foreign keys

  Since I am new to setting up a database on sql server 2008 r2 and creating tables that are referenc…

  wendy elizabeth

  21 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• need help

  Hi, I need some help with the below query. select convert(Varchar(10) ,a.Date,101) AS Date, SU…

  sql2k8

  2 replies

  14 years ago

  By: ColdCoffee