T-SQL (SS2K5)
-
Topics
-
Select with Cast/Convert, Inner Joins and show Nulls
Hi all Some help would be appreciated.
I am in the process of finding and preparing to extract … -
DDL Trigger to prevent dropping of a specific table?
Hi, I know DDL Triggers can monitor changes on both the Server level and Database level, which coul…
-
Baffled by duplicates despite selecting distinct values
I am getting the below error when trying to select distincts rows from a table into a temp table. :…
-
Need to convert a SQL field based on delimiter
Hi All, Need a urgent help from you. Please find the below sample script Create Table Test( ObjectI…
-
Trying to return simple results from a simple TSQL Query.
I am attempting to return results from a simple query in a comma separated format view (CSV). I hav…
-
datetime - 1/1/1900 treated as blank??
I knew that a datetime field defaulted to '1/1/1900' when the field contains blanks, but it's looki…
-
Apostrophe (') in Full-Text Search String
We use MS SQL Server 2005 full-text search. Our stored procedure for the search accepts a parameter…
-
The orders after 12 am to 7 am not show data problem
Hi guys I make sql query to select data every day by getdate function In sql server 2005 i write t…
-
Interesting question (maybe)?
Is possible with SQL create crossword puzzle named word square from table with words? Word square i…
-
Finding a NULL value in the record set
CREATE TABLE kiQCTest ( OrderNum varchar(10), OrderLine int, QCPass bit) INSERT INTO kiQCTest ([Ord…
-
Number of times a specific day of month occurs between 2 dates?
Hi, am trying to get to grips with the syntax needed for this...here is one set of example values..…
-
Call Stored Procedure from a Function
Has anyone tried calling a stored procdure from a user defined function. I have a procedure as Proc…
-
Question on OBJECTPROPERTY
This calls return NULL even if "TableName" exists in the Development DB and definitely has an ident…
-
Convert Datetime to TIME
hi I have the following query it works with SQL2008 servers as TIME is a validate data type....but …
-
set variable from openquery
I have the following openquery I need to set a variable for to process. THis below returns the valu…
Viewing 15 topics - 241 through 255 (of 12,234 total)
You must be logged in to create new topics.