Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Boolean
Aloha people. At the moment, I am having a problem with SQL 2005. I have just imported a massive >1GB MSAccess database (of all things) to SQL, and it went smoothely. Only one thing, it converted Yes/No (bool fields) to bits; Which is totally correct. The underlying application, all 120000... -
SQL: StoredProc to Create DB?
thanks, much appreciated. i did it another way actually :) I used: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_CreateUserLocalDB] @username varchar(255) AS BEGIN DECLARE @COPY1 varchar(255) DECLARE @COPY2 varchar(255) DECLARE @ATTACH varchar(255) DECLARE... -
SQL: StoredProc to Create DB?
Hello, I've been battling all day with this stored proc I tried to create. All I need it to do is create a table based on an arguement I pass it: CREATE PROCEDURE [dbo].[sp_CreateUserLocalDB] AS SELECT 0 GO -- -- Definition for stored procedure sp_CreateUserLocalDB : -- ALTER PROCEDURE...
