![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
文章平均质量分 68
raozhibo
Time can break it down/Time can bend the knee/Time can break a heart/Have you begging please
展开
-
Create country table and insert all the countries script for SQL Server
<br />INSERT INTO [country]([countryName],[countryCode])VALUES('AFGHANISTAN','AF');<br />INSERT INTO [country]([countryName],[countryCode])VALUES('ALAND ISLANDS','AX');<br />INSERT INTO [country]([countryName],[countryCode])VALUES('ALBANIA','AL');<br /原创 2011-05-12 05:52:00 · 1623 阅读 · 0 评论 -
Learning Store procedure and debug in SQL Server 2008
First store procedure:USE [TourReseller]GO/****** Object: StoredProcedure [dbo].[usp_users_login] Script Date: 03/23/2011 17:01:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[usp_users_login] (原创 2011-03-24 05:09:00 · 684 阅读 · 0 评论 -
Generate Data
<br />When you need to Generate dummy data, this is a great website to user<br />http://www.generatedata.com/<br /> <br /><br /> <br />GenerateData.com is a free service which quickly generate large volumes of custom data in a variety of formats (eg. E原创 2011-04-05 02:39:00 · 922 阅读 · 1 评论 -
Problems I run into about SQL Server 2008
<br />Change table column name in SQL Server 2008:<br /> <br />ALTER TABLE [Table Name]ALTER COLUMN [column name] [data type]原创 2011-04-30 05:03:00 · 438 阅读 · 0 评论