Forum Replies Created

Viewing 15 posts - 9,541 through 9,555 (of 13,459 total)

  • RE: How to select multiple columns from first table while using EXCEPT on two tables

    EXCEPT requires the same number of columns from both tables.

    remember it's comparing row to row based ont he columns you select, so you need to either remove Column 2 from...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 4, 2010 at 9:19 am

    #1161880

  • RE: Disabling implicit permissions

    yet another day where i learned something I didn't know.

    Thansk for this post, Brian. Good to know!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 4, 2010 at 9:16 am

    #1161875

  • RE: Installing SQL 2005 Standard w/SP3 on Windows 7 Ultimate

    yeah it's so easy once you've discovered ti you want to kick yourself... I found out the hard waywhen i bought a new laptop and installed both SQL 2005 and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 4, 2010 at 8:19 am

    #1161833

  • RE: Error

    the function you pasted is for Oracle, and contains a lot of stuff that is Oracle-only syntax.

    it cannot be directly compiled into SQL Server, you'll have to re-write it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 4, 2010 at 7:42 am

    #1161798

  • RE: Stored Procedure's Security

    with both .net and SQL server's built in tools, eventually someone can reverse engineer decrypt everything.

    SQL server has to be able to compile any encrypt stored procs/functions ; the WITH...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 4, 2010 at 7:38 am

    #1161795

  • RE: Yet another linkserver problem ....

    Opus it's been a while since i added an oracle linked server; here is the syntax i've used, i put in your server and username to what i think is...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 7:00 pm

    #1161563

  • RE: Installing SQL 2005 Standard w/SP3 on Windows 7 Ultimate

    Ray i had the same thing happen; locked out of a new install.

    the fix is to add yourself as an administrator; you should be able to find the SQL 2005...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 6:53 pm

    #1161561

  • RE: Migrating a Database

    ok completely different situation than i thought.

    Sybase is a database engine, the same way SQL Server is; you'd want to create a linked server in SQL Server to connect to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 6:35 pm

    #1161559

  • RE: Which Stored Procedure changed

    I'm surprised noone mentioned the Default Trace yet, that contains all the recent DDL Changes;

    there's a built in report from the default trace in SSMS: shows table drops and created,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 8:40 am

    #1161308

  • RE: Need help with UPSERT query

    Randy i would love to help; these questions are low hanging fruit for me, and helps anyone who reads the thread, but

    without the definitions of the tables, anything like an...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 8:09 am

    #1161289

  • RE: Replacing a column of data type - Image with varchar(MAX)

    you have to use a varbinary(max) to replace an IMAGE datatype;

    I just tested it, and by simply changing the datatype with this command, i did not get any errors...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 3, 2010 at 6:52 am

    #1161221

  • RE: Question

    najib_sherzadd (5/1/2010)

    Hello lowel brother,

    My table stracture like that

    create table salary(id int(9), name char(23), fathername char(23),

    Salary number(12))

    thanks,

    Najibullah sherzad

    OK Najibullah; i noticed the Salary is datatyped as number(12), so i...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 2, 2010 at 6:18 am

    #1160984

  • RE: Model

    easiest way is to simply right click on the model database and choose properties; the model by default is small; under 2 meg for the file, and 1 meg for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 2, 2010 at 6:02 am

    #1160981

  • RE: Migrating a Database

    SQL server has the ability to create a backup file of the database; that is ideal for disaster recovery and creating copies for developers to not fiddle with the live...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 2, 2010 at 5:56 am

    #1160979

  • RE: how to improve qurey perpormace

    lot of one line questions from you; without details, google and research may be your best bet;

    look at teh execution plan and determine if any indexes would help; make sure...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 2, 2010 at 5:32 am

    #1160976

Viewing 15 posts - 9,541 through 9,555 (of 13,459 total)