Programming SQL

i couldnt take the column binding default values script through S
Following Code is for taking table script through smo , i can take TABLE,PK ,FK, but i couldnt take the column binding default values script through SMO (EXEC sys.sp_bindefault @defname=N'[dbo].[def_BitTrue]', @objname=N'[dbo].[tTS_User].[IsActive]' , @futureonly='futureonly') can any one help me adv tha... 3 Jul 2008 08:23

DELETED and INSERTED tables in UPDATE TRIGGER
Hello, I have a table with complex primary key( consisting of two fields ). MSSQL2005 Example: CREATE TABLE PersonPhone( PerId INT NOT NULL, PhnId INT NOT NULL, PhnType BIT NOT NULL, CONSTRAINT PK_PersonPhone_PerId_PhnId PRIMARY KEY (PerId, PhnId), For this table I have INSTEAD OF UPDATE trigge... 6 Jul 2008 05:51

Identify table/index scans using SQL Server Profiler
Hi, I'm using SQL Server 2000 sp4. Huge database (100+ tables), huge application. Is there a way to use SQL Profiler to filter out all table/index scans? I get some info with SP:Completed and SP:StmtCompleted ("Reads" column) but especially for cascade deletes I cannot easily figure out what's being scanne... 21 Jul 2008 08:56

Query
Hi Guys Any one please help me below query what is the meaning. IIF(RTL_SML_CONTRACT.TERM_DT=0 Or RTL_SML_CONTRACT.BOOKING_DT=0, 0, CDate(Mid$(RTL_SML_CONTRACT.TERM_DT,5,2) & "/"& Right$(RTL_SML_CONTRACT.TERM_DT,2) & "/" & Left$(RTL_SML_CONTRACT.TERM_DT,4))-CDate(Mid$ (RTL_SML_CONTRACT.BOOKING_DT,5,2) & "/"... 4 Jul 2008 15:08

Listing tables in a database
Hi! I'm using the following procedure to list all tables in a selected database. Select Table_name as "Table name" From Information_schema.Tables Where Table_type = 'BASE TABLE' and Objectproperty (Object_id(Table_name), 'IsMsShipped') = 0 However, it shows me only the tables in dbo schema. How ... 3 Jul 2008 09:25

How to Create a Parameterised GROUP BY Without Using Dynamic-S
What you describe is actually a typical case for using SSAS. On top of that you can also make great use of SSRS as the front end. Why reinvent the wheel? If nothing else, you can at least give SSAS a chance over the weekend. ;) You'll quickly see how much time you've already wasted. ML --- Matija Lah,... 3 Jul 2008 06:21

SELECT * FROM @Table
I know if I want to write a SELECT statement which TABLE could be "variable" I should use "Dynamic Syntax"... but Is there other way to do so? I mean, something in which TABLE in SELECT works like a "@Table" variable. Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 06:21

CREATE TABLE from other (correction)
I am testing the following command : CREATE TABLE NewTable AS (SELECT * FROM Table WHERE 1=2) to create a new table from existing one and no registers, but sends me an error "near AS"... What is wrong? Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 04:18

CREATE TABLE from other
I am testing the following command : CREATE TABLE AS (SELECT * FROM Table WHERE 1=2) to create a new table from existing one and no registers, but sends me an error "near AS"... What is wrong? Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 07:22

job in ausland arbeiten als koch im ausland jobboerse praktikum arbeiten im ausland info Berufsfeuerwehrfrau Berufsfeuerwehrmann ausland jobs de job erzieherin im ausland arbeiten
job in ausland arbeiten als koch im ausland jobboerse praktikum arbeiten im ausland info Berufsfeuerwehrfrau Berufsfeuerwehrmann ausland jobs de job erzieherin im ausland arbeiten + + + ARBEITSANGEBOTE IM AUSLAND http://WWW.STELLENANGEBOT-AUSLAND.DE http://WWW.STELLENANGEBOT-AUSLAND.DE + + + AUSLA... 3 Jul 2008 02:16